Question Computer Mcq

Circle the letter or fill in the correct answer .

1) Computer ________________ refers to acquiring computer related skills. a) b) c) d) e)

Competency Aware Connectivity Networked active

2) The _________ consist(s) of the following equipment: keyboard, mouse, monitor, system unit, and other devices. a) b) c) d) e)

People Procedures Hardware System unit Information

3) The __________ is one of the system software programs. a) b) c) d) e)

Word processor Database management system Operating system Application software Information software

4) Browsers, word processors, and spreadsheets are _________ applications. a) b) c) d) e)

Specialized Basic Advanced Artificial intelligence Multimedia

5) A ___________ computer is another name for a note book computer. a) b) c) d)

PDA Laptop Midrange DVD

e) Handheld 6) ___________ is sometimes referred to as temporary storage. a) b) c) d) e)

PDA CD RAM DVD SECONDARY STORAGE

7) ___________ disks use laser technology. a) b) c) d) e)

Concentric Layered Hard Floppy Optical

8) A __________ file might contain audience handouts, speaker notes, and electronic slides. a) b) c) d) e)

Document Database Worksheet Presentation Floppy disk

9) The term ________ refers to the widespread use of mobile communication devices. a) b) c) d) e)

IT Wireless revolution PDA RAM WWW

10) The largest network in the world is called the _____________ a) b) c) d) e)

Internet WWW World Wide Web Web DVD

11) The internet was launched in 1969 when the United States funded a program to develop a national computer network called____________ a) b) c) d) e)

ARPANET CERN The web WWW IRC

12) _____________ use telephone lines and services an area limited to several states. a) b) c) d) e)

Wireless service providers National service providers Local service providers Regional Service Providers Commercial ISPs

13) _________ connect(s) to remote computers, open(s) and transfer(s) files , display(s) text and images, and provide(s) in one tool an uncomplicated interface to the Internet and Web. a) b) c) d) e)

Bots Browsers Java Web Utilities Wizards

14) The computer that stores and shares Web page resources are called a ___________ a) b) c) d) e)

Web portal Web Server telnet ISP Applet

15) ___________ is often attached to the unsolicited e- mails. a) b) c) d) e)

Spam E-Mails Addresses Web pages Computer viruses Applets

16) ___________ programs identify and eliminate unwanted and unsolicited emails a) b) c) d) e)

Media Anti- Spam Search DSL Meta

17) To participate in a chat group, selects a ___________ and communicate live with others. a) b) c) d) e)

Signal Index Engine List Channel

18) In a directory or __________ search, you select a category that fits the information you want. a) Packet b) Keyword c) Index d) Specialized e)

Subject

19) In ____________ commerce, individuals typically sell to other individuals without ever meeting face-to-face a) b) c) d) e)

C2C B2C B2B C2I I2

20) ___________ are programs that are automatically loaded and operate as a part of a browser. a) b) c) d) e)

Plug-ins Add-ons Providers Agents Applets

21) Service programs are another name for _____________ a) b) c) d) e)

Operating system Utilities Device drivers Language translators Interfaces

22) Language translators convert human language into___________ a) b) c) d)

Machine language UNIX Service programs Operating system

e) EBCDIC

23) The process of starting or restarting the computer is called _____________ a) b) c) d) e)

Booting Docking Embedding Fragmenting Tracking

24) Desktop operating systems are also called __________ operating systems. a) b) c) d) e)

Network Embedded Server Mac Stand- alone

25) ___________ provides online assistance for operating system functions. a) b) c) d) e)

Menu The platform Explorer Utility Help

26) The ___________ operating system was originally designed to run on minicomputers in networks environments. a) b) c) d) e)

Windows Mac OS UNIX Sherlock Norton

27) To remove unneeded programs and related files from a hard disk you would use a (n) program a) b) c) d)

Backup Troubleshooting File compression Antivirus

e) Uninstall 28) Files that are broken into small parts and stored wherever space is available are said to be___________ a) b) c) d) e)

Compressed Fragmented Lost Uninstalled Sectored

29) ____________ is a windows program that locates and eliminates unnecessary fragments and rearranges files and unused disk space to optimize operations. a) b) c) d) e)

Disk cleanup Active desktop Sherlock Disk Defragmenter Resource locator

30) Norton System works is a ___________ a) Troubleshooting program b) Utility c) Utility suite d) None of the above e) Web service

31) The system unit is called the ___________ a) b) c) d) e)

PDA System board System Cabinet And Chassis Mother board Chassis

32) ___________ are the most widely used handheld computer. a) b) c) d) e)

RAMs Notebooks PDAs CPUs Tower units

33) ASCII, EBCDIC, and Unicode are examples of __________ a) b) c) d) e)

Analog system Integrated circuits Binary Coding Schemes Adapter cards Slots

34) ___________ connects special cards or circuit boards to the system board a) b) c) d) e)

Slots Carrier packages Unicode PC cards Ports

35) Random-Access Memory (RAM) is a kind of __________ storage a) b) c) d) e)

Permanent Temporary Flash Smart Expansion

36) ___________ is a temporary high speed holding area between memory and CPU. a) b) c) d) e)

Flash ALU ASCII Cache CMOS

37) ROM is also known as _____________ a) b) c) d) e)

Semiconductor Slot Adapter Network Firmware

38) A (n) ___________ chip provides flexibility and expandability for a computer system; it contains essential information that is required every time the computer system is turned on. a) b) c) d) e)

ROM RAM TCP/IP CMOS ALU

39) ___________ is a set of hardware and software standards that allows expansion boards and other devices to install themselves. a) b) c) d) e)

Plug and play Unicode System unit Industry standard architecture EBCDIC

40) A (n) __________, is also called a bus, connects the parts of the CPU together. a) b) c) d) e)

Adapter card Parallel port Serial port ISA Bus line

41) A (n) ____________ mouse emits and senses light to detect movement. a) b) c) d) e)

Mechanical Cordless Wireless Pointer Optical

42) A __________ allows you to control the pointer by moving and tapping your finger on the surface of a pad. a) b) c) d) e)

Touch surface Touch pad MICR Mouse Digitizer

43) A Wand Reader Is A Type Of ___________ Reader. a) b) c) d) e)

MICR Barcode OMR Touch surface MIDI

44) ____________ are specialized digital video cameras that capture images and send them to a computer for broadcast over the internet. a) b) c) d) e)

OMR devices Mark sensing devices Web Cams Graphic tablets Digital cameras

45) Voice recognition systems use a microphone, a _____________, and special software. a) b) c) d)

Sound card Keyboard shortcut Toggle key MIDI device

e) Scanner 46) A handheld, book –sized device used to read download content is a (n) __________ a) b) c) d) e)

Wand reader E book Light pen Graphic tablet Stylus

47) Printers convert information output to human language or symbols and transfer it onto paper as ___________ a) b) c) d) e)

Soft copy Hard Copy TFT Dot- matrix Facsimile

48) ____________use a technology similar to that used in a photocopier. a) b) c) d) e)

Laser Printers Ink- jet printers Plotters MIDI Dot- matrix printers

49) ____________ uses the Internet rather than traditional communication lines to connect two or more people via telephone. a) b) c) d) e)

A multifunctional device A fax machine A dumb terminal Telephony An output device

50) A net work computer is also known as a (n) ___________

a) b) c) d) e)

Thin client Intelligent terminal Dumb terminal Net PC Web terminal

51) _____________ is a permanent storage used to preserve data programs. a) b) c) d) e)

Nonvolatile storage Volatile storage Internal storage File compression Read only memory

52) ___________ is the process of accessing files from a disk. a) b) c) d) e)

Reading Writing Printing Spanning Caching

53) ___________ measures the amount of time required by a storage device to retrieve data and programs. a) b) c) d) e)

Capacity Media Reading Access Time Primary storage

54) Another name for floppy disk is ____________ a) b) c) d) e)

Diskettes Disks Flexible disks Floppies All of the above

55) _____________ refers to how tightly bits can be packed. a) Density

b) c) d) e)

Pit Multithread Section Zip

56) Files cannot be written onto a floppy disk when the write- protection notch is ___________ a) b) c) d) e)

Zipped Open Sealed Crossed Closed

57) The internal hard disk is also known as a ___________ because it is located inside the system unit. a) b) c) d) e)

Hard disk pack Fixed Disk PC card hard disk Removable disk Hard disk cartridge

58) The internal hard disk is typically referred to as the _____________ drive. a) b) c) d) e)

A B C Alternate Secondary

59) ____________ can provide over two hours of high – quality video and sound comparable to that found in theatres. a) b) c) d) e)

CD-RW CD CD-ROM DVD-ROM Picture CD

60) ____________ is exclusively a sequential-access storage media. a) A floppy disk b) A hard disk

c) Magnetic Tape d) Photo CD e) WORM

61) Gnutella uses a ___________ network strategy. a) b) c) d) e)

Terminal Peer-to-peer Client/server Wireless NIC

62) ____________ use satellites to determine geographic locations. a) b) c) d) e)

TCP/IP OSI GPS DSL NOS

63) Standard telephone lines and conventional modems provide what is called_________ a) b) c) d) e)

Network architecture Broadband Dial-Up Service Data transmission Channels

64) Modulation or demodulations are processes of a (n) _____________ a) b) c) d) e)

Connection device Mode Modulator Modem OSI

65) ____________is a measurement of the capacity of the communication channel. a) b) c) d) e)

Protocol Packet Network architecture IP address Bandwidth

66) Every computer on the Internet has a unique numeric address called a (n) ________ a) b) c) d) e)

Packet Protocol Network bridge IP address Bandwidth

67) _____________ controls and co –ordinates the activities of all computers and devices on a network. a) b) c) d) e)

TCP/IP NOS DNS OSI DSL

68) ___________use wireless receivers as a hub. a) b) c) d) e)

WLANs Microwaves LANs MANs Satellites

69)___________ describes how the network is arranged and how the resources are coordinated and shared.

a) b) c) d) e)

Topology Communication channel Sharing system Domain name system Network architecture

70) In a ___________ network, each device in the network handles its own communications control. a) b) c) d) e)

Bus Client Host Sharing Polling

Match each numbered item with the most closely related lettered item. Write your answers in the space provided.

A. Application software B. Computer network C. Connectivity D. Database files E. Document files F. Hard disks G. Information H. Input device I. Mainframe computer J. Microcomputers K. Optical disks L. Input device M. Primary storage N. Procedures O. Program P. Secondary storage device

Q. R. S. T.

Super computers System software System unit The internet

1. Guidelines people follow when using software. _________ 2. Consists of the step-by-step instructions that tell the computer how to do its work.________ 3. Although not the most powerful, this type of computer is capable of great processing speeds and data storage._________ 4. Allows sharing of information worldwide. __________ 5. Software that enables the application software to interact with the computer hardware. _________ 6. End user software. _________ 7. The most powerful type of computer. _________ 8. Data that has been processed through the computer. _________ 9. Translates processed information from the computer into a form that human can understand. _________ 10.

Container that houses most of the electronic components that

makeup a computer system. __________ 11.

The least powerful and most widely used type of computer.

_________ 12.

Translates data and programs that humans can understand into

a form that the computer can process. _________ 13.

Created by database management programs. _________

14.

Holds data and programs even after electric power to the

system has been turned off. ________ 15.

Typically used to store programs and very large data files.

__________ 16.

Uses laser technology. ________

17.

Created by word processors to save documents. __________

18.

Holds data and program instructions for processing data.

________ 19.

Communications system connecting two or more computers.

________ 20.

The largest network in the world. _________

