Clicking any cell in the table puts
you into edit mode (see Figure 7-12). Click a cell to highlight it, and then change any values
necessary by using the keyboard to enter alphanumeric characters. Notice the table handle in
each corner of the table; drag these handles to add rows and columns with super ease.
FIGURE 7-10 The anatomy of a table
Header row
Columns
Footer row
Rows
Cells
Header column
162 How to Do Everything: Mac
Understand Formulas
Tables use formulas to calculate the values of other cells. To see the formula used by a cell,
click the cell in the very bottom right of the Monthly Net Income table. The Formula Bar shows
the formula that has been assigned to that cell, and even color-codes the values of other cells
according to which part of the formula they affect (see Figure 7-13). I know the pictures in this
book are black and white, but you can still tell by the shades of gray that there is a difference
between the colors of cells B2 and B3. The color of Amount Monthly Net Income in the
formula corresponds to the color of cell B2, and the color of Amount Planned Monthly Savings
corresponds to the color of cell B3.
Pages:
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231