2

Chapter 8 Creating Tables 185
4 The values in the Unit Price and the Cost column are displayed using a number
format.
To see the number format settings, close the Formula Editor by clicking outside the
table. Then click the table, click the Unit Price cell in the second row, click Inspector in
the toolbar, select the Table Inspector, and click the Numbers button.
See “Formatting Numbers” on page 178 for instructions for using formatted numbers.
5 If the value in a Quantity cell or in a Unit Price cell changes, the formula associated
with the Cost cell updates the value it displays.
Double-click the value in B2, type a different number, click outside B2, and notice that
the value in E2 changes.
6 The value displayed for each cell in the Cost column above the subtotal is derived
using values in each row.
To view the formula for a different Cost cell, double-click the cell. For example, double-
click the Cost cell in the third row (E3). Its formula is B3*C3.
7 Click outside the table, click the table, and then double-click E10, the cell in the Cost
column that’s next to the label “Subtotal.” The formula uses the SUM function to add
the values in cells E2 through E9.
In the formula, the cell references are enclosed in parentheses following the function
name—SUM(E2:E9). E2 and E9 are separated using a colon. The colon is a shorthand
way to refer to a range of cells, in this case, a range of eight cells.
A $ is displayed in front
of numbers in the cells.
The comma is used as
the thousands separator.
Numbers are displayed using
two decimal places.
Number formatting is
active for Unit Price cells.