Microsoft Excel Questions & Answers - Page 6

26.

When integrating Word and Excel, Word is usually the

A.

Server

B.

Destination

C.

Client

D.

Both b and c

Correct answer is D

No explanation has been provided for this answer.

27.

How do you delete a column in Excel?

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 is D

Right click the column heading you want to delete and select delete from the shortcut menu in Excel 2003.
From 2007 and Higher version Home > Delete > Delete Sheet Columns.

28.

To create a formula in Excel, you first

A.

Select the cell you want to place the formula into

B.

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

C.

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

D.

Choose the new command from the file menu

Correct answer is B

No explanation has been provided for this answer.

29.

How do you select an entire column in Excel?

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 is B

No explanation has been provided for this answer.

30.

How do you insert a row in Excel?

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 is A

No explanation has been provided for this answer.