Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
2
Click the Enter
box in the formula
bar to enter a sum
in the active cell
(Figure 1–19).
What is the purpose
of the Sum button
arrow?
If you click the Sum
button arrow on
the right side of
the Sum button
(Home tab | Editing
group) (Figure 1–19),
Excel displays a list of
often used functions
from which you
can choose. The list
includes functions
that allow you to determine the average, the number of items in the selected range, the
maximum value, or the minimum value of a range of numbers.
SUM function
assigned to
active cell B9
shows in
formula bar
Sum button
arrow
sum of numbers
in cells B4, B5,
B6, B7, and B8
Figure 1–19
Other Ways
1. Click Insert Function
button in the formula
bar, select SUM in
Select a function
list, click OK button,
select range, click
OK button
2. Click Sum button arrow
(Home tab | Editing group),
click More Functions,
select SUM (Insert Function
dialog box), click OK
button, select range, click
OK button
3. Type
S in cell, select SUM
from list, select range
4. Press ALT + EQUAL SIGN (=)
twice
=
Using the Fill Handle to Copy a Cell
Entering Numbers
as Text
Sometimes, you will want
Excel to treat numbers,
such as postal codes and
telephone numbers, as
text. To enter a number
as text, start the entry
with an apostrophe (‘).
Excel also must calculate the totals for Chamber City in cell C9, Pattonsville in cell D9,
Sable Village in cell E9, Strongville in cell F9, and the Town of Cary in cell G9. Table 1– 2
illustrates the similarities between the entry in cell B9 and the entries required to sum the
totals in cells C9, D9, E9, F9 and G9.
Table 1– 2 Sum Function Entries in Row 9
Cell
Sum Function Entries
Remark
B9
=SUM(B4:B8)
Sums cells B4, B5, B6, B7, and B8
C9
=SUM(C4:C8)
Sums cells C4, C5, C6, C7, and C8
D9
=SUM(D4:D8)
Sums cells D4, D5, D6, D7, and D8
E9
=SUM(E4:E8)
Sums cells E4, E5, E6, E7, and E8
F9
=SUM(F4:F8)
Sums cells F4, F5, F6, F7, and F8
G9
=SUM(G4:G8)
Sums cells G4, G5, G6, G7, and G8

Search JabSto ::

Custom Search