Reference no: EM132470000

Question 1: Create a series of Excel spreadsheets to demonstrate the skills you learned

You will need to demonstrate your ability to design a group of spreadsheets that:

• have a link between one spreadsheet and another
• demonstrates conditional formatting
• use at least three functions from Excel and one formula you create
• has at least one macro
• uses a template you created to produce new workbooks
• uses charts to help analyse data

1. You will need to provide printouts from the spreadsheets and a copy of a chart.