Module - 4 IDB MCQ Test

MCQ (Module – 4) : 

1. Getting data from a cell located in a different sheet is called –
A. Accessing                       B. Referencing
C. Updating                        D. Functioning

 2. If you press ___________, the cell accepts what ever you have typed as its contents.

A. Enter                                B. Ctrl + Enter
C. Tab                                    D. Insert

 3. Which of the following is an absolute cell reference?
A. !A!1                                  B. $A$1
C. #a#1                                D. A1

 4 Each time you start the MS Excel program, by default, it displays a new blank workbook containing _________ blank worksheets.
A. Two                                  B. Three
C. Four                                  D. Five

 5. Which of the following symbol is used before a number to make it a label?
A. “(quote)                         B. = (equal)
C. _ (underscore)             D. ‘(apostrophe)

6. The default text data aligned with in a cell of MS Excel Work sheet is –
A. Left                                   B. Right
C. Centre                             D. Justify 

7. The default numeric data aligned within a cell of MS Excel Worksheet is –
A. Left                                   B. Right
C. Centre                             D. Justify

8. Which of the following symbols is used for entering a formula in MS Excel?
A. =                                        B. +
C. (                                         D. @

 9. Which of the following formula has not been entered correctly?
A. =10+50                            B. =B7*B1
C. =B7+14                            D. 10+50

 10. In an MS Excel work sheet the active cell is indicated by
A. A dark wide boarder                 B. A dotted border
C. A blinking border                        D. None of above

MCQ (Module – 4) : 

1. When you enter a formula in a cell and the cell displays ####### ? It means –
A. Excel does not recognize text contained in the Formula
B. A cell reference is invalid
C. Contents cannot be displayed correctly as the column is narrow
D. Invalid Column

2. When a label is too long to fit within a MS Excel Worksheet cell, you typically must

A. Shorten the label                   B. Increase the column width
C. Decrease the column width   D. Adjust the row height

3. Al worksheet formula in MS Excel‒
A. Manipulate values
B. Manipulate labels
C. Return a formula result
D. Use the addition operator

4. You can select a single range of cells by—
A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells.
B. Pressing the Shift key and an arrow key.
C. Dragging over the desired cells.
D. Using any of the above options.

5. Getting data from a cell located in a different sheet is called …
A. Accessing                                       B. Referencing
C. Updating                                        D. Functioning

6. When you enter a formula in a cell and the cell displays #REF! . It means –
A. Excel does not recognize text contained in the Formula.
B. Invalid Column
C. Contents cannot be displayed correctly as the column is narrow.
D. A cell reference is invalid.

7. To hold row and column titles in place so that they do not scroll away from view when scrolling an Excel work sheet, we make use of–
A. Unfreeze panes command
B. Freeze panes command
C. Hold titles command
D. Split command

8. In MS-Excel, the Paste Special command lets you paste—
A. The resulting values of a formula instead of the actual formula
B. Cell comments
C. Formatting options                    D. All of the above

9. When you copy a formula
A. Excel erases the original copy of the formula
B. Excel adjusts cell references in the newly copied formula
C. Excel adjusts absolute cell references
D. Excel doesn’t adjust relative cell references

10. MS Excel uniquely identifies cells within a worksheet with a cell name that consists of—
A. Cell names
B. Column numbers and row letters
C. Column letters and row numbers
D. Cell locator co-ordinates