Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
4
•
Repeat Steps 1–3 to select cells N9 to N17 and calculate and display the sums of the corresponding rows (Figure 1– 26).
Sum button
SUM function entered
in range N9:N17
Figure 1– 26
1
ENTER
TEXT

2
CALCULATE
SUMS
&
USE
FORMULAS

3
SAVE
WORKBOOK

4
FORMAT
TEXT
5
INSERT
CHART

6
NAME
TAB

7
PREVIEW
&
PRINT
WORKSHEET
To Enter a Formula Using the Keyboard
The formulas needed in the worksheet are noted in the requirements document as follows:
Net (row 19) = Income – Expenses
The net for each month, which appears in row 19, is equal to the income total in row 6 minus the expense
total in row 17. The following steps enter the initial net formula in cell B19 using the keyboard.
Why?
Sometimes
a predened function does not t your needs; therefore, you enter a formula of your own.
1
•
Select cell B19 to
deselect the selected
range.
•
Type
=b6b17
in the cell to display
the formula in the
formula bar and in
the current cell and
to display colored
borders around the
cells referenced
in the formula
(Figure 1– 27).
formula displayed
in formula bar
formula entered in B19 (green
outline), which will display B6 (blue
highlight) minus B17 (red highlight)
What occurs on the
worksheet as I enter
the formula?
The
equal sign
)
=
preceding b6–b17 in
the formula alerts Excel
that you are entering a
formula or function and not text. Because the most common error when entering a formula is to reference
the wrong cell in a formula, Excel colors the borders of the cells referenced in the formula. The coloring helps
in the reviewing process to ensure the cell references are correct. The
minus sign
) following b6 in the formula is
–
the arithmetic operator that directs Excel to perform the subtraction operation.
Figure 1– 27