2011

■ =(a6+d6)/e1. Adds the values in A6 and D6 and divides the total by
the value in E1.
Use a colon to define a range of cells and a comma for individual cells.
A formula must start with an equal sign (=) and can contain any of
the following signs: plus (+), minus (-), times (*), divided by (/),
exponent (^), and parentheses ().
3 To save your changes and exit the editor, click in the drawing outside
the editor.
The cell displays the result of the calculation.
To change the background color of column letters and row numbers for
tables
1 Click a grid line to select a table.
2 Right-click. Click Table Indicator Color.
3 In the Select Color dialog box, select a color.
4 Click OK.
The text color, size, and style and the line color are controlled by the
settings for column heads in the current table style.
To insert a Formula field in a table cell
1 Click inside the table cell.
2 On the Table toolbar, click Insert Field.
3 In the Field dialog box, Field Category list, select Objects.
4 In Field Names, select Formula.
5 To enter a formula, do one of the following:
■ Click Average, Sum, or Count. The Field dialog box closes temporarily.
To specify a range, click inside the first and the last cell. The result is
appended to the formula.
■ Click Cell. The Field dialog box closes temporarily. Select a cell in a
table in the drawing. The cell address is appended to the formula.
6 (Optional) Select a format and a decimal separator.
7 Click OK.
1414 | Chapter 30 Tables