A excel project
Download
PivotTable
Answers
| Answer | Amount/Qty | Screenshots/documentation | Short description of solution steps | |
| # Records | $$$ amount | |||
| 1) | ||||
| # line items | ||||
| 2) | ||||
| Cust ID | $$$ amount | |||
| 3) | ||||
| Prod ID | # units | |||
| 4) | ||||
| Avg $$$ | ||||
| 5) | ||||
| Revenue to Recognize | ||||
| 6) | a) 2005 | |||
| b) 2006 | ||||
| c) 2007 | ||||
| d) 2008 | ||||
| 7) | Create PivotTable on "PivotTable" sheet | N/A - "PivotTable" sheet |