Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.3. Apply and manipulate PivotTables 4. What Do
You See? There are four Categories. Each
Category has a Subtotal. The names and the sum of the amounts for
each Product sold is listed in alphabetical order in the client
categories. What Else
Do You See? The Row Labels in Cell A3 have Filters. You can use the
filter to show some or all of the Categories. This is a good
place to pause and try that again. Try switching the fields from the Row
Labels to the Column Labels. Look at the PivotTable and see which way is
easiest to read, which way makes more sense. Then, Save.
Memo to Self: These numbers may
look odd because they are not formatted for currency.
PivotTable Tools ->Options
|
|
| |
