Page 471 - Computer Software Application TP - Volume 1
P. 471
COMPUTER SOFTWARE APPLICATION - CITS
TASK 1: Let’s say we wanted to answer the question: What is the amount sold by each salesperson? for
the sales data in the example below. Answering this question could be time consuming and difficult-
each salesperson appears on multiple rows, and we would need to total all of their different orders
individually. We could use the Subtotal command to help find the total for each salesperson, but we
would still have a lot of data to work with.
Fortunately, a PivotTable can instantly calculate and summarize the data in a way that’s both easy to read and
manipulate. When we’re done, the PivotTable will look something like this:
Once you’ve created a PivotTable, you can use it to answer different questions by rearranging-or pivoting-the
data. For example, if we wanted to answer the question: What is the total amount sold in each month? we
could modify our PivotTable to look like this:
To create a PivotTable:
1 Select the table or cells (including column headers) containing the data you want to use.
2 From the Insert tab, click the PivotTable command.
456
CITS : IT & ITES - Computer Software Application - Exercise 75
