Page 474 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

7 The PivotTable will calculate and summarize the selected fields. In our example, the PivotTable shows the
amount sold by each salesperson.

Just like with normal spreadsheet data, you can sort the data in a PivotTable using the Sort & Filter command
in the Home tab. You can also apply any type of number formatting you want. For example, you may want to
change the Number Format to Currency. However, be aware that some types of formatting may disappear when
you modify the PivotTable.

459
CITS : IT & ITES - Computer Software Application - Exercise 75