In Excel, the Fill Color button on the Formatting toolbar is used for what?

Options: To insert a background. B. To add borders. C. To select a distribution of figures. D. To add shading or color to a cell range.

Ans:– D ,

Description: mcqquestions

More MS-Excel Related questions:

A numeric error code check: A 17xx indicates a problem with:
Options: CMOS,    ROM BIOS,    DMA controller,    hard drive or controller

Ans:D ,D

Frames from one LAN can be transmitted to another LAN via the device
Options: Router,    Bridge,    Repeater,    Modem

Ans:B ,B

The communication mode that supports two-way traffic but only one direction at a time is
Options: simplex,    duplex,    half duplex,    multiplex

Ans:C ,C

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Options: a. report writer b. query language c. data manipulation language d. transaction log


Which of the following are the five built-in functions provided by SQL?

Ans:A ,A

The three different types of pen plotter technology are flatbed, drum, and:
Options: electrostatic,    thermal,    pinch roller,    impact

Ans:C ,C

Which of the following is used to create newspaper style columns?
Options:  A) Format Tabs, B) Table Insert Table, C) Insert Textbox, D) Format Columns, 


When you are testing a fuse, you should set the Volt-OHM meter to what scale?
Options: AC,    DC,    AMPS,    OHMS

Ans:D ,D

The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Options: Overlapping rule,    Disjoint rule,    Total specialization rule,    Partial specialization rule

Ans:D ,D

. A .... is a named location on a disk where files are stored
Options: a. Folder b. Pod c. Version d. None of the above

Ans: a, a

. 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

. In MS-Word, for what does ruler help?
Options: a. to set tabs b. to set indents c. to change page margins d. All of the above

Ans: –  D , –  D

. Which of the following is text browser?
Options: a. Lynx b. Hot Java c. Netscape d. Internet Explorer

Ans:5 – a ,5 – a

. For which of the following computers can’t be used?

Options: A) gathering data B) calculating data C) comparing data D) Arranging data


Which of the following is being investigated as a means of automating the creation of a knowledge base?
Options: automatic knowledge acquisition,    simpler tools,    discovery of new concepts,    All of the above

Ans:D ,D

Which bitwise operator is suitable for turning off a particular bit in a number?
Options: && operator,    & operator,    || operator,    ! operator

Ans:B ,B

A technique for displaying applications where complex 3-D geometric are required for the exteror shall of a product is called:
Options: solid modeling,    2-D modeling,    3-D modeling,    surface modeling

Ans:D ,D

The language that is an input for statement translation is called
Options: Assembly language,    Source language,    High-level language,    Object language

Ans:B ,B

. The Basic Input Output System (BIOS) resides in
Options: a. RAM b. ROM c. The CPU d. Memory Cache

Ans: b, b

Point out the correct statement which correctly allocates memory dynamically for 2D array following program? #include<stdio.h> #include<stdlib.h> int main() { int *p, i, j; /* Add statement here */ for(i=0; i<3; i++) { for(j=0; j<4; j++) { p[i*4+j] = i; printf("%d", p[i*4+j]); } } return 0; }
Options: p = (int*) malloc(3, 4);,    p = (int*) malloc(3*sizeof(int));,    p = malloc(3*4*sizeof(int));,    p = (int*) malloc(3*4*sizeof(int));

Ans:D ,D

. Which of the following is a disk compression tool?
Options: a. Drive space b. Scandisk c. Defragmenter d. None of the above

Ans:5 – a ,5 – a

Which of the following might be used to convert high-level language instructions into machine language?
Options: system software,    applications software,    an operating environment,    an interpreter

Ans:D ,D

Which of the following commands will take you directly to the root directory no matter what subdirectory you are currently in?
Options: CD \root,    CD\,    CD\..,    CD..

Ans:B ,B

Operating system, editors, and debuggers comes under?
Options: System Software B. Application Software C. Utilities D. None of the above

Ans:– A ,

