Quiz #8 Excel Chapter 3

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

$A$5

In the formula =B6*$B$2, which of the following describes $B$2?

Absolute cell reference

Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+) sign > Arrow next to Chart title > X?

Centered Overlay

Which of the following is true when you copy and paste formulas using the fill handle?

The AutoFill Options button lets you fill cells with specific elements of the copied cell.

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

To paste the value's number formatting only.

Sala wants to unfreeze the first column of his worksheet. Which of the following series of clicks will help him do so?

View tab > Windows group > Freeze Panes > Unfreeze Panes

Which of the following is true when you delete a cell?

When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells.

Which of the following does the Accessibility Checker look for? Select all the options that apply.

Worksheets with default names. Images without alternative text. Hyperlinks without alternative text.

You double-click the Format Painter button when you want to _____.

copy a cell's format to more than one cell

Bart needs to apply a sparkline style to a sparkline chart. To do so, he can click on the following: Sparkline chart > Design > Style (choose a style).

false

Decreasing a cell's indent moves its contents to the right one space.

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.

false

To move cell contents one space to the right, you can use the Increase Space button.

false

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

false

Which of the following is not a way to move cell contents?

the fill handle in the lower-right corner of an active cell or range

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

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

true

To make your workbooks usable by people with disabilities, you can add alternative text to worksheet images.

true

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

true

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

true