Chapter 5 PivotTable Review.
1. How would you explain PivotTables to someone who has never used them
-Pivot tables are useful because you have so much sales data. If you had columns like
salesman, region and revenue- you could use pivot tables to
Excel Formulas and Order of Precedence
Sum of 1st and 2nd values
Difference between 4th and 1st values
Product of 2nd and 3rd values