. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

Options: The Settings tab under the menu Format -> Cells B. The Settings tab under the menu Data -> Validation C. The Settings tab under the menu Data -> Filter -> Advanced Filter D. the Settings tab under the menu Format -> Conditional Formatting

Ans:– B ,

More MS-Excel Related questions:

. Queries in access can be used as
Options: a. View, change and analyze data in different ways b. A source of records for forms and reports c. Only a d. Both a and b

Ans:4 – d ,4 – d

. Floppy disks which are made from flexible plastic material are also called?
Options: A) Hard disks B) High-density disks C) Diskettes D) Templates


In a synchronous modem, the receive equalizer is known as
Options: adaptive equalizer,    impairment equalizer,    statistical equalizer,    compromise equalizer

Ans:A ,A

From which menu you can insert Header and Footer?
Options:  A) Insert Menu, B) View Menu, C) Format menu, D) Tools Menu,


The size of a field with Number data type can not be
Options: a. 2 b. 4 c. 8 d. 16

Ans:ndash; d,ndash; d

Which of the following is not true of the traditional approach to information processing?
Options: There is common sharing of data among the various applications,    It is file-oriented,    Programs are dependent on the files,    It is inflexible

Ans:A ,A

An MIS provides
Options: past information,    present information,    future information,    All of the above

Ans:D ,D

Which part of computer performs functions similar to the cerebrums of the above cardiac and nervous system of a human body.
Options: ALU,    Input device,    CPU,    Control unit

Ans:C ,C

Which one of the following properties of a magnetic circuit can be directly compared to resistance in an electrical circuit?
Options: Reluctance,    Permeability,    Permeance,    Retentivity

Ans:A ,A

. The system unit of a personal computer typically contains all of the following except:

Options: A) Microprocessor B) Disk controller C) Serial interface D) Modem


Systems that supply data for operations execution or supervision all concern
Options: exception reports,    computing systems,    orders,    All of the above

Ans:C ,C

The two kinds of main memory are:
Options: A) Primary and secondary B) Random and sequential C) ROM and RAM D) All of above


To invoke the LISP system, you must enter
Options: AI,    LISP,    CL (Common Lisp),    both b and c

Ans:D ,D

You must service the laser printer in your office. Which part of the printer shoud you avoid touching because it is hot?
Options: fuser,    printer head,    primary corona,    high-voltage power supply

Ans:A ,A

. To insert slide numbers
Options: a.  Insert a text box and select Insert >> Page Number b.  Insert a textbox and select Insert >> Number >> PageNumber c.  Choose Insert >> Slide Number d.  Insert a new text box and select Insert >> slide Number

Ans:8 – D ,8 – D

When did arch rivals IBM and Apple Computers Inc. decide to join hands?
Options: 1978,    1984,    1990,    1991


A computer will function only if it
Options: has a control unit,    is given input data,    has a program in its memory,    has software package

Ans:C ,C

Impact printers
Options: strike a ribbon against the paper to produce character images,    include ink-jet and thermal devices,    are more expensive than Laser printers,    use optical technology


