2. What Do
You See? You will be prompted to choose the Sort Options. By
default, the Values are sorted as follows: Smallest to
Largest Top to Bottom Click OK
to accept the defaults, please. What Else
Do You See? The Subtotals for each group (Corporate, Educational,
etc) were sorted Smallest to Largest. Look Again:
The Totals for each product are NOT sorted Smallest to Largest.
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.3. Apply and manipulate PivotTables:
Sort & Filter
PivotTable Tools ->Options-> Sort & Filter
|
|
| |
