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.

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

A cell reference with only one Dollar sign before either the column or the row is called an absolute reference.

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

The path to the Logical button is (FORMULAS tab | Function Library Group).

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

The range of entries that identifies the major groups for a clustered column chart are called the category names.

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

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

you can press the CTRL+ACCENT MARK(') keys to display the formulas in a worksheet.

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

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.

__________ are values in cells that can be changed to determine new values for formulas.

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.

The _______ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

The ______ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.

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

When the Paste Options button is visible, you can use _________ to access the paste commands available in the Paste Options gallery.

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n) __________ operation.

Excel displays the error message __________ in cells to indicate a cell reference error in a formula.

A(n) _________ cell reference instructs a past operation to keep the same cell reference as it copies a formula from one cell to another.

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

You can specify the style and color for the parts of a Sparkline chart by selecting a style in the Styles group on the __________.

Excel allows you to __________________ the title so that the titles remain on the screen no matter how far down or to the right you scroll.

A sensitivity analysis is another name for a(n) __________ analysis.

you use the _____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

To open the Format Cells dialog box with the Alignment sheet active, click the Alignment Settings ______.

Which of the following patterns extends the fill series to 525, 475, 425?

______ refers to cells not wide enough to display the entire entry.

Error messages begin with the ____ symbol.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

You can replace a formula with its function so it remains constant.

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

____ text often provides a strong visual appeal.