SECOND QUARTER SALES FIGURES

 

 

 

April

May

June

Total

Mary Jones

51,342

62,005

60,915

 

Michelle Henry

51,225

86,584

74,279

 

Jeff Greenfield

98,705

86,242

93,655

 

Rita Hennings

62,349

65,987

70,118

 

William James

41,072

42,331

48,007

 

Sandy Pruett

45,556

48,799

48,878

 

Bill Mack

29,871

40,565

45,242

 

Valerie West

64,298

63,187

71,416

 

 

 

 

 

 

TOTAL

 

 

 

 

 

  1. Copy this page to a Microsoft Word Document file.
  2. Save the document as Sales Figures 15 and you initials.
  3. Calculate the total for the Mary Jones row:
    1. Position the insertion point in the last cell in the Mary Jones row.
    2. Open the Table menu and choose Formula.  The Formula dialog box opens, with the proposed formula =SUM(LEFT).
    3. Click OK to accept the formula.  The result of 174,262 is automatically inserted in the current cell.
  4. To quickly insert the same formula in the other cells of the Total columns, click in each cell, open the Edit menu, and choose Repeat Formula.  Do not insert a formula for the TOTAL row.
  5. Calculate the total of the April column:
    1. Position the insertion point in the last cell in the April column.
    2. Open the Table menu and choose Formula.  Word proposes =SUM(ABOVE).
    3. Click OK.  The total of 444,418 is automatically inserted.
  6. Repeat the calculation process for the other three columns.  The TOTAL row should now look like the row below:
  7. Save your changes.

 

TOTAL

444,418

495,700

512,510

1,452,628

 

Updating Calculations

After creating a table and calculating totals, you may find that you need to change the amounts.  Word does not automatically update calculations as does a spreadsheet program like Microsoft Excel.  Rather than recalculate each individual total in each column and row, Word provides a shortcut that enables you to recalculate an entire table quickly.  When you use the Formula command on the Table menu, Word inserts hidden fields for each total.  To recalculate you simply select the cells containing those fields and update the fields by pressing Update Field key, F9.

 

  1. Change the June amounts to the following:

 

Jones          69,804                         James   47,996

Henry         73,168                         Pruett   47,767

Greenfield   92,544                         Mack   44,131

Hennings    79,007                         West    70,305

 

  1. Select the table.  Note that he final total in the Total column is 1, 452,628.
  2. Press the Update field key, F9.  All sums are automatically recalculated.  Note that the final total in the Total column is now 1,464,840.
  3. Save you changes.