Task 1 - Spreadsheet Design.

Produce a design.

You must create design to show how you will create your spreadsheet. The spreadsheet will show all of the tables that you will include in your spreadsheet. Here are some tips.

1. Create a sheet that shows all of the Stock Data for Years 1, 2, 3 and 4.

2. Create a sheet that shows the invoice that you will create.

3. Create a sheet that shows the menu screen for all of your macros.

 

Click Here to see an example of another pupil's design.