excel homework.
| Use the data in range A1:D63 to create a PivotTable on a new worksheet. Name the new tab Prob 1 PivotTable | ||||||||
| The PivotTable must have the weekdays a the highest level row with the date as a sub level row. | ||||||||
| Contract the rows so only the Days of the week are displayed. | ||||||||
| The meals will be the columns for the PivotTable (so a lunch column and a Dinner column). | ||||||||
| The field values will be the sum of the revenue. The field values must be formatted as currency with | ||||||||
| only whole dollar values displayed. Include in the formatting the Grand Total row and column. | ||||||||
| Add a line Pivot Chart to the same worksheet as the PivotTable. Locate the PivotChart below the PivotTable | ||||||||
| with the upper left corner in cell A14. Filter the data so that only weekdays are displayed on the | ||||||||
0 comments