Exam 10: Excel Lesson 4: Entering Worksheet Formulas

The formula = E6/4 is an example of a(n) ____ operation.

Formulas can include more than one operator.

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

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

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

The Calculations tab on the Ribbon contains all the buttons you need when working with manual calculations.

If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5.

Consider the formula =B3+5. In this formula, the cell reference B3 and the constant 5 are operands .

Each formula begins with a quotation mark (").

To switch to manual calculation, click the ____ button in the Calculation group on the Formulas tab, and then click Manual.

The Sum button is located in the ____ group on the Home tab of the Ribbon.

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.

Worksheet formulas consist of two components: ____________________ and operators.

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

To make all formulas visible, click the Formulas tab on the Ribbon, and then click the Show Formulas button in the ____ group.

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?

The SUM function that adds the numbers in the range D5:D17 is ____.

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

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

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