Activity – Excel 9: Calculations and percentages

  1. Start a new Excel workbook.
  2. 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.
  3. 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.

 

License

TEP021 Foundations for Success Copyright © by TEP Team, CDU. All Rights Reserved.

Share This Book