ity $8-$ PivotTables $($Tutorial$)$

Search this cours

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 to familiarize you with Excel's PivotTable feature and learn about its uses. You will learn how to use PivotTables by developing a crosstabulation of region, quality rating, and meal price for $300$ restaurants and then answering questions about the data. The data for this problem is located on the 'Data' sheet in columns A through D of the Excel Online file below. An empty PivotTable is provided on the 'Plvot' sheet. Click on the 'Plvot' tab to select the PivotTable sheet. Inside the PivotTable$1$ area right$-$click and select Show Field List. The PivotTable task pane should now be displayed on the right side of the spreadsheet. In the field list you should see Restaurant, Region, Quality Rating, and Meal Price $($$$).$ Construct a spreadsheet to answer the following questions.

Open spreadsheet

Questions

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?

$\backslash$table$[[,$Total Sales$],[$East$,$$