.   Which of the following is not a way to create a new presentation?
Options: a. Using the Scan-In Slides feature b. From scratch (create a blank presentation c. Using a template d. Using the auto content wizard

Ans:6 – A ,6 – A

.   Which types of fonts are best suitable for titles and headlines
Options: a. serif fonts b. sans serif fonts c. text fonts d. picture fonts

Ans:3 – B ,3 – B

An up/down counter used in a TI510PC has three inputs. Which of the following is not one of them?
Options: Count up,    Count out,    Reset.,    Count down

Ans:B ,B

What is the standard protocol for network management features?
Options: SNA,    FTP,    SNMP,    SMS

Ans:C ,C

75. When inserting Page number in footer it appeared 1 but you wish to show
Options: a. How can you do that?

Ans:– C ,– C

________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Options: ODBC,    OLE DB,    JPCD,    ADO

Ans:A ,A

Goals for the design of the logical schema include
Options: avoiding data inconsistency,    being able to construct queries easily,    being able to access data efficiently,    All of the above

Ans:D ,D

The Internet is an example of
Options: Cell switched network B. circuit switched network C. Packet switched network D. All of above

Ans:– C ,

Indicate which is a pre-emptive scheduling algorithm
Options: Round-robin,    Shortest-job-next,    Priority-based,    All of the above

Ans:A ,A

Both conditions display on the same row in the design grid when ___operator is in use
Options: a. OR b. IN c. AND d. LIKE

Ans:ndash; c,ndash; c

. Which of the following symbol sets would be most likely to contain a mathematical symbol such as a degree sign, greater than or equal to, or a Greek letter?
Options: a. Wingdings b. Wingdings 3 c. Webdings d. Symbol

Ans: – D , – D

Layer one of the OSI model is
Options: network layer,    transport layer,    link layer,    physical layer

Ans:D ,D

The language that the computer can understand and execute is called
Options: Machine language,    Application software,    System program,    All of the above

Ans:A ,A

. Operating system is
Options: a. A collection of software routines b. A collection of hardware components c. A collection of input and output devices d. All of above

Ans:0 – a ,0 – a

.  In a module, a(n) _______ is a series of commands and properties that perform a specific task.
Options: a.            event b.           property c.           procedure d.            macro

Ans:– c,– c

Special software to create a job queue is called a
Options: Drive,    Spooler,    Interpreter,    Linkage editor

Ans:B ,B

Compilers and interpreters are themselves
Options: High-level language,    Codes,    Programs,    Mnemonics


. “Ctrl + Down Arrow” is used to
Options: a. Moves the cursor one paragraph down b. Moves the cursor one line down c. Moves the cursor one page down d. Moves the cursor one screen down

Ans:–  A,–  A

Pressing F8 key for three times selects
Options:  A) A word, B) A sentence, C) A paragraph, D) Entire document,


The octal equivalent of the number 11010.1011 is
Options: 32.54,    63.51,    32.27,    All of the above

Ans:A ,A

Which of the following is not applications software?
Options: Word processing,    Spreadsheet,    UNIX,    Desktop publishing

Ans:C ,C

In order to play and hear sound on a computer, one needs:
Options: a sound card and speakers B. a microphone C. all of them required D. none of them required

Ans:– A ,

Which one of the following principles best describes the basic operation of an electromagnet?
Options: Current is induced in a conductor that is moving through a magnetic field,    Like magnetic poles repel, while unlike poles attract,    Current flowing through a conductor generates a magnetic field,    Like magnetic poles attract, while unlike poles repel

Ans:C ,C

Which of the following terminals' output most closely resembles the output produced by a plotter?
Options: graphics terminal,    POS terminal,    hardcopy terminal,    all the above

Ans:A ,A

  Power Point presentation is a collection of ________
Options: Slides and Handouts B. Speaker’s notes C. Outlines D. All of the above

Ans:– D ,

. Search engines use a(n) __________ to automatically index sites.
Options: a. crawler b. query c. enterprise d. sitebuilder

Ans:1 – a ,1 – a

. To record a sequence of keystrokes and mouse actions to play back later we use:
Options: a. Media player b. Sound Recorder c. Calculator d. Macro Recorder

Ans:– d,– d

. To display the content of the disk we use
Options: a. Format b. Dir c. Copy d. WinZip

Ans:6 – b ,6 – b

A remote batch-processing operation in which data is solely input to a central computer would require a:
Options: telegraph line,    simplex lines,    mixedband channel,    All the above

Ans:B ,B

. Which of the following creates a drop down list of values to choose from?
Options: a. Ole object b. Hyperlink c. Memo d. Lookup wizard

Ans:7 – d ,7 – d

A rectangle represents which of the following in an EER?
Options: Attribute,    Entity,    Optional One,    Relationship

Ans:B ,B

Options: works best with many small partitions,    allows many programs to use memory simultaneously,    allows each program in turn to use the memory,    does not work with overlaying

Ans:C ,C