Activity – Excel 9: Calculations and percentages
- Start a new Excel workbook.
- Click the File tab and then Save As to save the spreadsheet as Your Name TEP021 Excel 9 in the Documents folder on your computer.
- Create the following table below your name.
Darwin Desserts and Drink Supplies |
|||||||
|
Jan |
Feb |
Mar |
Apr |
Ave |
Max |
Min |
Ice Cream Fudge |
48 |
69 |
107 |
198 |
|
|
|
Coca Cola Delight |
102 |
55 |
66 |
99 |
|
|
|
4. Insert a function to calculate the average values for the four months.
5. Insert functions to calculate the maximum and the minimum values for the four months.
6. Create the following table under the previous one.
Darwin Party Supplies |
||||
Item |
Cost |
Mark-up Rate |
Mark-up Amount |
Sale Price |
Balloons |
$22.50 |
10% |
|
|
Whistles |
$15.75 |
27% |
|
|
Hats |
$17.95 |
15% |
|
|
7. Create a formula to calculate the Markup Amount.
Hint: Markup Amount = Cost × Markup Rate
8. Create a formula to calculate the Sale Price.
Hint: Sale Price = Cost + Markup Amount
9. Create the following table.
Darwin Computer Sales |
|||
Area |
2007 |
2008 |
Increase by % |
Darwin City |
3456 |
4481 |
|
Casuarina |
3567 |
4587 |
|
Palmerston |
2834 |
2210 |
|
10. Create a formula to calculate the Increase by %.
Hint: Increase by % = (Column 2008 – Column 2007) ÷ Column 2007
11. Apply the Percentage number format to the Increase by % figures and keep two decimal places (e.g., 2.53%).
12. Make sure no table is split across 2 pages.
13. Add a header with your name and student number on the left and the date on the right.
14. Save and close your workbook.
15. Upload the completed activity document to the TEP021 Activities folder on OneDrive.