Page 27 - Code & Click - 6

Some common formulas that can be used to perform calculations in a table are:

SUM( ) to calculate the sum of a group of values.

MAX( ) to calculate the maximum value from a group of values.

MIN( ) to calculate the minimum value from a group of values.

AVERAGE( ) to calculate the average of a group of values.
The location of the group of values used in the formula is specified by using one of the keywords –

Above, Below, Left, and Right, in the parentheses after the formula name.

To calculate the sum of a group of numeric values in a table:
1. Type the values in the cells of a column. 3

2. Click the cell below the last value.
3. On the Layout tab, click the Formula
button in the Data group.

The Formula dialog box opens with
the formula = SUM(ABOVE) in the
Formula text box.

2 1

4

4. Click the OK button.
The sum of values is displayed in
the cell.

P
Post-Processingost-Processing
 A table is an arrangement of text in the form of vertical columns and horizontal rows.
 The options under the Table command to insert a table in a document are - Table grid,
Insert table, Quick Tables, and Convert Text to Table.
 The Table Design and Table Layout tabs provide options to change the appearance and
structure of a table.
 The structure of a table can be modified by adding or deleting rows and columns from it.
 Word provide formatting features to change the appearance of the table structure as well
as its contents.
 Pictures can be inserted in a table to display information graphically.

 Word allows simple calculations on numeric data in a table using formulas.

25