MS Excel MCQs

Question 1

Comments can be added to cells using

Accepted Answer

Insert > Comments

Answer

Edit > Comments

Answer

File > Comments

Answer

View > Comments

Question 2

Which of the following is not a worksheet design criterion?

Accepted Answer

Description

Answer

Efficiency

Answer

Aditibility

Answer

Clarity

Question 3

To copy cell contents using drag and drop press the

Accepted Answer

Ctrl key

Answer

End key

Answer

Shift key

Answer

Esc key

Question 4

Which of the following is the latest version of Excel

Accepted Answer

Excel 365

Answer

Excel 2007

Answer

Excel 2016

Answer

Excel XP

Question 5

When you copy a formula

Accepted Answer

Excel edits cell references in the newly copied formula

Answer

Excel erases the original copy of the formula

Answer

Excel adjusts absolute cell references

Answer

Excel doesn’t adjust relative cell references

Question 6

The autofill feature

Accepted Answer

All of the above

Answer

Extends a sequential series of data

Answer

Automatically adds range of cell values

Answer

Applies a boarder around the selected cells

Question 7

Which menu option can be used to split windows into two

Accepted Answer

View > window > split

Answer

Format > window

Answer

Window > split

Answer

View > split

Question 8

Which of the following is an absolute cell reference?

Accepted Answer

$A$1

Answer

!A!1

Answer

#a#1

Answer

A1

Question 9

What symbol is used before a number to make it a label?

Accepted Answer

‘ ( apostrophe )

Answer

” ( quote )

Answer

= ( equal )

Answer

_ ( underscore )