Think of some company (existing or made-up). Every type of business can be
separated into pieces. The summary sheet brings the total of the pieces
together to determine the Grand Total.
Instructions:
1. Open a blank Excel workbook and save as LastName, FirstName - 3DFormula
2. Create one individual sheet i.e. Bar Revenue Sheet
3. Try to make the sheet as complete as possible
4. Copy the sheet for the other two data sheets i.e. Restaurant Revenue Sheet, In Room Service Sheet
5. Change the appropriate labels and values in the two new sheets
6. Create the Summary Sheet where the values in the sheet are formulas that refer to the three data sheets
7. In the summary sheet use a 3D formula (sum) to get the Grand Total
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
29 | 30 | 31 | 1 | 2 | 3 | 4 |
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 | 1 |
Get Free Quote!
269 Experts Online