A. Applets B. Buddy C. Carders D. Computer virus E. DSL F. E-cash G. E-commerce H. Header I. Hits J. Hyperlinks K. Lurking L. Metasearch engine M. Plug-in N. Signature line O. Subscription address P. Surfing Q. URLs R. Web auction S. Web page T. Web storefronts

A. Connection technology used by ISPs. _________ B. Another name for IM friend. __________ C. Addresses of web resources. __________ D. Moving from one website to another. __________ E. Special programs written in java. _________ F. HTML document displayed by a browser. _________ G. Part of an e-mail message that includes the subject, addresses, and attachments. _________ H. Typically includes the sender’s name, addresses, and telephone number.________ I. To participate in a mailing list, you must send a request to this address. _______ J. Links that connect to other documents. __________ K. reading and observing discussion without participating L. Program that starts and operates as part of browser. _________ M. The list of sites that contains the keywords of a keyword search. _________ N. Program that automatically submits a search request to several search engines simultaneously. _________ O. Buying and selling goods over the Internet. __________ P. Destructive programs

often attached to unsolicited e-mail. _________

Q. Virtual stores for B2C electronic commerce. ___________ R. Similar to a traditional auction, but buyers and sellers typically interact only on the web. _________ S. Criminals that specialize in stealing, trading, and using stolen credit cards over the Internet. ________ T. Internet equivalent to traditional cash. __________

A. Antivirus program B. Backup program C. Desktop OS D. Embedded OS E. File compression program F. Folders G. Foreground H. GUI I. Icons J. Linux K. Mac OS L. Multitasking M. NOS N. Network server O. Open source P. Operating systems Q. Proprietary OS R. Sector S. Track T. Utilities

A. Software that deals with the complexities of computer hardware. ________ B. Program that coordinate computer resources. __________ C. Concentric ring on a disk. _________ D. Wedge shaped section. _________ E. Where the active program runs. _________ F. Graphic elements that represent commonly used features. __________ G. A computers ability to run more than one application at a time. _________ H. Operating system completely stored within ROM memory. __________ I. Operating system used to control and coordinate computer that are linked together. _________ J. Operating system whose code is made available to outside individuals for improvements. __________ K. A computer that coordinates all communication between other computers. _________ L. An operating system located on a single stand –alone hard disk. __________ M. Operating system used by Macintosh computers. __________ N. Uses graphical elements like icons. ___________ O. along with files, a component of the system that windows stores information in. __________ P. One popular, and free, version of the UNIX operating system . ___________ Q. Operating system owned and operated by a company. __________ R. Guards computer systems against damaging and invasive programs. _________ S. Makes copies of files to be used if originals are lost or damaged. __________

T. Program that reduces the size of files for efficient storage. __________

A. Analog B. Bus width C. Cables D. Cache memory E. Chip F. CISC chip G. Closed architecture H. Control unit I. Expansion card J. Flash RAM K. Firmware L. Graphics coprocessor M. Parallel port N. PC cards O. Port P. RAM Q. Smart card R. System board S. System clock T. System unit

Sukh Sagor Institute Test ID: 36

Name: ___________________________

Date: _December 22, 2005_

1. (350). Implementation of ________ model has given way to Client/Server Systems

(A). File Management system

(B). Hierarchical Database system

(C). Network Database System

(D). Relational Database System

2. (70). In _____, the work of both the host and the terminal is carried out by itself.

(A). Centralized Systems

(B). PC

(C). LAN

(D). WAN

3. (120). Powerful file server is required by ______ system(s).

(A). LAN

(B). Centralized

(C). None

(D). Both

4. (260). _______ computing strikes a balance between the two extremes of the dumb client and

dumb server forms of computing

(A). Client/Server

(B). Distributed architecture

(C). PC

(D). Centralized systems

5. (60). The ______ do not have processing power of their own and has only a screen, keyboard,

and the necessary hardware to communicate with the host. For this reason, the terminals are referred to as the

(A). "dumb terminals".

(B). "dumb servers"

(C). dummy terminals

(D). dummy servers.

6. (240). Most of the applications that run on local area networks prefer_______ configuration.

(A). Dumb servers

(B). Dumb clients

(C). Both


7. (360). The efficiency of the Client/Server system depends on _____

(A). Type of the front end used

(B). Type of the back end used

(C). Amount of workload

(D). All of the above

8. (20). Two systems the ______and the ______work together in such a way that the total

workload is shared.

(A). File server, data server

(B). Mainframe, remote server

(C). Client, server

(D). Pc , mainframe computer

9. (30). Client/server could be used to refer to the system in which the _____is split between two

separate

components.

(A). Memory management

(B). O/S management

(C). Data processing


10. (180). The ______handles data processing and disk access in a C/S architecture.

(A). Host

(B). server

(C). Back-end

(D). Front-end

11. (270). _____________ distributes the workload equally on the client and server thereby

utilizing their resources.

(A). Client/Server


(C). PC


12. (450). A user could initiate a new process of execution at the background while the user can

continue his query process as usual in the foreground. This situation is referred to as ______

(A). Multiprocessing

(B). Multithreading

(C). Multiplexing

(D). None of the above

13. (440). New process of execution is referred to as _____.

(A). Task

(B). Process

(C). Thread

(D). Client-process

14. (490). _______is/are a popular front-end tool

(A). Visual Basic

(B). Power Builder

(C). SQL*Plus


15. (150). Network server that may be

(A). an advanced PC

(B). a minicomputer

(C). a mainframe

(D). any one of the above

16. (390). The most commonly preferred platform for Client/Server computing is _____.

(A). PC.

(B). Mainframes

(C). Client

(D). Microcomputers

17. (230). In a C/S architecture, if the client is of minimal processing power , the configuration is

called

(A). Weak client

(B). Dumb client

(C). Minimized client

(D). Idle client

18. (200). __________ performs the data search and sends back only data which was

requested.

(A). Database server

(B). Client

(C). Front-end

(D). PC

19. (470). The process of data being automatically written to a duplicate database is called

_______

(A). Repairing

(B). Redo logging

(C). Disk reflection

(D). Disk mirroring

20. (100). In LAN enabled PC , the data processing is done by the _____.

(A). File server

(B). Remote server

(C). PC

(D). Both PC and file server

21. (410). ______ prevents Time slicing-- splitting CPU's time for different tasks.


(B). Multithreading

(C). Multiplexing

(D). Multitasking

22. (160). Client is commonly referred to as _____ system.

(A). Main

(B). Front-end

(C). Back-end

(D). Host

23. (500). Since the Client/Server technology is based on relational DBMS , it offers advantages

(A). data integrity

(B). data security

(C). locks

(D). all of the above

24. (380). _________ is a platform

(A). PCs,

(B). UNIX workstations,

(C). minicomputers,

(D). All the above

25. (130). In ____ system data is shared among different hosts.

(A). LAN

(B). Distributed computing

(C). Centralized

(D). Mainframes

26. (110). The work of file server in LAN is to _______.

(A). Search and send data

(B). Data processing

(C). Memory management


27. (190). Both the DBMS and the application resides on the same component in a

______system.

(A). PC

(B). LAN

(C). Distributed computing

(D). Centralized

28. (220). In the host processing,_______ client terminal(s) can access a single host computer

(A). single

(B). two parallel

(C). maximum of 12

(D). More than one

29. (420). ______capability-support concurrent users doing different tasks.


(B). Multithreading

(C). Multiplexing


30. (50). In a centralized system, All the data processing is done in the______computer

(A). Client

(B). main "host"

(C). remote server

(D). file server

(E). I

31. (40). In a ______system, numbers of terminals are connected to a single main computer.

(A). Centralized

(B). PC

(C). LAN

(D). WAN

32. (210). When all the processing is done by the mainframe itself, the type of processing is

sometimes called as

(A). Server processing

(B). Host processing

(C). Dumb processing

(D). Data processing

33. (90). A ____is nothing but a PC with a Network operating system

(A). WAN

(B). Distributed computing system

(C). Windows NT

(D). LAN

34. (140). Location transparency is achieved in ________ system.

(A). LAN


(C). Centralized

(D). Mainframes

35. (430). ______ allows an application to multitask within itself


(B). Multithreading

(C). Multiplexing


36. (290). ______ is made responsible for retrieving, sorting, filtering the data and also for

ensuring security in a C/S architecture.

(A). Client

(B). Server

(C). Network


37. (340). _________ is the most advantageous database system.





38. (370). The hardware and the software requirements together form the ______

(A). Platform

(B). Configuration

(C). Package

(D). System

39. (170). _____system and is responsible for handling the screen and user I/O processing.

(A). Host

(B). server

(C). Back-end

(D). Front-end

40. (400). _________ is the capability of the OS to run numerous applications simultaneously.


(B). Multithreading

(C). Multiplexing

(D). Multitasking

41. (80). In a LAN the data and the application reside on a _____

(A). Data server

(B). PC

(C). Host computer

(D). File server

42. (310). The server filters and sends only the relevant data requested in case of the ________

configuration.

(A). Dumb server

(B). Dumb client

(C). Client/Server

(D). All the above configurations

43. (300). The network traffic is reduced in case of _________.

(A). Dumb server

(B). Dumb client

(C). Client/Server


44. (250). A dumb server can be

(A). file server

(B). print server

(C). both together

(D). a or b

45. (480). Multiple changes to the same record or a field are prevented by the DBMS through

______.

(A). Fixes

(B). Locks

(C). Constraints

(D). Traps

46. (320). DBMS models can be grouped under _______ categories

(A). Four

(B). one

(C). two

(D). many

47. (440). In advanced filter, the criteria occupying multiple columns but more than one row, is considered as an ______ criteria.

(A). AND

(B). OR

48. (30). The wizard that is used to suggest hints for doing a Task

(A). Pivot table wizard

(B). chart wizard

(C). ConvertText to Columns wizard

(D). Tip Wizard

49. (170). The function that is used to join cell values together in a single cell

(A). Concatenate

(B). pmt

(C). merge

(D). none of the above

50. (40). The wizard that used to build an interactive table from data existing on sheets


(B). chart wizard


(D). Tip Wizard

51. (460). A pie chart can represent only one data series at a time

(A). True

(B). False

52. (610). The Accounts Head of ABC Ltd. wants to finalise the annual budget for year 2000 but as HR policies are in the process of revision; he is unable to predict exact expenses that will be incurred due to revised salary structure. Which one of the following will be the tool that will help the him to finalise the budget under this circumstances ?

(A). Pivot table.

(B). Scenario manager.

(C). Solver

(D). Data table.

53. (100). Which of the following files could not be opened in Excel from the following

(A). TextFiles

(B). Lotus1-2-3

(C). QuattroPro or Xbase files

(D). Class files

54. (140). The _______ can be used to select the function and assemble the arguments correctly

(A). AutoSum

(B). Autofill

(C). FunctionWizard


55. (560). The stacked bar graphs can be represented in ( Choose One )

(A). 3-dimensions.

(B). 4-dimensions.

(C). Multi-dimensions.

(D). 2dimensions.

56. (90). Pick out the window that is a not a form of Excel

(A). Application Window

(B). Document Window

(C). Modal Window


(E).

57. (240). The command that is used to apply a format automatically

(A). Autoformat

(B). Autofill

(C). Print-area


58. (490). The state government needs to finalise a five years plan to implement 100% literacy in the state. Which one of the following will be the best tool that should be used to work out the plan ?

(A). Pivot table.


(C). Solver

(D). Data table.

59. (330). In a chart X-Axis is known as

(A). Series or Rank

(B). Category

(C). Legend

(D). Data Marker

60. (430). In Excel, the subtotal command also generates grand total after the last

group subtotal

