MCQ of Microsoft Excel – Set 12

A new MCQ Questions set on the category of Microsoft Excel. Here in this set you’ll get 10 Multiple Choice Questions related to Microsoft Excel and four options for each questions having only one options correct option. Select your answer first and then check with given correct answer. Correct answers of these Questions are given end of this question set.

Microsoft Excel

Multiple Choice Questions of Microsoft Excel

12-1. What is the shortcut key to insert a new comment in a cell?
A. F2
B. Alt + F2
C. Ctrl + F2
D. Shift + F2

12-2. Which option allows you to Bold all the negative values within the selected cell range:
A. Zero Formatting
B. Conditional Formatting      
C. Compare Formatting
D. Negative Formatting

12-3. What is the shortcut key to insert new sheet in current workbook?
A. F11
B. Alt + F11
C. Ctrl + F11
D. Shift + F11

12-4. Which one is the last column header in Excel 2007?

12-5. In maximum, how many sheets can be set as default while creating new workbook?
A. 254
B. 255
C. 256
D. No Limit

12-6. “New Comment” option can be found under _________ tab
A. Insert
B. Data
C. Review
D. View

12-7. In Excel, by default Numeric Values appears in
A. Left aligned
B. Right aligned
C. Center aligned
D. Justify aligned

12-8. To show/hide the grid lines in Microsoft Excel 2007
A. Page Layout -> Grid lines -> View
B. Insert -> Grid lines -> View
C. View -> Grid lines -> View
D. Edit -> Grid lines -> View

12-9. What will be the result if you type =A1=B1 in cell C1?
A. Yes or No
B. True or False
C. Value of A1
D. Value of B1

12-10. In Excel _______ may not contain in Formula
A. Text Constant
B. Number Constant
C. Circular Reference
D. All of them


Click Here for Answers
1 – D / 2 – B / 3 – D / 4 – A / 5 – B / 6 – C / 7 – B / 8 – A / 9 – B / 10 – C

Incoming search terms:

  • in excel by default numeric values appears in
  • excel mcq questions with answers pdf
  • what will be the result if you type =a1=b1 in cell c1
  • What is the second to the last column of an Excel 2010 worksheet?
  • microsoft excel questions and answers pdf
  • ms excel 2007 objective questions and answers pdf
  • mcq networking excel
  • mcqs about ms excel
  • excel is a mcq
  • ms excel related objective questions and answers

2 Responses to “MCQ of Microsoft Excel – Set 12”

  1. fatma abid 8 April 2013 at 3:40 PM

    very intresting questions

  2. Princeshitta 15 July 2014 at 1:22 PM

    very good!

Leave a Reply