Excel Functions Quiz

To rotate cell contents, you use the Alignment tab in the Format Cells dialog box.

• True

• 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

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

To move a worksheet, you can drag its sheet tab to the left or right.

• True

• 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 select Insert, select Line Sparkline from the Sparklines group and then OK.

• True

• False

To paste only a copied cell's formats, use the Paste Special command.

• True

• False

Jose inserts the formula '=DATE(2000, 2, 2)' in cell A15. Upon pressing ENTER, 2/2/2000 will appear in A15.

• True

• False

You can repeatedly paste an item from the Office Clipboard as many times as you like.

• True

• False

Arrow keys can be used to move any chart element.

• True

• 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