(A). True

(B). False

61. (420). The chart that is used for displaying stock market information

(A). line chart

(B). barchart

(C). stock chart

(D). pie chart

62. (160). Which of the following do not belong to the formula category in Excel environment

(A). Text

(B). Logical

(C). Numeric

(D). Boolean

63. (410). Which of the following tool cannot be used to view the Excel Web page

(A). Excel97

(B). InternetExplorer

(C). NetScape

(D). Word2000

64. (290). The option that is used to cancel the filter process for a specific column and display all the records is ___________

(A). All option

(B). blanks

(C). all blanks

(D). none

65. (370). The chart that holds the column chart is _______________.

(A). Column Chart

(B). Bar chart

(C). PIE chart

(D). Surface Charts

66. (310). That Table that allows the user to change or rearrange the data, summarize the data and evaluate the data using changing points of view is known as

(A). Data Table

(B). Filtered Table

(C). Index Table

(D). Pivot Table

67. (120). The command to display the current date in a cell is

(A). =Today()

(B). =date()

(C). =currentdate


68. (390). The chart that is used to display discrete data

(A). Column Chart

(B). Bar chart

(C). PIE chart

(D). Surface Charts


(A). Autoformat

(B). Autofill

(C). countif


70. (480). Which one of the following statements related to stock chart is NOT TRUE ?

(A). It is also called as high-low-close chart.

(B). It shows trends over time.

(C). It is often used to display share market prices over a period of time.

(D). It is also used for indicating fluctuations in temperature changes.

71. (500). Forecast'99 is a group working on exit poll. It wants to know how many seat ABC party needs to won in totality to obtain majority to form the government. Which one of the following will be the tool that will help the team ?

(A). Goal seek.

(B). Scenario manager

(C). Pivot table

(D). Data table.

72. (10). The wizard that is used to import text files

(A). Text Import Wizard

(B). ConvertText to Columns Wizard

(C). TipWizard

(D). Function Wizard

73. (340). ________ is a set of tables that describe each of the data series

(A). Series or Rank

(B). Category

(C). Legend

(D). Data Marker

74. (130). In Excel, Absolute references are represented by a __________ before the column and row addresses

(A). Dollar Sign

(B). "=" Sign

(C). # Sign


75. (110). In Excel , the dates that are stored as sequential numbers known as

(A). serial values

(B). domain values

(C). range values

(D). reference values

76. (300). There are ________ types of data tables

(A). 1

(B). 2

(C). 4

(D). 5


(A). Goal seek.


(C). Pivot table.

(D). Data table.

78. (530). Which one of the following is NOT the component of the pivot table ?

(A). Column field

(B). Row field.

(C). Source table name.

(D). Pivot table item.

79. (510). Which one of the following will be the tool that provides a way to view and compare the results of all the different variations together on the worksheet ?

(A). Goal seek

(B). Pivot table

(C). Solver

(D). Data table.

80. (350). __________ is used to differentiate one data series from another

(A). Series or Rank

(B). Category

(C). Legend

(D). Data Marker


(A). Pivot table.


(C). Solver

(D). Data table.


(A). Pivot table.


(C). Solver

(D). Data table.

83. (180). The function that is used to count all the values that meet specific criteria

(A). countif

(B). vlookup

(C). pmt

(D). count

84. (150). Specific parts of information required by functions to perform certain tasks are called as

(A). Variables

(B). arguments

(C). parameters


85. (270). A particular part of a work sheet can be printed by setting the __________.

(A). Page-setup

(B). Print-area

(C). Print

(D). Print-preview

86. (70). The __________ wizard separates contents in a cell into different cells



(C). TipWizard


87. (280). The process of finding or selecting information is known as

(A). Filtering

(B). Searching

(C). Sorting



(A). 3-dimensions.

(B). 4-dimensions.


89. (60). A workbook consists of many _______

(A). Databases

(B). records

(C). tables

(D). Worksheets

90. (550). Filtering rearranges a list to display the required records.

(A). True.

(B). False

91. (20). The wizard that is used to create and edit charts


(B). chart wizard


(D). Tip Wizard

92. (80). A spreadsheet is a grid of rows and columns and is called as a ____________

(A). Worksheet

(B). Workbook

(C). Tables

(D). Database

93. (360). The chart that is contains only one data series is ______________

(A). Column Chart

(B). Bar chart

(C). PIE chart

(D). Surface Charts

94. (190). The function that is used to calculate the payment for specific loan terms

(A). SUMIF

(B). PMT

(C). countif


95. (200). The function that is used to add together all values that meet specific criteria is known as

(A). average

(B). sum

(C). sumif

(D). countif


(A). Autoformat

(B). Autofill

(C). none of the above

97. (540). Excel allows upto ______ levels of sorting.

(A). Two

(B). Three.

(C). N

98. (580). Which one of the following statements related to stacked bar chart is NOT TRUE ?

(A). It displays the data series one on top of the other.

(B). It is useful when several components are changing and the user is interested in the sum of the components.

(C). It can be represented in 3-dimensions.

99. (620). Which two of the following functions are used in subtotal option ?

(A). Count

(B). sqrt

(C). Mean

(D). Standard deviation.

100. (260). The _________ makes the information in a worksheet meaningful and easy to understand

(A). Bordering

(B). Formatting

(C). Shading


101. (600). _____________ option in publish to web wizard produces a page that is static in

nature.

(A). Static file

(B). Static HTML

(C). Dynamic File


102. (560). The application that supplies data in OLE is called an _________

(A). OLE object

(B). OLE Client

(C). OLE server

(D). OLE Communicator

103. (320). _______________ allows us to create a filter from afields shortcut menu.

(A). filter by form

(B). filter by report

(C). filter by record

(D). filter by input

104. (170). _________ is the wild card character which represents the presence of any charecter.

(A). &

(B). #

(C). ?

(D). *

105. (100). The collection of related data and objects is called a___________.

(A). Database

(B). form

(C). collection


106. (210). Large amount of data can be summarized using _______ tables.

(A). Pivot

(B). create

(C). from


107. (40). ___________ option from the Tools menu is selected for setting relationships between

tables.

(A). Set Relation

(B). Connect

(C). Relationships


108. (60). ___________ query is used to add records from one or more tables into an existing

table.

(A). add

(B). append

(C). insert

(D). delete

109. (290). ___________ control is tied to field.

(A). calculated

(B). unbound

(C). bound

(D). static

110. (230). ___________ control need not have a data source

(A). form

(B). bound

(C). unbound


111. (190). ___________ are forms that are included in other forms.

(A). SubForms

(B). Child Forms

(C). Inner form


112. (300). __________ is the form that can be crated with minimal input from the user.

(A). Sub form

(B). Auto form

(C). tabular form

(D). columnar form

113. (120). Currncy fields express the amount in __________.

(A). Dollars

(B). rupees

(C). pesos

(D). yen

114. (520). _________ keyword is used to delare a variable in VB.

(A). MsgBox

(B). Declare

(C). var

(D). Dim

115. (220). ___________ are employed to select only some particular records from a database

object.

(A). Filters

(B). queries

(C). sorts

(D). forms

116. (280). ___________ control uses an expresson as a source of control.

(A). Calculated

(B). bound

(C). unbound


117. (240). ____________ control combines the functionality of both a textbox and a drop down

list.

(A). list box

(B). combo box

(C). button

(D). option button

118. (480). __________ macro is used to set the value of a field based on the value of another

field.

(A). create

(B). value

(C). MsgBox

(D). Set Value

119. (340). ___________ charts cannot exist as a separate object.

(A). sub

(B). embedded

(C). free standing

(D). label

120. (450). ____________ is used to create a Mailing Label.

(A). label wizard

(B). chart wizard

(C). mail wizard


121. (500). ___________ can be used to create toolbars.

(A). VB Modules

(B). Reports

(C). Forms

(D). Macros

122. (430). ____________ option from the Insert menu option is chosen to add an embedded

chart.

(A). create fields

(B). add chart

(C). chart

(D). insert chart

123. (180). ___________ is the name of the database object that displays data and can be used

to edit data.

(A). report

(B). form

(C). query

(D). table

124. (550). OLE stands for ___________________.

(A). Object linking and embedding

(B). On Line execution

(C). On line editing


125. (530). __________ function is used to display a message box.

(A). SysCmd

(B). MsgBox

(C). Message


126. (420). ____________ and ___________ are the two types of AutoReports available.

(A). columnar and tabular

(B). stable and unstable

(C). dynamic and static


127. (440). If an embedded chart has to remain the same record to record, __________ option is

chosen from the drop down list while creating the embedded chart.

(A). create fields

(B). add fields

(C). No fields

(D). delete fields

128. (30). A field with a ____________ uniquely identifies each record.

(A). Number

(B). primary key

(C). index

(D). identifier

129. (10). ____________ data type is generaly used for fields assigned as primary keys in a

table.

(A). Integer

(B). number

(C). primary number

(D). auto number

130. (310). ___________, ___________, and ________ are the buttons belonging to the options

group.

(A). option ,toggle and command buttons

(B). command button, check and and list boxes

(C). list, check and combo boxes

(D). Option button, toggle button and check boxes

131. (490). ____________ field is added to the macro sheet when we select grouping option from

the View menu.

(A). Condition

(B). group

(C). macro names


132. (160). _________ queries can be used to delete a group of records that meet some specific

records.

(A). delete

(B). insert

(C). append

(D). add

133. (110). The Memo field can have text upto ____________ charecters in length.

(A). 60,000

(B). 255

(C). 25,000

(D). 64,000

134. (370). To build complex expressions ____________ is used.

(A). Calculator

(B). code builder

(C). expression builder

(D). expression elements

135. (330). ___________ is a database object which displays data but cannot be used to edit

data.

(A). Form

(B). report

(C). macro

(D). table

136. (620). To display an OLE object in the from of an icon __________ check box is selected

from Insert object dialog box.

(A). Display as icon

(B). Display

(C). Link

(D). create icon

137. (130). _____________ are used to jump to any kind of information from a datasheet or a

form.

(A). Table

(B). form

(C). report

(D). Hyperlink

138. (360). In the macro sheet the macro is selected in the _________ field.

(A). Macro

(B). expression elements

(C). comments

(D). Action

139. (470). _________ is present at the bottom of each page in a report.

(A). report footer

(B). page footer

(C). group footer


140. (90). __________ query wizards are used to generate summary calculations for a table.

(A). Summary

(B). Sum

(C). append

(D). Simple

141. (610). _____________ is selected from the toolbar to add an OLE object.

(A). Unbound object

(B). Bound Object

(C). Command Button

(D). List box

142. (540). Other MSOffice applications can be accessed from MS-Access using a concept called

________.

(A). OLE

(B). DDE

(C). CME


143. (580). ___________ is the file format that works on internet .

(A). EXE

(B). DLL

(C). BMP

(D). HTML

144. (80). If two tables having same values for the fields are joined it is called an _________ join.

(A). inner join

(B). outer join

(C). explicit join


145. (350). ____________ can be used to automate certain actions in response to events.

(A). report

(B). form

(C). chart

(D). macros

146. (380). The three list boxes present at the bottom of the Expression builder are

called____________

(A). action list

(B). macro list

(C). Expression elements list box


147. (260). __________ forms displays fields in a single row.

(A). tabular form

(B). chart form

(C). data sheet form


148. (410). The table or query name on which we are giong to build our report is selected from

the__________ dialog box.create report

(A). create report

(B). link report

(C). embedd report

(D). new report

149. (570). If any change made on the object from the client side is reflected on the server then

the object is said to be _________.

(A). Linked

(B). embedded

