6 assignments
usa94
WS1PracticePowerPoint1.pptxFrom the Restaurant data file,
Choose Insert…Pivot Table
Drag and Drop Quality Rating to Rows
Meal Price to Columns
Restaurant to Values…
But you have to choose the drop down
For restaurant in values to change it to
COUNT instead of SUM
Right click on cell B4 and choose GROUP.
IN the popup, put in 10 for starting at,
49 for ending at, and 10 by By.
Right click on cell A5 that contains the word Excellent and choose Move to End as the option.
The picture to the right is the result.
