Using the data provided in the spreadsheet, construct a Pivot Table displaying the Sum of Average..

a. 8 Points: Using the data provided in the spreadsheet, construct a Pivot Table displaying the Sum of Average Quarterly Sales (body of table), displayed by “Sales Person” (Row Fields) and “Software Product” (Column Fields). Have the table placed with the uppermost left corner in cell A105. b. 4 Points: Calculate and display total sales for each quarter for all software products in cells D95 through G95. c. 2 Points: Using the Pivot Table Output, what are the total average quarterly sales for all software products? (Place the answer in cell B98) d. 2 Points: Using the Pivot Table Output, what are the total average quarterly sales for Dbaseintegrator? (Place the answer in cell B99) e. 2 Points: Using the Pivot Table Output, what are the total average quarterly sales for Sales Person Turley? (Place the answer in cell B100)

“Order a similar paper and get 20% discount on your first order with us Use the following coupon “GET20”