MS Excel

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 321 - 330 of 336 Questions

The name box

A Shows the location of the previously active cell
B Appears to the left of the formula bar
C Appears below the status bar
D Appears below the menu bar
Correct Answer

Option B: Appears to the left of the formula bar


Discussion

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

A Shorten the label
B Increase the column width
C Decrease the column width
D Adjust the row height
Correct Answer

Option B: Increase the column width


Discussion

When integrating word and excel, word is usually the

A Server
B Destination
C Client
D Both b and c
Correct Answer

Option D: Both b and c


Discussion

How can you find specific information in a list?

A Select Tools > Finder from the menu
B Click the Find button on the standard toolbar
C Select Insert > Find from the menu
D Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Correct Answer

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


Discussion

How do you delete a column?

A Select the column heading you want to delete and select the Delete Row button on the standard toolbar
B Select the column heading you want to delete and select Insert Delete from the menu
C Select the row heading you want to delete and select Edit>Delete from the menu
D Right click the column heading you want to delete and select delete from the shortcut menu
Correct Answer

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


Discussion

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

A Select the cells containing the title text plus the range over which the title text is to be centered
B Widen the columns
C Select the cells containing the title text plus the range over which the title text is to be enfettered
D Format the cells with the comma style
Correct Answer

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


Discussion

How do you select an entire column?

A Select Edit > Select > Column from the menu
B Click the column heading letter
C Hold down the shift key as you click anywhere in the column.
D Hold down the Ctrl key as you click anywhere in the column
Correct Answer

Option B: Click the column heading letter


Discussion

Which of the following is not a basic step in creating a worksheet?

A Save workbook
B Modifiy the worksheet
C Enter text and data
D Copy the worksheet
Correct Answer

Option D: Copy the worksheet


Discussion

How do you insert a row?

A Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
B Select the row heading where you want to insert the new row and select Edit >Row from the menu
C Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
D All of the above
Correct Answer

Option A: Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu


Discussion

Text formulas:

A Replace cell references
B Return ASCII values of characters
C Concatenate and manipulate text
D Show formula error value
Correct Answer

Option C: Concatenate and manipulate text


Discussion



WhatsApp Support