Microsoft Excel MCQs with answers Page - 2

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 • 802.91K Points
Coach

Q. Which command need to execute from "run window" to open a new excel file

  • (A) ms excel
  • (B) win excel
  • (C) office excel
  • (D) excel

A

Admin • 802.91K Points
Coach

Q. If "A1" is displayed in Name Box, then is indicates which one

  • (A) First column (by A) and first row (by 1)
  • (B) First column (by 1) and first row (by A)
  • (C) First sheet
  • (D) None of the above

A

Admin • 802.91K Points
Coach

Q. Which function key generates a bar graph from the values entered in excel

  • (A) F9
  • (B) F10
  • (C) F11
  • (D) F12

A

Admin • 802.91K Points
Coach

Q. Total number of characters that a cell can contain

  • (A) 24,221
  • (B) 27,685
  • (C) 32,767
  • (D) 39,802

A

Admin • 802.91K Points
Coach

Q. You can check the conditions against __________ when applying conditional formatting

  • (A) Cell value
  • (B) Formula
  • (C) Both of above
  • (D) None of above

A

Admin • 802.91K Points
Coach

Q. When a range is selected, how can you activate the previous cell?

  • (A) Press the Alt key
  • (B) Press Tab
  • (C) Press Enter
  • (D) None of above

A

Admin • 802.91K Points
Coach

Q. You can use the formula palette to

  • (A) Format cells containing numbers
  • (B) Create and edit formula containing functions
  • (C) Enter assumptions data
  • (D) Copy a range of cells

A

Admin • 802.91K Points
Coach

Q. VBA in MS-Excel was used from which version

  • (A) Excel 4
  • (B) Excel 5
  • (C) Excel 6
  • (D) Excel 7

A

Admin • 802.91K Points
Coach

Q. What is the default extension of Microsoft Excel 2003 saved file

  • (A) .xls
  • (B) .xsl
  • (C) .xlsx
  • (D) .xlxs

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.