MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 261 - 270 of 1111 Questions

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
Correct Answer

Option B: Excel edits cell references in the newly copied formula


Discussion

Which of the following is the latest version of Excel

A Excel 2000
B Excel 2002
C Excel ME
D Excel XP
Correct Answer

Option D: Excel XP


Discussion

To copy cell contents using drag and drop press the

A End key
B Shift key
C Ctrl key
D Esc key
Correct Answer

Option A: End key


Discussion

Which of the following is not a worksheet design criterion?

A Efficiency
B Aditibility
C Description
D Clarity
Correct Answer

Option C: Description


Discussion

Comments can be added to cells using

A Edit > Comments
B Insert > Comments
C File > Comments
D View > Comments
Correct Answer

Option B: Insert > Comments


Discussion

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
Correct Answer

Option D: Select it and then press the delete key


Discussion

Files created with Lotus 1-2-3 have an extension

A DOC
B XLS
C 123
D WK1
Correct Answer

Option C: 123


Discussion

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 of the above
Correct Answer

Option D: All of the above


Discussion

Right clicking something in Excel:

A Deletes the object
B Nothing the right mouse button is there for left handed people
C Opens a shortcut menu listing everything you can do to the object
D Selects the object
Correct Answer

Option C: Opens a shortcut menu listing everything you can do to the object


Discussion

You can use the drag and drop method to

A Copy cell contents
B Move cell contents
C Add cell contents
D a and b
Correct Answer

Option D: a and b


Discussion



WhatsApp Support