Excel MCQs Set-12

 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

---

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