Using PivotTables to answer questions
Suppose 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 very 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 is both easy to read and manipulate. Perform the following.
Use the PivotTable to calculate and summarize the data.
Once you have created a PivotTable, change the order amount to currency.
What is the amount sold by each salesperson?
What is the total amount sold in each month?
Take a screenshot or use the Snipping tool to copy the worksheet where the new pivot table and pivot table fields appear to show your work. Paste the screen images into a Word doc.
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.