(C). connected

(D). edited

150. (200). ___________ are used to represent our data in a graphical format

(A). graphs

(B). chart

(C). labels

(D). report

151. (140). ____________ query is use to create a new table.

(A). Add

(B). append

(C). insert

(D). Make table

152. (50). ___________ view of a form displays only one record at a time.

(A). Form view

(B). Record view

(C). DataSheet view

(D). Table view

153. (460). ________ header is present at the beginning of the report.

(A). start header

(B). group header

(C). page header

(D). report header

154. (590). ____________ is used to convert any MSAccess object into HTML format.

(A). Form wizard

(B). Report Wizard

(C). Query Wizard

(D). Publish to web wizard

155. (250). A form can be bind to a record source using __________ property of the form.

(A). from name

(B). control

(C). record source


156. (150). If a table is joined to itself it is called a__________

(A). inner join

(B). outer join

(C). self join

(D). table join

157. (20). A collection of data stored in different objects is known as a

(A). data group

(B). data collection

(C). database

(D). data storage

158. (10). MS Access is a

(A). DBMS

(B). RDBMS

(C). Front End

(D). language

159. (40). Data type text can be of _______ characters

(A). 255

(B). 64,0000

(C). 235

(D). 63,500

160. (50).

___________________________________________________ ___________________________________________________ ___________________________________________________

161. (30). A blank database can be created using

(A). New dialog box

(B). New blank database dialog box

(C). New database dialog box

(D). Database dialog box

162. (250). The entities comprising the layers on different machines are called ___________.

(A). Normal protocol

(B). Network protocol

(C). Layer n protocol


163. (120). In a token ring a special bit pattern called the __________ which circulates around

the ring.

(A). Cell

(B). Bit

(C). Tocken


164. (70). __________ is a very popular and widely accepted broadcasting system in the world.

(A). Internet

(B). Ethernet

(C). Arpanet


165. (270). ____________ is a computer, which provides destructor a form a storage that are

shared on the LAN.

(A). Server

(B). Supplier

(C). Client


166. (60). Modem stands for ___________ .

(A). Mode/Demode

(B). Modulation/Demodulation

(C). Module/Demodule


167. (90). ___________ is a linear or tree- shaped cable onto which stations are attached.

(A). Hubs

(B). Tocken bus

(C). Router


168. (260). ATM stands for ___________.

(A). Aggregate transfer mode

(B). Asynchronous transfer mode

(C). Area transfer mode


169. (240). The ____________ layer accepts the data from the sesion layer and splits it into

smaller packets.

(A). Horizontal layer

(B). Transport layer

(C). Presentation layer


170. (220). Horizontal Topology is also called as _________ topology.

(A). Network topology

(B). Bus topology

(C). Simple topology


171. (20). _________are used to increase distance over which a network signal can be

propagated.

(A). Router

(B). Carrier

(C). Repeaters


172. (140). _____________ and demultiplexing are two major problems of the network.

(A). Multiplexing

(B). Clubbing

(C). Trafficking


173. (110). ___________ is the Worlds largest computer network.

(A). Ethernet

(B). Internet

(C). Arpanet


174. (200). The ________ protocol is a network protocol to be built for the World Wide Web.

(A). Transfer protcol

(B). Transmission protocol

(C). Hyper text


175. (50). ___________ internally provide the physical LAN media.

(A). Mediator

(B). Hubs

(C). Modem


176. (150). The transmission of raw bits over the communication channel is carried out by the

_________ layer.

(A). Presentation layer

(B). Protocol layer

(C). Physical layer

(D). Transport layer

177. (130). When LANs are connected together it is called __________.

(A). MAN

(B). WAN

(C). GAN


178. (10). _________are used to connect networks with different addresses.

(A). Connector

(B). Bridges

(C). Transmitter


179. (280). __________________ refer to the computers that are attached to the LAN.

(A). Workstations

(B). Server

(C). Client


180. (30). __________ are used to interconnect computer systems having different architectures

and use different communication protocols.

(A). router

(B). Node

(C). Gateways


181. (170). TCP/IP stands for ___________.

(A). Transfer control protocol/Internet protocol

(B). Transfer communication protocol/ Internet protocol

(C). Transmission cintrol protocol/ Internet protocol


182. (80). LAN stands for _________.

(A). Linear area networks

(B). Local area networks

(C). Local array of networks


183. (40). __________ interconnects two or more physically and logically seperated network

segments.

(A). Gateway

(B). Router

(C). Interface


184. (230). ____________ layer takes care of the semantics and syntax of the information

transmitted.

(A). Physical layer

(B). Presentation layer

(C). Horizontal layer


185. (160). The ___________ layer takes care of the operations of the subnet.

(A). Transport layer

(B). Network layer

(C). Physical layer


186. (180). Data is broken into small packages called _________.

(A). Cells

(B). Bits

(C). Packets


187. (100). ISDN stands for ______________.

(A). Integerated systems dynamic networks

(B). Integerated Symbolic Digital natworks

(C). Integerated Services Digital networks


188. (130). The protocol that controls the flow of the traffic on each channel is referred to as

_______.

(A). Switching protocol

(B). Routing protocol

(C). Link protocol


189. (110). .________ connect LANs.

(A). Bridges

(B). Routers

(C). Protocol

(D). Repeaters

190. (100). ATM uses standard-sized packets called _______.

(A). Keys

(B). Signals

(C). Cells

(D). Data Packets

191. (40). ___________ is a redesign of telephone system

(A). ISDN

(B). ATM

(C). Internet

(D). Intranet

192. (20). The computer which can receive data from other computers on the network and print

it is

(A). File server

(B). Printer server

(C). Receiver


193. (30). ATM , Asynchronous transfer mode is a _________ technology.

(A). MAN and WAN

(B). LAN and WAN

(C). LAN and MAN

(D). LAN WAN and MAN

194. (120). Communications in which data travels in both directions are known as _________.

(A). Simplex communication

Simplex communication

(B). Duplex communication

(C). Half -duplex communication

(D). Two way communication

Two way communication

195. (60). Expansion of OSI is

(A). Organization of systems Interconnection

(B). Organization of Software Integration

(C). Open Software Interconnection

(D). Open Systems Interconnection.

196. (510). The user can set a spelling checker to skip the marked part of the text.

(A). True

(B). False

197. (250). ____________ is a box surrounding a page on all sides or a line that sets off a paragraph on one or more sides

(A). Border

(B). Shading

(C). Style Box


198. (140). The easiest way to create a document in Word is

(A). Wizard

(B). Templates

(C). Click from Start, Program, MS-Word from the Task Menu


199. (60). The feature that enables the user to type text-graphic tables anywhere in the document without pressing enter or tab

(A). drag&drop

(B). click_n_type

(C). double_click


200. (340). To highlight certain parts of a page to set it apart from the rest of the page we make use of The following feature

(A). Borders

(B). Shading

(C). Word Art

(D). Bullets

201. (50). _________ shows how a document would look like when published on the web or on an Intranet

(A). Web layout view

(B). Online layout view

(C). browsers


202. (30). ________ is the default view in Word, used for typing, editing and formatting the text

(A). Normal

(B). online layout

(C). pagelayout

(D). online document

203. (280). The key that is used to change the font from the current position in a document is

(A). CTRL+SHIFT+F

(B). CTRL+O

(C). CTRL+SHIFT+S

(D). CTRL+SHIFT+P

204. (110). ______ feature allows the user to copy and paste up to 12 items at the same time in an application

(A). office clipboard

(B). cut

(C). select


205. (170). The __________ helps us to keep track of the margin of the page

(A). TabStops

(B). Marginal Stops

(C). Ruler


206. (410). Pressing the ____________ key inserts a blank row after the last row in the table

(A). Tab

(B). End

(C). Enter


207. (540). The user can modify the pictures from the Clip Art.

(A). True

(B). False

208. (490). ____ is the coding system used to create Web Pages

(A). HTML

(B). XML

(C). SGML

(D). VBScript

209. (330). The box that separates text from the document and allows it to behave like an independent object is known as

(A). text box

(B). Word art

(C). AutoShapes

(D). File

210. (260). The key that is used to perform a task, to select all the text in the document is

(A). Ctrl+A

(B). Del

(C). Ctrl+F

(D). Ctrl+M

211. (150). In Office2000 environment, the tool that makes work easier for us is ___________

(A). Office Assistant

(B). Inbox Assistant

(C). document Assistant


212. (180). The keys that are used to navigate between headers and footers are

(A). Up arrow Keys only

(B). Page Up keys only

(C). Home and End Keys

(D). Up and Down arrow Keys

213. (530). The user can split the screen only into two parts.

(A). True

(B). False

214. (90). The mode that is initialized or toggled to , if the user is in a position to overwrite the text in the Word

(A). Insert mode

(B). Ovr Mode

(C). Remove


215. (130). ___ and ___ are improved layouts in Word 2000

(A). Web layout, PrintLayout

(B). Normal Layout, Web Layout

(C). Web Layout ,Page Layout


216. (390). The Thesaurus is invoked by pressing ___________ keys

(A). shift+F7

(B). Thesaurus Menu

(C). Shift+F8

(D). Tools +Spelling Menu

217. (100). The feature that enables user to type anywhere in a document without pressing or tab

(A). Click-n-type

(B). double-click

(C). Drag & drop


218. (160). A short description of a tool bar button called the _________ is displayed when the mouse pointer is allowed to stay for a second on the button

(A). Screen Tip

(B). ToolTip

(C). Icon Tip

(D). document Tip

219. (360). The dialog box that is used to incorporate picture bullets into our documents or web pages is

(A). Picture Bullet Dialog Box

(B). Arrow Bullet Dialog Box

(C). Circle Bullet Dialog Box

(D). None Dialog Box

220. (450). __________ is a facility that enables recording and replaying of a sequence of keystrokes

(A). Mailmerging

(B). Macro

(C). Data Source


221. (520). New option under the File menu of Word creates a new blank document that is based on the Normal template

(A). True

(B). False

222. (420). The ________ option enables us to convert text into a table format.

(A). Convert Text to Table

(B). Convert Data to Table

(C). Table AutoFormat option


223. (470). In Word2000, The macro dialog box is activated with the help of ___________ key combination

(A). Shift + F8

(B). Shift+f7

(C). Alt+f8

(D). Alft+f5

224. (290). The key that is used to change the style of the document that is from that Normal to Heading1 or Heading1 to other document styles

(A). CTRL+SHIFT+F

(B). CTRL+O

(C). CTRL+SHIFT+S

(D). CTRL+SHIFT+P

225. (10). __________ is a Word-processing package that is a member of the office 2000 family

(A). Word 2000

(B). office2000

(C). Office 97

(D). BackOffice

226. (430). A table consists of _______ that contain text or graphics

(A). rows

(B). rows & columns

(C). records


227. (480). _________ is a software for sending and receiving e-mail messages

(A). E-Mail Client

(B). Out-look express

(C). Microsoft OutLook

(D). hotmail

228. (80). The view that enables us to view how objects will be positioned on the page when it is printed

(A). Print layout view

(B). page layout

(C). outline layout


229. (120). _________ and ______ key combination will extend the selection by one character on the left and right

(A). shift +end and shift + home

(B). shift +left and shift + right

(C). ctrl + end and ctrl + home



(A). True

(B). False

231. (580). The "Format Columns" option allows to create columnar text up 12 columns only.

(A). True

(B). False

232. (350). To Clear all the tabs in a document , the option that is clicked from the tabs dialog box is

(A). Clear

(B). Remove all

(C). remove

(D). Clear All

233. (70). The doucment that makes the user to organize and maintain a long document, such as multipart report or a book consisting of chapters

