MS Excel MCQs

Question 1

To create a formula, you first:

Accepted Answer

Type the equals sign (=) to tell Excel that you’re about to enter a formula

Answer

Select the cell you want to place the formula into

Answer

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

Answer

Choose the new command from the file menu

Question 2

To center worksheet titles across a range of cells, you must

Accepted Answer

Select the cells containing the title text plus the range over which the title text is to be centered

Answer

Widen the columns

Answer

Select the cells containing the title text plus the range over which the title text is to be enfettered

Answer

Format the cells with the comma style

Question 3

How do you delete a column?

Accepted Answer

Right click the column heading you want to delete and select delete from the shortcut menu

Answer

Select the column heading you want to delete and select the Delete Row button on the standard toolbar

Answer

Select the column heading you want to delete and select Insert Delete from the menu

Answer

Select the row heading you want to delete and select Edit>Delete from the menu

Question 4

How can you find specific information in a list?

Accepted Answer

Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

Answer

Select Tools > Finder from the menu

Answer

Click the Find button on the standard toolbar

Answer

Select Insert > Find from the menu

Question 5

When integrating word and excel, word is usually the

Accepted Answer

Both b and c

Answer

Server

Answer

Destination

Answer

Client

Question 6

When a label is too long to fit within a worksheet cell, you typically must

Accepted Answer

Increase the column width

Answer

Shorten the label

Answer

Decrease the column width

Answer

Adjust the row height

Question 7

The name box

Accepted Answer

Appears to the left of the formula bar

Answer

Shows the location of the previously active cell

Answer

Appears below the status bar

Answer

Appears below the menu bar

Question 8

Comments put in cells are called

Accepted Answer

Cell Tip

Answer

Smart Tip

Answer

Web Tip

Answer

Soft Tip

Question 9

Which is used to perform what if analysis?

Accepted Answer

All of above

Answer

Solver

Answer

Goal seek

Answer

Scenario Manager