The following method/s are used in Transportation Models of Operations Research:
Options: VogeFs Approximation Method,    North West Corner Method,    Least Cost Method,    All of the above

Ans:D ,D

Which one of the following statements is true for the voltages in a series RC circuit?
Options: The total voltage is equal to the sum of the voltages across the resistance and capacitance,    The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is less than the sum of the voltages across the resistance and capacitance,    The total voltage is greater than the sum of the voltages across the resistance and capacitance

Ans:C ,C

. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
Options: a. Formula b. Field c. Data d. Query

Ans:A,– a

The following are components of a database except ________ .
Options: user data,    metadata,    reports,    indexes

Ans:C ,C

. An input /output device at which data enters or leaves a computer system is
Options: A) Keyboard B) Terminal C) Printer D) Plotter


If you will be displaying or printing your document on another computer, you’ll want to make sure and select the _____________ option under the ‘Save’ tab.
Options: a. Embed Fonts b. Embed True Type Fonts c. Save True Type Fonts d. Save Fonts

Ans:– B,– B

. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Options: a.  F8 b.  F9 c.  F10 d.  F11

Ans:– b,– b

The cray X-MP, IBM 3090 and connection machine can he characterized as
Options: SISD,    SIMD,    MISD,    MIMD

Ans:B ,B

An optional facilitates location program can be used to study
Options: factory location alternative,    warehouse location alternatives,    plant location alternatives,    All of the above

Ans:D ,D

4. …….transforms one interface into another interface
Options: a. Program b. Software c. Data d. None

Ans:Correct Answer: b,Correct Answer: b

Which controller would support an external CD-ROM drive?
Options: ESDI,    ARLL,    MFM,    SCSI

Ans:D ,D

Perforated paper used as input or output media is known as
Options: Paper tape,    Magnetic tape,    Punched paper tape,    Card punch

Ans:A ,A

Any storage device added to a computer beyond the immediately usable main storage is known as
Options: Floppy disk,    Hard disk,    Backing store,    Punched card

Ans:C ,C

. In a junction table, the _____ field consists of the foreign key from both the linked tables.
Options: a. first defined b. last defined c. foreign key d. primary key

Ans:7 – c ,7 – c

Set of premitted values of each attribute is called
Options: Domain B. Tuple C. Relation D. Schema

Ans:– A ,

. The notable features like keyboards, monitors, GUI were developed in
Options: A) First generation B) Second generation C) Third generation D) Fourth generation


Which of the following is not a level of information handling:
Options: Decision Support System (DSS),    Operations Assistance System,    Transaction Processing System (IPS),    Office Automation System.

Ans:B ,B

.   Animation schemes can be applied to ….. in the presentation
Options: a. All slides b. Select slides c. Current slide d. All of the above

Ans:5 – D ,5 – D

Direct Numerical Control means:
Options: using several computers to control one large machine,    using one computer to control several machines,    complete elimination of a need for a human operator.,    eliminating computers from the manufacturing process

Ans:B ,B

. Generally, the DATE is entered in the form
Options: a. DD-YY-MM b. YY-DD-MM c. MM-YY-DD d. MM-DD-YY

Ans:Correct Answer: d ,Correct Answer: d

. Which is the system prompt?
Options: a. c> b. c:> c. c:> d. None

Ans:7 – b ,7 – b

Which of the following is not true of nonprocedural language?
Options: They can be English-like.,    They can take user-friendly forms.,    BASIC is an example of a nonprocedural language.,    All of the above are true

Ans:C ,C

When using a database management system, the first thing that you must do is to
Options: create a database file,    activate file editor,    load the software into your micro¬computer,    keep a floppy disk in readiness

Ans:C ,C

The 2's complement of a binary no. is obtained by its 1's complement.
Options: 0 ,    1,    10,    12


Which common bus specification provides the fastest data transfer rate?
Options: VL bus,    ISA,    PCI,    All of the above

Ans:C ,C

A notation used to express clearly on algorithm is known as
Options: Algorithmic language,    Assembly language,    Machine language,    High level language