(A). Master document

(B). child document

(C). Hyperlink document


234. (300). key that is used to indent a paragraph spacing (double) in the document is :

(A). CTL+M

(B). Ctrl+2

(C). Ctrl+end

(D). Ctrl+Home

235. (400). a new table is created, the insertion point flashes in the ____________ cell.

(A). First

(B). second

(C). First row

(D). last cell of the table

236. (270). The key that is used to indent a paragraph is

(A). Ctrl+A

(B). del

(C). Ctrl+F

(D). Ctrl+M

237. (500). The network that makes information easily accessible across various networks is ____________.

(A). Internet

(B). Intranet

(C). Arpnet

(D). LAN

238. (20). ____ are blueprints or patterns for documents of a certain type

(A). Template

(B). Model

(C). dialogs/alerts


239. (570). The special symbols that are inserted using "Insert Symbol" option of the Word cannot be printed by the printer as they are not the standard keyboard symbols.

(A). True

(B). False

240. (370). The object that composes of set of tools which helps to create and work on different shapes like rectangles, circles, flowcharts etc.

(A). Charts

(B). WordArt

(C). AutoShapes

(D). Files

241. (210). Word Art is text with ______________

(A). Special effects

(B). Control tool box

(C). Design Wizards

(D). Pictures.

242. (320). The key that is used for paragraph spacing (1.5)

(A). CTRL+2

(B). CTRL+5

(C). CTRL+1


243. (240). The dialog box that is used to determine the documents margins is

(A). Pagesetup from the File Menu

(B). PrinterSetup from the File Menu

(C). PrintPreview from the File Menu


244. (230). By default, a document consists of _________ sections

(A). 1

(B). 3

(C). 0

(D). 11

245. (380). _________ is an online dictionary maintained by Word to obtain synonyms for words

(A). Thesaurus

(B). Hyphenation

(C). Mail Merge


246. (220). Autoshapes in Word can be created by accessing the _________ toolbar

(A). Drawing Toolbar

(B). ControlBox

(C). Database

(D). Forms

247. (440). The ____ option in Word allows the user to automatically correct misspelt words as and when they are typed

(A). AutoCorrect

(B). AutoFormat

(C). StyleGallery


248. (40). When Word is opened a new document called __________ is displayed, where the user starts typing the content right away

(A). doc1

(B). document1

(C). new document

(D). default document

249. (200). The __________ is used for quickly setting paragraph indentations using the mouse

(A). Increase Indent

(B). Decrease Indent

(C). Both a and b


250. (460). In Word, macros are written in ___________ language

(A). Basic

(B). Visual Basic

(C). VJ++

(D). Visual FoxPro

Sukh Sagor Institute Practice Test Answer Details Test ID: 36


Answer: (D). Relational Database System


Answer: (B). PC


Answer: (B). Centralized

4. (260). _______ computing strikes a balance between the two extremes of the dumb client and

dumb server forms of computing

Answer: (A). Client/Server

5. (60). The ______ do not have processing power of their own and has only a screen, keyboard,

and the necessary hardware to communicate with the host. For this reason, the terminals are referred to as the

Answer: (A). "dumb terminals".


Answer: (A). Dumb servers


Answer: (D). All of the above


workload is shared.

Answer: (C). Client, server


separate

components.

Answer: (C). Data processing


Answer: (C). Back-end






Answer: (B). Multithreading


Answer: (C). Thread




Answer: (D). any one of the above


Answer: (A). PC.

17. (230). In a C/S architecture, if the client is of minimal processing power , the configuration is

called

Answer: (B). Dumb client


requested.

Answer: (A). Database server


_______

Answer: (D). Disk mirroring


Answer: (C). PC


Answer: (D). Multitasking


Answer: (B). Front-end


Answer: (D). all of the above

24. (380). _________ is a platform

Answer: (D). All the above


Answer: (B). Distributed computing


Answer: (A). Search and send data


______system.

Answer: (A). PC


Answer: (D). More than one


Answer: (D). None of the above

30. (50). In a centralized system, All the data processing is done in the______computer

Answer: (B). main "host"


Answer: (A). Centralized


sometimes called as

Answer: (B). Host processing


Answer: (D). LAN







Answer: (B). Server




Answer: (A). Platform


Answer: (D). Front-end



41. (80). In a LAN the data and the application reside on a _____

Answer: (D). File server


configuration.

Answer: (C). Client/Server

43. (300). The network traffic is reduced in case of _________.



Answer: (D). a or b


______.

Answer: (B). Locks


Answer: (A). Four


Answer: (B). OR


Answer: (D). Tip Wizard


Answer: (A). Concatenate


Answer: (A). Pivot table wizard


Answer: (A). True


Answer: (B). Scenario manager.


Answer: (D). Class files


Answer: (C). FunctionWizard


Answer: (A). 3-dimensions.

56. (90). Pick out the window that is a not a form of Excel

Answer: (C). Modal Window


Answer: (A). Autoformat


Answer: (C). Solver


Answer: (B). Category

60. (430). In Excel, the subtotal command also generates grand total after the last

group subtotal

Answer: (A). True


Answer: (C). stock chart


Answer: (D). Boolean


Answer: (A). Excel97


Answer: (A). All option


Answer: (B). Bar chart


Answer: (D). Pivot Table


Answer: (A). =Today()


Answer: (A). Column Chart




Answer: (B). It shows trends over time.


Answer: (A). Goal seek.


Answer: (A). Text Import Wizard


Answer: (C). Legend


Answer: (A). Dollar Sign


Answer: (A). serial values


Answer: (B). 2




Answer: (C). Source table name.


Answer: (D). Data table.


Answer: (D). Data Marker




Answer: (C). Solver


Answer: (A). countif


Answer: (B). arguments


Answer: (B). Print-area


Answer: (B). ConvertText to Columns Wizard


Answer: (A). Filtering




Answer: (D). Worksheets


Answer: (B). False


Answer: (B). chart wizard


Answer: (A). Worksheet


Answer: (C). PIE chart

94. (190). The function that is used to calculate the payment for specific loan terms

Answer: (B). PMT


Answer: (C). sumif




Answer: (B). Three.


Answer: (B). It is useful when several components are changing and the user is interested in the sum of the components.

99. (620). Which two of the following functions are used in subtotal option ?

Answer: (A). Count


Answer: (B). Formatting


nature.

Answer: (B). Static HTML


Answer: (C). OLE server


Answer: (D). filter by input


Answer: (D). *


Answer: (A). Database


Answer: (A). Pivot


tables.

Answer: (B). Connect


table.

Answer: (B). append


Answer: (C). bound


Answer: (C). unbound


Answer: (A). SubForms


Answer: (B). Auto form


Answer: (A). Dollars


Answer: (D). Dim


object.

Answer: (A). Filters


Answer: (A). Calculated


list.

Answer: (B). combo box


field.

Answer: (D). Set Value


Answer: (B). embedded


Answer: (A). label wizard

121. (500). ___________ can be used to create toolbars.

Answer: (D). Macros


chart.

Answer: (C). chart


to edit data.

Answer: (B). form

124. (550). OLE stands for ___________________.

Answer: (A). Object linking and embedding


Answer: (B). MsgBox


Answer: (A). columnar and tabular



Answer: (C). No fields


Answer: (B). primary key


table.

Answer: (D). auto number


group.

Answer: (D). Option button, toggle button and check boxes


the View menu.

Answer: (C). macro names


records.

Answer: (A). delete


Answer: (D). 64,000


Answer: (C). expression builder


data.

Answer: (B). report



Answer: (A). Display as icon

137. (130). _____________ are used to jump to any kind of information from a datasheet or a

form.

Answer: (D). Hyperlink


Answer: (D). Action


Answer: (B). page footer


Answer: (D). Simple


Answer: (B). Bound Object


________.

Answer: (A). OLE


Answer: (D). HTML


Answer: (A). inner join

145. (350). ____________ can be used to automate certain actions in response to events.

Answer: (D). macros

146. (380). The three list boxes present at the bottom of the Expression builder are

called____________

Answer: (C). Expression elements list box


Answer: (A). tabular form



Answer: (D). new report



Answer: (A). Linked


Answer: (B). chart

151. (140). ____________ query is use to create a new table.

Answer: (D). Make table


Answer: (A). Form view

153. (460). ________ header is present at the beginning of the report.

Answer: (D). report header


Answer: (D). Publish to web wizard


Answer: (C). record source


Answer: (C). self join




160. (50).



Answer: (C). Layer n protocol


the ring.

Answer: (C). Tocken


Answer: (B). Ethernet


shared on the LAN.

Answer: (A). Server

166. (60). Modem stands for ___________ .

Answer: (B). Modulation/Demodulation


Answer: (B). Tocken bus

168. (260). ATM stands for ___________.

Answer: (B). Asynchronous transfer mode


smaller packets.

Answer: (B). Transport layer


Answer: (B). Bus topology


propagated.

Answer: (C). Repeaters


Answer: (A). Multiplexing


Answer: (B). Internet


Answer: (C). Hyper text


Answer: (B). Hubs


_________ layer.

Answer: (C). Physical layer


Answer: (B). WAN


Answer: (B). Bridges


Answer: (A). Workstations



Answer: (C). Gateways

181. (170). TCP/IP stands for ___________.

Answer: (A). Transfer control protocol/Internet protocol

182. (80). LAN stands for _________.

Answer: (B). Local area networks


segments.

Answer: (B). Router


transmitted.

Answer: (B). Presentation layer


Answer: (B). Network layer


Answer: (C). Packets

187. (100). ISDN stands for ______________.

Answer: (C). Integerated Services Digital networks


_______.

Answer: (C). Link protocol

189. (110). .________ connect LANs.

Answer: (B). Routers

190. (100). ATM uses standard-sized packets called _______.

Answer: (C). Cells


Answer: (A). ISDN


it is

Answer: (B). Printer server


Answer: (B). LAN and WAN


Answer: (B). Duplex communication

195. (60). Expansion of OSI is

Answer: (D). Open Systems Interconnection.


Answer: (A). True


Answer: (A). Border


Answer: (A). Wizard


Answer: (B). click_n_type


Answer: (B). Shading

201. (50). _________ shows how a document would look like when published on the web or on an Intranet

Answer: (A). Web layout view


Answer: (A). Normal


Answer: (A). CTRL+SHIFT+F


Answer: (A). office clipboard


Answer: (C). Ruler


Answer: (A). Tab


Answer: (A). True


Answer: (A). HTML


Answer: (A). text box


Answer: (A). Ctrl+A


Answer: (A). Office Assistant


Answer: (D). Up and Down arrow Keys


Answer: (A). True


Answer: (A). Insert mode


Answer: (A). Web layout, PrintLayout


Answer: (A). shift+F7


Answer: (A). Click-n-type


Answer: (A). Screen Tip


Answer: (A). Picture Bullet Dialog Box


Answer: (B). Macro


Answer: (A). True


Answer: (A). Convert Text to Table


Answer: (A). Shift + F8


Answer: (C). CTRL+SHIFT+S


Answer: (A). Word 2000


Answer: (B). rows & columns

227. (480). _________ is a software for sending and receiving e-mail messages

Answer: (A). E-Mail Client


Answer: (A). Print layout view


Answer: (B). shift +left and shift + right


Answer: (A). True


Answer: (A). True


Answer: (D). Clear All


Answer: (A). Master document

234. (300). key that is used to indent a paragraph spacing (double) in the document is :

Answer: (B). Ctrl+2


Answer: (A). First


Answer: (D). Ctrl+M


Answer: (A). Internet


