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

to Adjacent Cells

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