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.
Multiple Choice Questions of Microsoft Excel
12-1. What is the shortcut key to insert a new comment in a cell?
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?
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?
D. No Limit
12-6. “New Comment” option can be found under _________ tab
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
Incoming search terms:
- excel mcq questions with answers pdf
- What is the second to the last column of an Excel 2010 worksheet?
- in excel by default numeric values appears in
- microsoft excel questions and answers pdf
- ms excel 2007 objective questions and answers pdf
- mcq networking excel
- mcqs about ms excel
- ms excel related objective questions and answers
- ms excel questions & answers
- office automation objectives question and answer online exam