Answer: (A). Template


Answer: (B). False


Answer: (C). AutoShapes


Answer: (A). Special effects


Answer: (B). CTRL+5


Answer: (A). Pagesetup from the File Menu


Answer: (A). 1


Answer: (A). Thesaurus


Answer: (A). Drawing Toolbar


Answer: (A). AutoCorrect


Answer: (B). document1


Answer: (C). Both a and b


Answer: (B). Visual Basic

Sukh Sagor Institute Test ID: 37

Name: ___________________________

Date: _December 22, 2005_


(A). Dumb servers

(B). Dumb clients

(C). Both




(B). Multithreading

(C). Multiplexing

(D). Multitasking


(A). File server

(B). Remote server

(C). PC

(D). Both PC and file server


(A). Four

(B). one

(C). two

(D). many


(A). single

(B). two parallel

(C). maximum of 12

(D). More than one


_______

(A). Repairing

(B). Redo logging

(C). Disk reflection

(D). Disk mirroring


(A). Centralized Systems

(B). PC

(C). LAN

(D). WAN


(A). WAN

(B). Distributed computing system

(C). Windows NT

(D). LAN


workload is shared.

(A). File server, data server

(B). Mainframe, remote server

(C). Client, server

(D). Pc , mainframe computer


(A). Type of the front end used

(B). Type of the back end used

(C). Amount of workload



(A). Search and send data

(B). Data processing

(C). Memory management



(A). PC.

(B). Mainframes

(C). Client

(D). Microcomputers


(A). Task

(B). Process

(C). Thread

(D). Client-process

14. (260). _______ computing strikes a balance between the two extremes of the dumb client

and dumb server forms of computing

(A). Client/Server


(C). PC



(A). an advanced PC

(B). a minicomputer

(C). a mainframe

(D). any one of the above


(A). file server

(B). print server

(C). both together

(D). a or b

17. (60). The ______ do not have processing power of their own and has only a screen,

keyboard, and the necessary hardware to communicate with the host. For this reason, the terminals are referred to as the

(A). "dumb terminals".

(B). "dumb servers"

(C). dummy terminals

(D). dummy servers.



(B). Multithreading

(C). Multiplexing

(D). Multitasking







separate

components.

(A). Memory management

(B). O/S management

(C). Data processing







22. (460). The speed of the DBMS does not depend on the speed of the workstation in case of

Client/Server architecture.

(A). True

(B). False

(C). May not be

(D). Partially correct




(B). Multithreading

(C). Multiplexing



(A). Main

(B). Front-end

(C). Back-end

(D). Host


(A). LAN


(C). Centralized

(D). Mainframes


(A). Platform

(B). Configuration

(C). Package

(D). System


(A). Host

(B). server

(C). Back-end

(D). Front-end


______system.

(A). PC

(B). LAN

(C). Distributed computing

(D). Centralized



(A). Client/Server


(C). PC


30. (280). In a Client/Server architecture, ______ provides the user with easy-to-use displays,

icons, and messages.

(A). Client

(B). Server

(C). Network





(C). Network Database System & Relational Database System




(A). Client

(B). Server

(C). Network



configuration.

(A). Dumb server

(B). Dumb client

(C). Client/Server



______.

(A). Fixes

(B). Locks

(C). Constraints

(D). Traps

35. (10). The need for an architecture that would reduce the workload of a single system gave

way to the evolution of _____Technology.

(A). OOPS

(B). Client/Server

(C). Distributed component

(D). NCA


(A). LAN

(B). Centralized

(C). None

(D). Both



(B). Multithreading

(C). Multiplexing




(B). Multithreading

(C). Multiplexing



(A). Host

(B). server

(C). Back-end

(D). Front-end

40. (380). _________ is a platform

(A). PCs,

(B). UNIX workstations,

(C). minicomputers,

(D). All the above


sometimes called as

(A). Server processing

(B). Host processing

(C). Dumb processing

(D). Data processing


(A). Visual Basic

(B). Power Builder

(C). SQL*Plus



(A). data integrity

(B). data security

(C). locks

(D). all of the above


(A). Centralized

(B). PC

(C). LAN

(D). WAN


(A). LAN


(C). Centralized

(D). Mainframes


requested.

(A). Database server

(B). Client

(C). Front-end

(D). PC


(A). =Today()

(B). =date()

(C). =currentdate



(A). Page-setup

(B). Print-area

(C). Print

(D). Print-preview


(A). True

(B). False


(A). True.

(B). False

51. (380). The chart that display two or more data series on a surface is _____________.

(A). Column Chart

(B). Bar chart

(C). PIE chart

(D). Surface Charts


(A). line chart

(B). barchart

(C). stock chart

(D). pie chart


(A). AND

(B). OR


(A). TextFiles

(B). Lotus1-2-3

(C). QuattroPro or Xbase files

(D). Class files

55. (400). _________ are not allowed in a macro name

(A). spaces

(B). Wild card characters

(C). symbols



(A). Autoformat

(B). Autofill

(C). Print-area



(A). 1

(B). 2

(C). 4

(D). 5


(A). Data Table

(B). Filtered Table

(C). Index Table

(D). Pivot Table


(A). Bordering

(B). Formatting

(C). Shading


60. (470). The ______ generates a summerised report in tabular form in an interactive manner.

(A). Data table

(B). Pivot table


(A). Column Chart

(B). Bar chart

(C). PIE chart

(D). Surface Charts


(A). Pivot table.


(C). Solver

(D). Data table.


(A). Pivot table.


(C). Solver

(D). Data table.


(A). AutoSum

(B). Autofill

(C). FunctionWizard



(A). It displays the data series one on top of the other.

(B). It is useful when several components are changing and the user is interested in the sum of the components.

(C). It can be represented in 3-dimensions.


(A). Goal seek.


(C). Pivot table.

(D). Data table.

67. (320). In a chart Y-Axis is known as

(A). Series or Rank

(B). Category

(C). Legend

(D). Data Marker


(A). Databases

(B). records

(C). tables

(D). Worksheets



(B). chart wizard


(D). Tip Wizard


(A). Two

(B). Three.

(C). N


(A). countif

(B). vlookup

(C). pmt

(D). count


(A). Column Chart

(B). Bar chart

(C). PIE chart

(D). Surface Charts


(A). Column field

(B). Row field.

(C). Source table name.

(D). Pivot table item.


(A). Data table

(B). Pivot table


(A). Concatenate

(B). pmt

(C). merge


76. (210). The _________________ option present in the file menu options is used to specify major facets of the page to be printed

(A). Page-setup

(B). Print-area

(C). Print



(A). Series or Rank

(B). Category

(C). Legend

(D). Data Marker


(A). Series or Rank

(B). Category

(C). Legend

(D). Data Marker


(A). serial values

(B). domain values

(C). range values

(D). reference values


(A). Goal seek

(B). Pivot table

(C). Solver

(D). Data table.


(A). Filtering

(B). Searching

(C). Sorting



(A). Page-setup

(B). Print-area

(C). Print



(A). Pivot table.


(C). Solver

(D). Data table.


(A). Worksheet

(B). Workbook

(C). Tables

(D). Database


(A). Dollar Sign

(B). "=" Sign

(C). # Sign





(C). TipWizard



(A). Text

(B). Logical

(C). Numeric

(D). Boolean


(A). All option

(B). blanks

(C). all blanks

(D). none




(C). TipWizard



(A). Column Chart

(B). Bar chart

(C). PIE chart

(D). Surface Charts


(A). It is also called as high-low-close chart.

(B). It shows trends over time.

(C). It is often used to display share market prices over a period of time.

(D). It is also used for indicating fluctuations in temperature changes.


(A). Variables

(B). arguments

(C). parameters



(A). Pivot table.


(C). Solver

(D). Data table.


(A). 3-dimensions.

(B). 4-dimensions.



(A). 3-dimensions.

(B). 4-dimensions.


(D). 2dimensions.



(B). chart wizard


(D). Tip Wizard



(B). chart wizard


(D). Tip Wizard


(A). Excel97

(B). InternetExplorer

(C). NetScape

(D). Word2000


(A). average

(B). sum

(C). sumif

(D). countif


(A). Series or Rank

(B). Category

(C). Legend

(D). Data Marker


(A). columnar and tabular

(B). stable and unstable

(C). dynamic and static



(A). label wizard

(B). chart wizard

(C). mail wizard



(A). Macro

(B). expression elements

(C). comments

(D). Action


group.

(A). option ,toggle and command buttons

(B). command button, check and and list boxes

(C). list, check and combo boxes

(D). Option button, toggle button and check boxes


(A). Unbound object

(B). Bound Object

(C). Command Button

(D). List box


the View menu.

(A). Condition

(B). group

(C). macro names



(A). EXE

(B). DLL

(C). BMP

(D). HTML

108. (70). ___________ query is used to create or change database objects in a current

database.

(A). Append

(B). Add

(C). insert

(D). Data definit


(A). &

(B). #

(C). ?

(D). *


(A). calculated

(B). unbound

(C). bound

(D). static


table.

(A). add

(B). append

(C). insert

(D). delete


(A). Number

(B). primary key

(C). index

(D). identifier


(A). SubForms

(B). Child Forms

(C). Inner form



(A). inner join

(B). outer join

(C). explicit join



(A). Summary

(B). Sum

(C). append

(D). Simple


nature.

(A). Static file

(B). Static HTML

(C). Dynamic File



chart.

(A). create fields

(B). add chart

(C). chart

(D). insert chart


(A). Form view

(B). Record view

(C). DataSheet view

(D). Table view


(A). inner join

(B). outer join

(C). self join

(D). table join


(A). 60,000

(B). 255

(C). 25,000

(D). 64,000


(A). MsgBox

(B). Declare

(C). var

(D). Dim


(A). Sub form

(B). Auto form

(C). tabular form

(D). columnar form



(A). Linked

(B). embedded

(C). connected

(D). edited


(A). report footer

(B). page footer

(C). group footer



(A). filter by form

(B). filter by report

(C). filter by record

(D). filter by input



(A). create report

(B). link report

(C). embedd report

(D). new report


list.

(A). list box

(B). combo box

(C). button

(D). option button


(A). form

(B). bound

(C). unbound



________.

(A). OLE

(B). DDE

(C). CME



(A). Database

(B). form

(C). collection



field.

(A). create

(B). value

(C). MsgBox

(D). Set Value


(A). Dollars

(B). rupees

(C). pesos

(D). yen



(A). Display as icon

(B). Display

(C). Link

(D). create icon


(A). OLE object

(B). OLE Client

(C). OLE server

(D). OLE Communicator


(A). Form wizard

(B). Report Wizard

(C). Query Wizard

(D). Publish to web wizard


(A). Pivot

(B). create

(C). from



(A). Calculated

(B). bound

(C). unbound


138. (400). _____________ report can be created with minimal user input.

(A). tabular

(B). columnar

(C). auto report

(D). embedded


(A). tabular form

(B). chart form

(C). data sheet form



object.

(A). Filters

(B). queries

(C). sorts

(D). forms


data.

(A). Form

(B). report

(C). macro

(D). table


(A). from name

(B). control

(C). record source



(A). sub

(B). embedded

(C). free standing

(D). label

144. (650). ___________ VB Module is accessible to all the Forms and Reports in a database.

(A). Private

(B). Home

(C). Global



to edit data.

(A). report

(B). form

(C). query

(D). table


tables.

(A). Set Relation

(B). Connect

(C). Relationships


147. (390). ____________ option is selected from the view menu to create macros with

conditions.

(A). Conditions

(B). action

(C). insert



(A). Calculator

(B). code builder

