1. What are the sales totals for each region? To answer this question, proceed as follows. First, click on Region in the Field List and then drag it to the rows box in the PivotTable pane. You will see the four regions enter the PivotTable. Next, drag Meal Price ($) into the values box of the PivotTable pane. The second column in the Pivot Table should now be Sum of Meal Price ($). What are the total sales for each Region and the Grand Total? Total Sales East $ North $ South $ West $ Grand Total $ 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 PivotTable (where it was used to answer Question 1) and then drag it back into the Field List. Next, drag Quality Rating from the Field Ust into the rows box of the PivotTable pane. What are the total sales for each Quality Rating? Total Sales Excellent $ Good 5 Very Good s