The data for question $1$ is located on the worksheet names Software. The worksheet contains a

database containing information related to a software company$$s sales of network and database

software to corporate customers. The database reveals the software products, the sales region, the

salesperson, and each salesperson$$s quarterly, total, and average sales $($in dollars$)$ for each product

for the last four quarters.

The current worksheet is full of data, but the format doesn$$t provide much useful information.

Using Pivot Tables, we can distill the data into information that will aid in describing many aspects

of the business. We can use Pivot Tables to answers questions like