(C). expression builder

(D). expression elements


table.

(A). Integer

(B). number

(C). primary number

(D). auto number


(A). graphs

(B). chart

(C). labels

(D). report

151. (270). ___________ forms are usually used for tables with one to many relationship.

(A). Subforms

(B). tabular form

(C). columnar form


152. (640). _____________ page in an web application is used to navigate to the rest of the

pages in the application.

(A). Startup

(B). Home

(C). End




(A). create fields

(B). add fields

(C). No fields

(D). delete fields


(A). SysCmd

(B). MsgBox

(C). Message


155. (550). OLE stands for ___________________.

(A). Object linking and embedding

(B). On Line execution

(C). On line editing



records.

(A). delete

(B). insert

(C). append

(D). add


(A). data group

(B). data collection

(C). database

(D). data storage

158. (50).

___________________________________________________

___________________________________________________ ___________________________________________________


(A). DBMS

(B). RDBMS

(C). Front End

(D). language


(A). New dialog box

(B). New blank database dialog box

(C). New database dialog box

(D). Database dialog box


(A). 255

(B). 64,0000

(C). 235

(D). 63,500


(A). Connector

(B). Bridges

(C). Transmitter



(A). Transport layer

(B). Network layer

(C). Physical layer


164. (260). ATM stands for ___________.

(A). Aggregate transfer mode

(B). Asynchronous transfer mode

(C). Area transfer mode



(A). Multiplexing

(B). Clubbing

(C). Trafficking



(A). Cells

(B). Bits

(C). Packets


167. (170). TCP/IP stands for ___________.

(A). Transfer control protocol/Internet protocol

(B). Transfer communication protocol/ Internet protocol

(C). Transmission cintrol protocol/ Internet protocol



(A). Network topology

(B). Bus topology

(C). Simple topology



(A). MAN

(B). WAN

(C). GAN



(A). Transfer protcol

(B). Transmission protocol

(C). Hyper text




(A). router

(B). Node

(C). Gateways



(A). Hubs

(B). Tocken bus

(C). Router



(A). Normal protocol

(B). Network protocol

(C). Layer n protocol



smaller packets.

(A). Horizontal layer

(B). Transport layer

(C). Presentation layer



(A). Workstations

(B). Server

(C). Client


176. (100). ISDN stands for ______________.

(A). Integerated systems dynamic networks

(B). Integerated Symbolic Digital natworks

(C). Integerated Services Digital networks


177. (60). Modem stands for ___________ .

(A). Mode/Demode

(B). Modulation/Demodulation

(C). Module/Demodule



(A). Mediator

(B). Hubs

(C). Modem



shared on the LAN.

(A). Server

(B). Supplier

(C). Client



_________ layer.

(A). Presentation layer

(B). Protocol layer

(C). Physical layer

(D). Transport layer

181. (210). The Hierarchical topology is also called as __________.

(A). Horizontal network

(B). Vertical network

(C). Parallel network

(D). None of the above.


(A). Ethernet

(B). Internet

(C). Arpanet



(A). Internet

(B). Ethernet

(C). Arpanet



transmitted.

(A). Physical layer

(B). Presentation layer

(C). Horizontal layer



the ring.

(A). Cell

(B). Bit

(C). Tocken



segments.

(A). Gateway

(B). Router

(C). Interface



propagated.

(A). Router

(B). Carrier

(C). Repeaters



(A). MAN and WAN

(B). LAN and WAN

(C). LAN and MAN

(D). LAN WAN and MAN

189. (10). Two types of coaxial cables used in an Ethernet are

(A). Thick and thin

(B). Large and Small

(C). Long and Short



_______.

(A). Switching protocol

(B). Routing protocol

(C). Link protocol



it is

(A). File server

(B). Printer server

(C). Receiver


192. (50). Expansion of ISDN is

(A). Internal Services Digital Network

(B). Internal Services Design Network

(C). Integrated Services Digital Network

(D). Integrated Services Digital Network


(A). ISDN

(B). ATM

(C). Internet

(D). Intranet


(A). Simplex communication

Simplex communication

(B). Duplex communication

(C). Half -duplex communication

(D). Two way communication

Two way communication

195. (110). .________ connect LANs.

(A). Bridges

(B). Routers

(C). Protocol

(D). Repeaters


(A). True

(B). False


(A). Normal

(B). online layout

(C). pagelayout

(D). online document


(A). Basic

(B). Visual Basic

(C). VJ++

(D). Visual FoxPro


(A). Charts

(B). WordArt

(C). AutoShapes

(D). Files


(A). True

(B). False


(A). Tab

(B). End

(C). Enter



(A). AutoCorrect

(B). AutoFormat

(C). StyleGallery



(A). shift +end and shift + home

(B). shift +left and shift + right

(C). ctrl + end and ctrl + home



(A). Word 2000

(B). office2000

(C). Office 97

(D). BackOffice


(A). TabStops

(B). Marginal Stops

(C). Ruler



(A). Mailmerging

(B). Macro

(C). Data Source



(A). doc1

(B). document1

(C). new document

(D). default document


(A). Internet

(B). Intranet

(C). Arpnet

(D). LAN

209. (550). Drop cap tool does not work for the contents in the Table format

(A). True

(B). False

210. (310). The key that is used to paste the selected text

(A). Ctrl+v or Ins

(B). Ctrl+C or Ins

(C). Ctrl+x or Ins

(D). Ctrl+v or del


(A). HTML

(B). XML

(C). SGML

(D). VBScript


(A). Border

(B). Shading

(C). Style Box



(A). Picture Bullet Dialog Box

(B). Arrow Bullet Dialog Box

(C). Circle Bullet Dialog Box

(D). None Dialog Box


(A). Print layout view

(B). page layout

(C). outline layout



(A). Up arrow Keys only

(B). Page Up keys only

(C). Home and End Keys

(D). Up and Down arrow Keys


(A). Increase Indent

(B). Decrease Indent

(C). Both a and b



(A). Drawing Toolbar

(B). ControlBox

(C). Database

(D). Forms


(A). Shift + F8

(B). Shift+f7

(C). Alt+f8

(D). Alft+f5


(A). Wizard

(B). Templates

(C). Click from Start, Program, MS-Word from the Task Menu



(A). CTRL+SHIFT+F

(B). CTRL+O

(C). CTRL+SHIFT+S

(D). CTRL+SHIFT+P


(A). Master document

(B). child document

(C). Hyperlink document



(A). True

(B). False


(A). Clear

(B). Remove all

(C). remove

(D). Clear All


(A). Web layout, PrintLayout

(B). Normal Layout, Web Layout

(C). Web Layout ,Page Layout



(A). Special effects

(B). Control tool box

(C). Design Wizards

(D). Pictures.


(A). rows

(B). rows & columns

(C). records


227. (190). Pick out the element from the following that does not form the type of tabs for the Word2000

(A). Left

(B). Center

(C). Decimal

(D). Rotation


(A). Click-n-type

(B). double-click

(C). Drag & drop



(A). Convert Text to Table

(B). Convert Data to Table

(C). Table AutoFormat option



(A). CTRL+SHIFT+F

(B). CTRL+O

(C). CTRL+SHIFT+S

(D). CTRL+SHIFT+P


(A). True

(B). False


(A). True

(B). False


(A). Insert mode

(B). Ovr Mode

(C). Remove



(A). Thesaurus

(B). Hyphenation

(C). Mail Merge



(A). office clipboard

(B). cut

(C). select



(A). 1

(B). 3

(C). 0

(D). 11


(A). Template

(B). Model

(C). dialogs/alerts



(A). Ctrl+A

(B). Del

(C). Ctrl+F

(D). Ctrl+M


(A). Screen Tip

(B). ToolTip

(C). Icon Tip

(D). document Tip


(A). Pagesetup from the File Menu

(B). PrinterSetup from the File Menu

(C). PrintPreview from the File Menu



(A). Office Assistant

(B). Inbox Assistant

(C). document Assistant



(A). Borders

(B). Shading

(C). Word Art

(D). Bullets


(A). Ctrl+A

(B). del

(C). Ctrl+F

(D). Ctrl+M


(A). First

(B). second

(C). First row

(D). last cell of the table


(A). True

(B). False


(A). True

(B). False


(A). drag&drop

(B). click_n_type

(C). double_click



(A). CTRL+2

(B). CTRL+5

(C). CTRL+1



(A). text box

(B). Word art

(C). AutoShapes

(D). File


(A). shift+F7

(B). Thesaurus Menu

(C). Shift+F8

(D). Tools +Spelling Menu

Sukh Sagor Institute Practice Test Answer Details Test ID: 37


Answer: (A). Dumb servers




Answer: (C). PC


Answer: (A). Four


Answer: (D). More than one


_______

Answer: (D). Disk mirroring


Answer: (B). PC


Answer: (D). LAN


workload is shared.

Answer: (C). Client, server




Answer: (A). Search and send data


Answer: (A). PC.


Answer: (C). Thread

14. (260). _______ computing strikes a balance between the two extremes of the dumb client

and dumb server forms of computing



Answer: (D). any one of the above


Answer: (D). a or b

17. (60). The ______ do not have processing power of their own and has only a screen,

keyboard, and the necessary hardware to communicate with the host. For this reason, the terminals are referred to as the

Answer: (A). "dumb terminals".






separate

components.

Answer: (C). Data processing



22. (460). The speed of the DBMS does not depend on the speed of the workstation in case of

Client/Server architecture.

Answer: (A). True





Answer: (B). Front-end




Answer: (A). Platform


Answer: (C). Back-end


______system.

Answer: (A). PC




30. (280). In a Client/Server architecture, ______ provides the user with easy-to-use displays,

icons, and messages.

Answer: (A). Client





Answer: (B). Server


configuration.



______.

Answer: (B). Locks

35. (10). The need for an architecture that would reduce the workload of a single system gave

way to the evolution of _____Technology.

Answer: (B). Client/Server


Answer: (B). Centralized




Answer: (D). None of the above


Answer: (D). Front-end

40. (380). _________ is a platform

Answer: (D). All the above


sometimes called as

Answer: (B). Host processing




Answer: (D). all of the above


Answer: (A). Centralized




requested.

Answer: (A). Database server


Answer: (A). =Today()


Answer: (B). Print-area


Answer: (A). True


Answer: (B). False

51. (380). The chart that display two or more data series on a surface is _____________.

Answer: (D). Surface Charts


Answer: (C). stock chart


Answer: (B). OR


Answer: (D). Class files

55. (400). _________ are not allowed in a macro name

Answer: (A). spaces




Answer: (B). 2


Answer: (D). Pivot Table


Answer: (B). Formatting


Answer: (B). Pivot table


Answer: (A). Column Chart




Answer: (C). Solver


Answer: (C). FunctionWizard


Answer: (B). It is useful when several components are changing and the user is interested in the sum of the components.



67. (320). In a chart Y-Axis is known as

Answer: (A). Series or Rank


Answer: (D). Worksheets


Answer: (B). chart wizard


Answer: (B). Three.


Answer: (A). countif


Answer: (C). PIE chart


Answer: (C). Source table name.


Answer: (B). Pivot table


Answer: (A). Concatenate


Answer: (A). Page-setup


Answer: (D). Data Marker


Answer: (C). Legend


Answer: (A). serial values


Answer: (D). Data table.


Answer: (A). Filtering


Answer: (A). Page-setup


Answer: (C). Solver


Answer: (A). Worksheet


Answer: (A). Dollar Sign


Answer: (B). ConvertText to Columns Wizard


Answer: (D). Boolean


Answer: (A). All option


Answer: (A). Text Import Wizard


