Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. If the cell B1 contains the formula = $A$1, which of the following statements is true
a. There is a relative reference to cell A1
b. There is an absolute reference to cell A1
c. Further changes in value of A1 will not affect the value of B1
d. Further changes in value of B1 will affect the value of A1
Q. Worksheet can be renamed by
a. Adding ? symbol at the end of filename while saving workbook
b. Click on Worksheet tab by Holding CTRL Key and type new name
c. Double Click on the Worksheet tab and type new name
d. Worksheet cannot renamed
Q. What is the shortcut key to insert a new comment in a cell?
a. F2
b. Alt + F2
c. Ctrl + F2
d. Shift + F2
Q. 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
Q. What is the shortcut key to insert new sheet in current workbook?
a. F11
b. Alt + F11
c. Ctrl + F11
d. Shift + F11
Q. In maximum, how many sheets can be set as default while creating new workbook?
a. 254
b. 255
c. 256
d. No Limit
Q. In Excel, by default Numeric Values appears in
a. Left aligned
b. Right aligned
c. Center aligned
d. Justify aligned
Q. 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
Q. 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
Q. In Excel _______ may not contain in Formula
a. Text Constant
b. Number Constant
c. Circular Reference
d. All of them
Q. In Excel the following is not an example of a value
a. 350
b. May 10, 2001
c. 57&per cent
d. Serial Number 50771