Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. 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
Q. Comments can be added to cells using
a. Edit > Comments
b. Insert > Comments
c. File > Comments
d. View > Comments
Q. Which of the following is not a worksheet design criterion?
a. Efficiency
b. Aditibility
c. Description
d. Clarity
Q. To copy cell contents using drag and drop press the
a. End key
b. Shift key
c. Ctrl key
d. Esc key
Q. Which of the following is the latest version of Excel
a. Excel 2000
b. Excel 2002
c. Excel ME
d. Excel XP
Q. 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
Q. The autofill feature
a. extends a sequential series of data
b. automatically adds range of cell values
c. applies a boarder around the selected cells
d. none of the above
Q. Which menu option can be sued to split windows into two
a. Format > window
b. View > window > split
c. Window > split
d. View > split
Q. What symbol is used before a number to make it a label?
a. “ (quote)
b. = (equal)
c. _ (underscore)
d. ‘ (apostrophe)
Q. Which of the following formulas will Excel Not be able to calculate?
a. =SUM(Sales)-A3
b. =SUM(A1:A5)*.5
c. =SUM(A1:A5)/(10-10)
d. =SUM(A1:A5)-10