Microsoft Office Tutorials and References
In Depth Information
Calculating a Sum
• Click cell B5.
• Enter the remaining ﬁ rst quarter
sales numbers provided in Table 1–1
for each of the four remaining
offerings in rows 5, 6, 7, and 8 to
display the quarterly sales in the
worksheet (Figure 1–31).
row title partially
adjacent cell on
right contains data
The next step in creating the worksheet is to perform any necessary calculations, such as
calculating the column and row totals.
Determine calculations that are needed.
As stated in the requirements document in Figure 1–2 on page EX 4, totals are required for
each region, each product type, and the company. The ﬁ rst calculation is to determine the
quarterly sales for the stores in the Northeast region in column B. To calculate this value
in cell B9, Excel must add, or sum, the numbers in cells B4, B5, B6, B7, and B8. Excel’s SUM
function , which adds all of the numbers in a range of cells, provides a convenient means to
accomplish this task.
A range is a series of two or more adjacent cells in a column or row or a rectangular
group of cells. For example, the group of adjacent cells B4, B5, B6, B7, and B8 is called a
range. Many Excel operations, such as summing numbers, take place on a range of cells.
After the total quarterly sales for the stores in the Northeast region in column B is
determined, the totals for the remaining regions and totals for each product type will be
Sometimes, you will want
Excel to treat numbers,
such as Zip codes and
telephone numbers, as
text. To enter a number
as text, start the entry
with an apostrophe (‘).
Excel calculates sums for a
variety of data types. For
example, Boolean values,
such as TRUE and FALSE,
can be summed. Excel
treats the value of TRUE
as 1 and the value of
FALSE as 0. Times also can
be summed. For example,
Excel treats the sum of
1:15 and 2:45 as 4:00.