Microsoft Office Tutorials and References

In Depth Information

EX 26

Excel Chapter 1
Creating a Worksheet and an Embedded Chart

3

•
Click the Enter box in

the formula bar to

enter the sum of the

ﬁ rst quarter sales for

the ﬁ ve product types

for the Northeast

region in cell B9.

SUM function

assigned to active

cell B9 shows in

formula bar

Sum

button

arrow

•
Select cell B9 to

display the SUM

function assigned to

cell B9 in the formula

bar (Figure 1–34).

What is the purpose

of the Sum button

arrow?

If you click the Sum

button arrow on the

right side of the Sum

button (Figure 1–34),

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 minimum value, or the maximum value of a range of numbers.

sum of numbers

in cells B4, B5,

B6, B7, and B8

Figure 1–34

Other Ways

1. Click Function Wizard

button in formula bar,

select SUM in Select a

function list, click OK

button, select range,

click OK button

2. Click Sum button arrow

on Ribbon, click More

Functions, select SUM

in Select a function list,

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

Excel also must calculate the totals for the Southeast in cell C9, the Midwest in cell D9,

the South in cell E9, and for the West in cell F9. 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,

and F9.

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