Exam 11: Excel: Working With Large Worksheets, Charting, and What-If Analysis

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

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

Explain in detail the utility of freezing worksheet columns and rows.

Which of the following is the path to the Increase or Decrease Indent button?

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable.

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

Error messages begin with the ____ symbol.

Which of the following is not a valid format symbol?

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

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

The NETWORKDAYS function checks a formula for correctness.

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

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

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

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

To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.

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