Microsoft Excel MCQs with answers Page - 12

Here, you will find a collection of MCQ questions on Microsoft Excel. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 828.03K Points
Coach

Q. The Paste Special command lets you copy and paste:

  • (A) Cell comments
  • (B) Formatting options
  • (C) The resulting values of a formula instead of the actual formula
  • (D) Multiply the selection by a copied value

A

Admin • 828.03K Points
Coach

Q. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

  • (A) Press Alt + Home
  • (B) Press Shift + Home
  • (C) Press Home
  • (D) Press Ctrl +Home

A

Admin • 828.03K Points
Coach

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

  • (A) WK1
  • (B) 123
  • (C) XLS
  • (D) DOC

A

Admin • 828.03K Points
Coach

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

  • (A) Clarity
  • (B) Description
  • (C) Aditibility
  • (D) Efficiency

A

Admin • 828.03K Points
Coach

Q. Which symbol must all formula begin with?

  • (A) @
  • (B) (
  • (C) +
  • (D) =

A

Admin • 828.03K Points
Coach

Q. Which of the following is not an example of a value?

  • (A) 0.57
  • (B) Serial Number 50771
  • (C) May 10, 2001
  • (D) 350

A

Admin • 828.03K Points
Coach

Q. It is acceptable to let long text flow into adjacent cells on a worksheet when

  • (A) There is not time to format the next
  • (B) There is no suitable abbreviation of the text
  • (C) No data will be entered in the adjacent cells
  • (D) Data will be entered in the adjacent cells

A

Admin • 828.03K Points
Coach

Q. Documentation should include

  • (A) Information on the purpose of the workbook
  • (B) Destination and users of the output data
  • (C) Source of input data
  • (D) All of the above

A

Admin • 828.03K Points
Coach

Q. When you copy a formula

  • (A) Excel doesn’t adjust relative cell references
  • (B) Excel adjusts absolute cell references
  • (C) Excel edits cell references in the newly copied formula
  • (D) Excel erases the original copy of the formula

A

Admin • 828.03K Points
Coach

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

  • (A) ‘ (apostrophe)
  • (B) _ (underscore)
  • (C) = (equal)
  • (D) ” (quote)

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.