Microsoft Excel Exam WK 3

Front

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

Back

True

Front

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.

Back

False

Front

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.

Back

True

Front

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

Back

True

Front

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.

Back

True

Front

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

Back

True

Front

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

Back

True

Front

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

Back

True

Front

Arrow keys can be used to move any chart element.

Back

True

Front

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.

Back

True