MS Excel MCQs Archives

1. You cannot link excel worksheet data to a word document

A. With the right drag method

B. With a hyperlink

C. With the copy and paste special commands

D. With the copy and paste buttons on the standard toolbar

✅ The correct answer is option D.

2. To copy cell contents using drag and drop press the

A. End key

B. Shift key

C. Ctrl key

D. Esc key

✅ The correct answer is option C.

3. In a worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All of the above

✅ The correct answer is option D.

4. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

A. Option buttons

B. List boxes

C. Text boxes

D. Combo boxes

✅ The correct answer is option C.

5. Excel files have a default extension of in Excel-2003

A. Xls

B. Xlw

C. Wk1

D. 123

✅ The correct answer is option A.

6. 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

✅ The correct answer is option D.

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

A. Efficiency

B. Aditibility

C. Description

D. Clarity

✅ The correct answer is option C.

8. The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this?

A. You have to retype everything and manually add the dollar signs, commas, and decimals

B. Select Format > Money from the menu

C. Click the Currency Style button on the formatting toolbar

D. None of these

✅ The correct answer is option C.

9. Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

✅ The correct answer is option A.

10. 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

✅ The correct answer is option B.