Excel's PivotTable Report provides an excellent way to summarize data for two or more variables simultaneously. The goal of this Excel Graded Tutorial is .m U to familiarize you with Excel's PivotTable feature and learn. about its uses. You will learn how to use PivotTables by developing a crosstabuiatlon of region, quality rating, and meal price for 300 restaurants and then answering questions about the data. The data for this columns A through D of the Excel Onllne le below. An empty PlvotTable is provided on the 'Plvot' sheet. Inside the PivotTablel area right-click and select Show Field List. The PlvotTable task pane spreadsheet. 1n the eld list you should see Restaurant, Region, Quality Rating, and Meal Price (3 questions. E Open spreadsheet problem is located on the 'Data'sheet In sheet. Click on the 'Pivot' tab to select the PlvotTable should now be displayed on the right side of the J. Construct a spreadsheet to answer the following W l Questions ' 1. What are the sales totals for each region? To answer thi$ouestlom proceed as follows. First, click on Region in the Field List and then drag it to the rows box in the PivotTable pane. Vou will see the four regions enter the PlvotTable. Next, drag Meal Price l$) into the values box of the PivotTable pane. The second column in the Pivot Table should now be Sum of Meal Price (S). What are the total sales for each Region and the Grand Total? Total Sela 2. What are the sales totals for each Quality Rating? To answer this question, proceed as follows. First, click on Region in the rows box of the PivotTabie (where it was used to answer Question 1) and then drag it back into the Field List. Next. drag Quality Rating from the Field List into the rows box of the PivotTable pane. What are the totai sales for each Quality Rating? l Total Sales Ii A4. Excellent 5 E .' Good $ l ' ' - Autosavpd at11:12AM -', - .4