Exam 26: Entering Worksheet Formulas

When evaluating formulas, the ____ of parentheses is evaluated first.

You can press the ____ key to cycle a selected cell reference from a relative reference to an absolute reference to a mixed reference with an absolute row to a mixed reference with an absolute column and back to a relative reference.

You can also switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys.

Case EX 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers. Kayden wants to customize which calculations appear on the status bar. What should she do next?

Worksheet users frequently need to add long columns or rows of numbers. The ____________________ button, makes this operation simple.

When using the Sum button, the active cell displays the sum.

The formulas replace the formula results in the worksheet. If a cell does not contain a formula, the cell appears shaded out.

After you finish typing a formula in a cell, you must enter it by pressing the ____.

FIGURE EX 4-1 In Figure EX 4-1 above, number 3 is pointing to the ____ menu.

Each formula begins with a quotation mark (").

Case EX 4-2 Ben is copying some formulas and wants to make sure he has the cell references correct. Ben wants to copy a formula that is the sum of five rows. He wants the formula to change as he copies it so that it shows the sum of five rows for each column. What type of cell reference should Ben use?

A ____ border indicates that you can replace the current reference in the formula by clicking another cell or selecting a range.

The formula =4*D5 is an example of a(n) ____________________ operation.

Whenever you select a range, the Ribbon shows the results of common calculations for the selected cells.

FIGURE EX 4-1 In Figure EX 4-1 above, number 1 is pointing to the ____ button.

The formula =C8-232 is an example of a division operation.

When formulas with mixed cell references are copied or moved, the row or column references preceded by a question mark do not change.

The ____________________ calculation lists how many of the selected cells contain numbers.

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.

If you discover that you need to make a correction, you can edit the formula. Click the cell with the formula you want to edit. Press the ____ or double-click the cell to enter editing mode.