Microsoft Excel MCQs with answers Page - 3

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

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

Q. The intersection of rows and columns are called

  • (A) Sheet
  • (B) Cell
  • (C) Workbook
  • (D) None of the above

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

Q. Comments can be added to cells using ________

  • (A) Home > Comments
  • (B) Insert > Comment
  • (C) Data > Comments
  • (D) Review > Comments

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

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

  • (A) Design
  • (B) Text Control
  • (C) Effects
  • (D) Style

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