When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

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

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

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

Which of the following is an extension of the fill pattern Sunday, Tuesday?

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

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

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

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

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

Which of the following is not a valid format symbol?

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

Which of the following formulas contains an absolute cell reference?

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

Which comparison operator means “not equal to”?

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

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

You can press the ____ keys to open the Format Cells dialog box.

The path to the Format Painter button is ____.

You should use a ____ chart to compare values side by side, broken down by category.

Charts can either be embedded in a worksheet or placed in a separate ____.

Which of the following is the path to the Zoom button?

When working with a large worksheet, you can split the window into ____ panes.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

Which of the following are formatting symbols?

The arguments in an IF function are ____.

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

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

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.

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.