MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 1 - 10 of 1111 Questions

In Excel _______ may not contain in Formula

A Text Constant
B Number Constant
C Circular Reference
D All of them
Correct Answer

Option C: Circular Reference


Discussion

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
Correct Answer

Option B: True or False


Discussion

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
Correct Answer

Option A: Page Layout -> Grid lines -> View


Discussion

In Excel, by default Numeric Values appears in

A Left aligned
B Right aligned
C Center aligned
D Justify aligned
Correct Answer

Option B: Right aligned


Discussion

“New Comment” option can be found under _________ tab

A Insert
B Data
C Review
D View
Correct Answer

Option C: Review


Discussion

In maximum, how many sheets can be set as default while creating new workbook?

A 254
B 255
C 256
D No Limit
Correct Answer

Option B: 255


Discussion

Which one is the last column header in Excel 2007?

A XFD
B XFX
C XFL
D XFT
Correct Answer

Option A: XFD


Discussion

What is the shortcut key to insert new sheet in current workbook?

A F11
B Alt + F11
C Ctrl + F11
D Shift + F11
Correct Answer

Option D: Shift + F11


Discussion

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
Correct Answer

Option B: Conditional Formatting


Discussion

What is the shortcut key to insert a new comment in a cell?

A F2
B Alt + F2
C Ctrl + F2
D Shift + F2
Correct Answer

Option D: Shift + F2


Discussion



WhatsApp Support