150 very important Excel MCQs for test and interview

71. “Documentation” should include,

a. Destination and users, of the output data,

b. Source of input data,

C. Information, on the purpose of the workbook,

d. All ,

72. Files created, with Lotus 1-2-3 have, an extension

a. DOC,

b. XLS,

c. 123

d. WK1,

73. To delete, an embedded objects, first,

a. Double. click the object,

b. Select the, object by clicking it,

C. Press the Shift + Delete keys,

d. Select it and, then press the delete key,

74. Comments, can be added to cells, using

a. Edit > Comments,

b. Insert> Comments,

C. File > Comments,

d. View > Comments,

75. Which of the, following is not a worksheet, design criterion?

a. Efficiency,

b. Auditability,

c. Description,

d. Clarity,

76. To copy cell, contents using drag and drop, press the:

a. End key,

b. Shift key,

C. Ctrl key,

d. Esc key,

77. Which of the, following is the “latest version” of Excel,

a. Excel 2000,

b. Excel 2002,

C. Excel ME,

d. Excel XP,

78. When, you copy a formula:

a. Excel erases, the original copy of the, formula

b. Excel edits cell, references in the newly, copied formula

C. Excel adjusts, absolute cell references,

d. Excel doesn’t, adjust relative cell, references

79. The “auto fill feature”:

a. extends a sequential, series of data,

b. automatically, adds range of cell, values

c. Capplies a boarder, around the selected cells,

d. none ,

80. Which menu, option can be sued, to split windows ,into two:

a. Format> window,

b. View > window> split,

C. Window > split,

d. View > split,