Activity – Excel 7: Calculations and percentages

Calculations and percentages

[This section should take you around 30 minutes to complete]

1. Start a new Excel workbook.
2. Click the File tab and then Save As to save the spreadsheet as YourName StudentNumber DigiPrep Excel7.xlsx in the OneDrive folder on your computer.
3. Insert a header with your name and student number and a footer with the name of the document and the date.
4. Create the following table and label the sheet “Darwin Desserts and Drink Supplies” by right clicking on “Sheet 1” at the bottom left of the Excel workbook.

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 in the same Excel work book but on a new sheet (label each sheet).

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 on a third sheet, also labelled.

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 your DigiPrep folder on OneDrive.