MCQ of Microsoft Excel – Set 12

Microsoft Excel (MCQs)
Google+0
LinkedIn0
Pinterest0

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?
A. XFD
B. XFX
C. XFL
D. XFT

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
 

Related posts:

Tags: , , , , , , ,

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

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

    very intresting questions

    Reply
  2. Princeshitta 15 July 2014 at 1:22 PM

    very good!

    Reply
  3. shahbaz 17 April 2015 at 11:22 AM

    nice service

    Reply
  4. SANTU PAL 29 August 2015 at 6:21 PM

    very good ques. and ans.

    Reply
  5. sabinakhadgi 28 May 2017 at 11:44 AM

    question no. 5 ma ans. c hoenara?

    Reply
  6. Dipesh Aggarwal 21 January 2018 at 10:52 PM

    Really Very Good Questions collection

    Reply

Leave a Reply

error: Content is protected !!