Lesson Aim
Practice creating formulas, formatting and creating a graphs in MS Excel.
Your task is to download the spreadsheet below:
Now you need to do the following:
- Create formulas to calculate Profit Margin
- Create formulas to calculate Total Profit
- Format your spreadsheet (nb. remember to format money as currency)
- Sort your spreadsheet on course into alphabetical order
- Create Graph for profit margin for each product
- PDF print it in normal view (nb. you need to add a footer with your details)
- PDF print it in formula view