Exam 10: Excel_Module_3

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet. _________________________

You can click the Logical button (FORMULAS tab | Function Library group) and click IFERROR to insert the IF function. _________________________

The ____ function is useful when you want to assign a value to a cell based on a logical test.

Panes created using the vertical split bar scroll together horizontally. ________________________

Using the mouse to move or copy cells is called ____.

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

The arguments in an IF function are ____.

You can select nonadjacent ranges using the SHIFT key.

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

Which of the following is not a valid format symbol?

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

The path to the Format Painter button is ____.

The <= comparison operator means less than or equal to.

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.

Cell references in a formula are called ____.

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.