Microsoft Excel MCQs with answers Page - 12

Dear candidates you will find MCQ questions of Microsoft Excel here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

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
💬 Discuss
✅ Correct Answer: (C) The resulting values of a formula instead of the actual formula

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:21 pm in Microsoft Excel

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
💬 Discuss
✅ Correct Answer: (D) Press Ctrl +Home

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:21 pm in Microsoft Excel

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

  • (A) WK1
  • (B) 123
  • (C) XLS
  • (D) DOC
💬 Discuss
✅ Correct Answer: (B) 123

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:22 pm in Microsoft Excel

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

  • (A) Clarity
  • (B) Description
  • (C) Aditibility
  • (D) Efficiency
💬 Discuss
✅ Correct Answer: (B) Description

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:23 pm in Microsoft Excel

Q. Which symbol must all formula begin with?

  • (A) @
  • (B) (
  • (C) +
  • (D) =
💬 Discuss
✅ Correct Answer: (D) =

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:23 pm in Microsoft Excel

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
💬 Discuss
✅ Correct Answer: (B) Serial Number 50771

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:24 pm in Microsoft Excel

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
💬 Discuss
✅ Correct Answer: (C) No data will be entered in the adjacent cells

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:25 pm in Microsoft Excel

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
💬 Discuss
✅ Correct Answer: (D) All of the above

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:27 pm in Microsoft Excel

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
💬 Discuss
✅ Correct Answer: (C) Excel edits cell references in the newly copied formula

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:28 pm in Microsoft Excel

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

  • (A) ‘ (apostrophe)
  • (B) _ (underscore)
  • (C) = (equal)
  • (D) ” (quote)
💬 Discuss
✅ Correct Answer: (A) ‘ (apostrophe)

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:29 pm in Microsoft Excel

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play