Microsoft Excel MCQs with answers Page - 3

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. Which of the following is invalid statement?

  • (A) Sheet tabs can be colored
  • (B) Some picture can be applied as a background of a sheet
  • (C) You can set the column width automatically fit the amount of text
  • (D) The width of a row and be specified manually or fit automatically
💬 Discuss
✅ Correct Answer: (D) The width of a row and be specified manually or fit automatically

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:51 pm in Microsoft Excel

Q. What is the maximum number of columns supported in a Excel 2007 worksheet

  • (A) 12,357
  • (B) 16,384
  • (C) 21,783
  • (D) 26,263
💬 Discuss
✅ Correct Answer: (B) 16,384

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:52 pm in Microsoft Excel

Q. What is the maximum number of rows supported in a Excel 2007 worksheet

  • (A) 65,357
  • (B) 78,487
  • (C) 1,028,176
  • (D) 1,048,576
💬 Discuss
✅ Correct Answer: (D) 1,048,576

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:52 pm in Microsoft Excel

Q. The intersection of rows and columns are called

  • (A) Sheet
  • (B) Cell
  • (C) Workbook
  • (D) None of the above
💬 Discuss
✅ Correct Answer: (B) Cell

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:52 pm in Microsoft Excel

Q. Which of the following is not true about Find and Replace in Excel

  • (A) You can search for bold and replace with italics
  • (B) You can decide whether to look for the whole word or not
  • (C) You can search in formula too
  • (D) You can search by rows or columns or sheets
💬 Discuss
✅ Correct Answer: (A) You can search for bold and replace with italics

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:53 pm in Microsoft Excel

Q. You can move a sheet from one workbook into new book by

  • (A) From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
  • (B) From Edit menu choose Move of Copy then choose (Move to end) and click OK
  • (C) From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:53 pm in Microsoft Excel

Q. Comments can be added to cells using ________

  • (A) Home > Comments
  • (B) Insert > Comment
  • (C) Data > Comments
  • (D) Review > Comments
💬 Discuss
✅ Correct Answer: (D) Review > Comments

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:54 pm in Microsoft Excel

Q. Which menu option can be used to split windows into two?

  • (A) Review > Window
  • (B) View > Window > Split
  • (C) Window > Split
  • (D) View > Split
💬 Discuss
✅ Correct Answer: (B) View > Window > Split

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:54 pm in Microsoft Excel

Q. Which one is not available in print area selection option when you print a Excel document

  • (A) Entire workbook
  • (B) Columns
  • (C) Active Sheet(s)
  • (D) Table
💬 Discuss
✅ Correct Answer: (B) Columns

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:55 pm in Microsoft Excel

Q. Strikethrough, Superscript and Subscript are the _______ in Excel

  • (A) Design
  • (B) Text Control
  • (C) Effects
  • (D) Style
💬 Discuss
✅ Correct Answer: (C) Effects

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:56 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