MS Excel MCQ (Multiple Choice Questions)

Which of the following Excel screen components can NOT be turned on or off?

a) Formula bar
b) Status bar
c) Toolbar
d) None of the above

Check Answer

All of the listed components (Formula Bar, Status Bar, and Tool Bar) can be turned on or off in Excel. To turn them on or off, you can go to the “View” tab in the ribbon and use the options in the “Show” group.
For example, to turn the Formula Bar on or off, you can click the “Formula Bar” option in the “Show” group. To turn the Status Bar on or off, you can click the “Status Bar” option in the “Show” group. And to turn the Tool Bar on or off, you can click the “Toolbar” option in the “Show” group.
Therefore, the correct answer is D) None of above.
Which tool you will use to join some cells and place the content at the middle of joined cell

a) From View Tab click on the Merge cells check box
b) From the format cells dialog box select the centered alignment
c) From Insert Tab choose Merge and Center
d) Click on the Merge and Center tool on Home Tab
e) None of above

Check Answer

To join some cells and place the content at the middle of the joined cell in Excel, you can use the “Merge and Center” tool. This tool is located in the “Alignment” group on the “Home” tab in the ribbon.
To use the “Merge and Center” tool, you can select the cells that you want to join, and then click the “Merge and Center” tool. This will merge the selected cells and center the content within the merged cell.
For example, if you have a series of cells A1 to C1 that you want to merge and center, you can select cells A1 to C1, and then click the “Merge and Center” tool. This will merge cells A1 to C1 into a single cell, and center the content within the merged cell.
Therefore, the correct answer is d) Click on the Merge and Center tool on Home Tab.
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a) Unfreeze panes command on the Insert Menu
b) Freeze panes command on the View Menu
c) Hold the titles command on the Data Menu
d) Split command on the window menu
e) None of above

Check Answer

b) Freeze panes command on the View Menu is the correct answer. This allows you to keep certain rows or columns visible as you scroll through the rest of the worksheet. To use this feature, you need to select the cell below the rows and to the right of the columns that you want to keep visible, and then click the Freeze Panes option in the View menu.
Exact Study
Logo