Answer: (B). Bar chart


Answer: (B). It shows trends over time.


Answer: (B). arguments








Answer: (D). Tip Wizard


Answer: (A). Pivot table wizard


Answer: (A). Excel97


Answer: (C). sumif


Answer: (B). Category


Answer: (A). columnar and tabular


Answer: (A). label wizard


Answer: (D). Action


group.

Answer: (D). Option button, toggle button and check boxes


Answer: (B). Bound Object


the View menu.

Answer: (C). macro names


Answer: (D). HTML

108. (70). ___________ query is used to create or change database objects in a current

database.

Answer: (D). Data definit


Answer: (D). *


Answer: (C). bound


table.

Answer: (B). append


Answer: (B). primary key


Answer: (A). SubForms


Answer: (A). inner join


Answer: (D). Simple


nature.

Answer: (B). Static HTML


chart.

Answer: (C). chart


Answer: (A). Form view


Answer: (C). self join


Answer: (D). 64,000


Answer: (D). Dim


Answer: (B). Auto form



Answer: (A). Linked


Answer: (B). page footer


Answer: (D). filter by input



Answer: (D). new report


list.

Answer: (B). combo box


Answer: (C). unbound


________.

Answer: (A). OLE


Answer: (A). Database


field.

Answer: (D). Set Value


Answer: (A). Dollars



Answer: (A). Display as icon


Answer: (C). OLE server


Answer: (D). Publish to web wizard


Answer: (A). Pivot


Answer: (A). Calculated

138. (400). _____________ report can be created with minimal user input.

Answer: (C). auto report


Answer: (A). tabular form


object.

Answer: (A). Filters


data.

Answer: (B). report


Answer: (C). record source


Answer: (B). embedded

144. (650). ___________ VB Module is accessible to all the Forms and Reports in a database.

Answer: (C). Global


to edit data.

Answer: (B). form


tables.

Answer: (B). Connect

147. (390). ____________ option is selected from the view menu to create macros with

conditions.

Answer: (A). Conditions


Answer: (C). expression builder


table.

Answer: (D). auto number


Answer: (B). chart

151. (270). ___________ forms are usually used for tables with one to many relationship.

Answer: (A). Subforms

152. (640). _____________ page in an web application is used to navigate to the rest of the

pages in the application.

Answer: (B). Home



Answer: (C). No fields


Answer: (B). MsgBox

155. (550). OLE stands for ___________________.

Answer: (A). Object linking and embedding


records.

Answer: (A). delete


158. (50).





Answer: (B). Bridges


Answer: (B). Network layer

164. (260). ATM stands for ___________.

Answer: (B). Asynchronous transfer mode


Answer: (A). Multiplexing


Answer: (C). Packets

167. (170). TCP/IP stands for ___________.

Answer: (A). Transfer control protocol/Internet protocol


Answer: (B). Bus topology


Answer: (B). WAN


Answer: (C). Hyper text



Answer: (C). Gateways


Answer: (B). Tocken bus


Answer: (C). Layer n protocol


smaller packets.

Answer: (B). Transport layer


Answer: (A). Workstations

176. (100). ISDN stands for ______________.

Answer: (C). Integerated Services Digital networks

177. (60). Modem stands for ___________ .

Answer: (B). Modulation/Demodulation


Answer: (B). Hubs


shared on the LAN.

Answer: (A). Server


_________ layer.

Answer: (C). Physical layer

181. (210). The Hierarchical topology is also called as __________.

Answer: (B). Vertical network


Answer: (B). Internet


Answer: (B). Ethernet


transmitted.

Answer: (B). Presentation layer


the ring.

Answer: (C). Tocken


segments.

Answer: (B). Router


propagated.

Answer: (C). Repeaters


Answer: (B). LAN and WAN

189. (10). Two types of coaxial cables used in an Ethernet are

Answer: (A). Thick and thin


_______.

Answer: (C). Link protocol


it is

Answer: (B). Printer server

192. (50). Expansion of ISDN is

Answer: (C). Integrated Services Digital Network


Answer: (A). ISDN


Answer: (B). Duplex communication

195. (110). .________ connect LANs.

Answer: (B). Routers


Answer: (A). True


Answer: (A). Normal


Answer: (B). Visual Basic


Answer: (C). AutoShapes


Answer: (A). True


Answer: (A). Tab


Answer: (A). AutoCorrect


Answer: (B). shift +left and shift + right


Answer: (A). Word 2000


Answer: (C). Ruler


Answer: (B). Macro


Answer: (B). document1


Answer: (A). Internet

209. (550). Drop cap tool does not work for the contents in the Table format

Answer: (A). True

210. (310). The key that is used to paste the selected text

Answer: (A). Ctrl+v or Ins


Answer: (A). HTML


Answer: (A). Border


Answer: (A). Picture Bullet Dialog Box


Answer: (A). Print layout view


Answer: (D). Up and Down arrow Keys


Answer: (C). Both a and b


Answer: (A). Drawing Toolbar


Answer: (A). Shift + F8


Answer: (A). Wizard


Answer: (A). CTRL+SHIFT+F


Answer: (A). Master document


Answer: (A). True


Answer: (D). Clear All


Answer: (A). Web layout, PrintLayout


Answer: (A). Special effects


Answer: (B). rows & columns

227. (190). Pick out the element from the following that does not form the type of tabs for the Word2000

Answer: (D). Rotation


Answer: (A). Click-n-type


Answer: (A). Convert Text to Table


Answer: (C). CTRL+SHIFT+S


Answer: (A). True


Answer: (A). True


Answer: (A). Insert mode


Answer: (A). Thesaurus


Answer: (A). office clipboard


Answer: (A). 1


Answer: (A). Template


Answer: (A). Ctrl+A


Answer: (A). Screen Tip


Answer: (A). Pagesetup from the File Menu


Answer: (A). Office Assistant


Answer: (B). Shading


Answer: (D). Ctrl+M


Answer: (A). First


Answer: (B). False


Answer: (A). True


Answer: (B). click_n_type


Answer: (B). CTRL+5


Answer: (A). text box


Answer: (A). shift+F7

a. analog b. bus width c. cables d. cache memory e. chip f.

CISC chip

g. closed architecture h. control unit i.

expansion card

j.

flash RAM

k. firmware l.

graphics processor

m. parallel port n. PC card o. port p. RAM q. smart card r. system board s. system clock t.

system unit

1. Houses most of the electronic components in a computer system. _______ 2. The number of bits that can travel down a bus at the same time. _______ 3. The communication web for the entire computer system. ________ 4. Consists of a circuit board etched on a stamp-sized square of silicon. ________ 5. Tells the computer system how to carry out a program’s instructions. ________

6. Type of signal created by our voices. _______ 7. The most common type of microprocessor. _________ 8. A credit card size piece of plastic with an embedded chip. _________ 9. Volatile storage that holds the program and data the CPU is currently processing. _________ 10. Fast, temporary holding area between the memory and CPU. ________ 11. Procedures precisely timed electrical beats as a timing mechanism. ________ 12. machines that users cannot easily add new devices to __________ 13. Also called plug-in boards, controller cards, adapter cards, and interface cards. _______ 14. Also called ROMs. ________ 15. Credit card-sized expansion boards used by portable computers. ________ 16. Handles computations related to graphics images. ________ 17. Connecting socket on the outside of the system unit. ________ 18. Connects external devices that need to send lots of data a short distance. ________ 19. Another name for flash memory. _________ 20. Connects input and output devices to the system unit via the ports. ________

a. Clarity b. Cordless mouse c. CRT d. Digital camera e. Dpi f.

Ergonomic

g. Keyboard h. HDTV i.

Input

j.

Joystick

k. MFD l.

Output

m. Plotter n. Pointing stick o. Stylus p. TFT q. Thermal r. Thin client s. Toggle t.

UPC

u. Wand reader

1. Any data or instruction used by a computer. ________ 2. Alleviates wrist strain from typing. ________ 3. These keys turn a feature on or off. ________ 4. Also known as a wireless mouse. ________

5. Similar to a mouse, this device is located in the middle of the keyboard 6. A pointing device widely used for computer games. _________ 7. Pen like device commonly used with tablet PCs and PDAs. ________ 8. Scanners with photoelectric cells that reads barcodes. ________ 9. Type of bar code used in super markets. _________ 10. Similar to traditional cameras but images are recorded digitally. _________ 11. Processed data or information from a computer. ________ 12. Refers to quality and sharpness of displayed images. _________ 13. Type of monitor similar to a television set. ______ 14. Multifunctional device. _________ 15. Monitors that have independently activated pixels. _______ 16. Delivers a much clearer wide- screen picture than your regular television. __________ 17. Measurement used to determine a printer’s resolution. _________ 18. Printer that uses heat to produce images on heat- sensitive paper. _THERMAL________ 19. Used to create maps , and architectural and engineering drawings. _________ 20. Terminal that typically relies on host computer or server for application and system software. _____

a. Access speed b. CD burner c. Cylinder d. Disk caching e. Disks f.

File compression

g. Fixed disk h. Flash memory card i.

Floppy disk

j.

Floppy- disk cartridge

k. Hard- disk pack l.

Tapes

m. Jewel box n. Sector o. I –drive p. Picture CD q. RAM r. Solid- state storage s. Track t.

Writing

1. A type of storage that is volatile. _________ 2. A process of saving a file to secondary storage device. _________ 3. Time required tom retrieve data and programs. _________ 4. Also known as a diskette or disk. _________

5. Closed concentric ring on a disk on which data is recorded. _________ 6. Wedge- shaped section of a track. _________ 7. Zip disks, super disks, HIFD disks. __________ 8. Runs through each track of a stack of platters. ________ 9. Several platters aligned one above the other, allowing greater storage capacity. _________ 10. Hardware and software that anticipates data needs.__________ 11. Increases storage capacity by reducing the amount of space required to store data and programs. _________ 12. Used to protect optical disks. _________ 13. CD-R drive._________ 14. Special CD format for storing digital pictures. ________ 15. Stores data electronically and has no moving parts. _________ 16. Solid-state storage device used in portable computers. _________ 17. Free or low- cost storage available at special service websites. _________ 18. Provide fast direct access. __________ 19. Provide slower sequential access. _________ 20. Also known as internal hard disk. _________

a. ADSL b. Bandwidth c. Bluetooth d. Client e. Coaxial cable f.

Communication system

g. Computer network h. Dedicated i.

Distributed processing

j.

Firewall

k. Host l.

Hybrid network

m. Infrared n. Packets o. Protocol p. Star q. TCP/IP r. Topology s. Transfer speed t.

Wide area network

1. Transmits data over communication lines between locations._________ 2. Wireless connection that uses light waves over short distances. _________ 3. High-frequency transmission cable with a single solid- copper. _________ 4. Uses microwaves to transmit data over short distances up to 33 feet. _________ 5. Measured in bits per second. __________

6. Type of DSL. ________ 7. Measurement of the width of a communication channel. _________ 8. Rules for exchanging data between computers. _________ 9. Standard protocol for the Internet. ___________ 10. Broken-down parts of a message sent over the Internet. ________ 11. A large centralized computer. ___________ 12. The type of server that performs specific tasks. __________ 13. Communications system connecting two or more computers that work together to exchange information and share resources. ___________ 14. A node that requests source from other nodes. ___________ 15. Countrywide and worldwide networks. __________ 16. The configuration of a network. __________ 17. This type of network links computer and other devices to central unit. _________ 18. System in which computing power is located and shared at different locations. __________ 19. Also known as hierarchical network. ___________ 20. Protects network from external threats. __________

Question Computer Mcq

Recommend Documents