MS Excel III

Indicate whether the statement is true or false. 1. To rotate cell contents, you use the Alignment tab in the Format Cells dialog box.

• True

• False

Indicate whether the statement is true or false. Penina wants to insert markers into a sparkline chart. To do so, she can click on the following: Sparkline chart > Design > Line > Markers check box.

• True

• False

Indicate whether the statement is true or false. To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

• True

• False

Indicate whether the statement is true or false. To move a worksheet, you can drag its sheet tab to the left or right.

• True

• False

Indicate whether the statement is true or false. Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

• True

• False

Indicate whether the statement is true or false. To paste only a copied cell's formats, use the Paste Special command.

• True

• False

Indicate whether the statement is true or false. 7. Jose inserts the formula '=DATE('2000, 2, 2)' in cell AI5. Upon pressing ENTER, 2/2/2000 will appear in AI5.

• True

• False

Indicate whether the statement is true or false. 8. You can repeatedly paste an item from the Office Clipboard as many times as you like.

• True

• False

Indicate whether the statement is true or false. Arrow keys can be used to move any chart element.

• True

• False

Indicate whether the statement is true or false. Dean wants to insert five blank rows above a row. To do so, he can select the heading of the row above which he wants to insert the additional rows, hold Ctrl key, click the selected rows, and then click Insert on the pop-up menu.

• True

• False