ACCOUNTING INFORMATION SYSTEMS        OBJECTIVE: ANALYZE DATA USING EXCEL PIVOT   TABLES        INSTRUCTIONS: Analyze the company’s   2016 sales data using PivotTables and answer the questions below. Create a separate PivotTable on a new sheet   to answer each question.        PIVOT TABLE #1 Question to ask the   data: How much of each product did   each salesperson sell, in units?   Steps to   get the answer: 1.1. Create a Pivot   Table that answers this main question. (Hint: the best presentation of this is   Salesperson in rows and Product in columns.)    a. Insert your Pivot Table on a new   worksheet in this workbook and rename the sheet “Question 1”.    b. Sort the Pivot Table by Salesperson   in A to Z order.    c. Change the cell formats in the Pivot Table so   the number of items sold is displayed properly (includes a comma, but no   decimal places).    d. Change the   report layout design of the Pivot Table to Tabular Format so the Row Label and Column Label are named appropriately   (Salesperson and Product).         1.2. In the highlighted fields below, enter   your answer to the following questions:     a. How many Futons did Scott McKnight sell?     b. How many total items did Norm Thompson   sell?     c. Which salesperson had the most number   of items sold?        PIVOT TABLE #2 Question to ask the   data: How much of each product did   each salesperson sell, in dollars?   Steps to   get the answer: 2.1. Create a Pivot   Table that answers this main question. (Hint: the best presentation of this is   Salesperson in rows and Product in columns.)    a. Insert your Pivot Table on a new   worksheet in this workbook and rename the sheet “Question 2”.    b. Sort the Pivot Table by Salesperson   in A to Z order.    c. Change the cell formats in the Pivot Table so   the total sales is displayed properly (to include the dollar sign and   decimal).    d. Change the   report layout design of the Pivot Table to Tabular Format so the Row Label and Column Label are named appropriately   (Salesperson and Product).         2.2. In the highlighted fields below, enter   your answer to the following questions:     a. What is the amount of total sales of Coffee Tables?     b. What was Robert Olson’s total sales of   End Tables?     c. Which salesperson had the lowest total   sales?        PIVOT TABLE #3 Question to ask the   data: What were total sales in dollars   each month for each product?   Steps   to get the answer: 3.1. Create a Pivot   Table that answers this main question. (Hint: the best presentation of this is Sale Date   in rows and Product in columns.)    a. Insert your Pivot Table on a new   worksheet in this workbook and rename the sheet “Question 3”.    b. Change the cell formats in the Pivot Table so   the total sales is displayed properly (to include the dollar sign and   decimal).    c. Change the   report layout design of the Pivot Table to Tabular Format so the Row Label and Column Label are named appropriately   (Months and Product).         3.2. In the highlighted fields below, enter   your answer to the following questions:     a. Which product had the most sales in November?     b. What were total sales of Arm Chairs in   January?     c. What were total sales of End Tables   for the year?