Spreadsheet - Pass

Create a spreadsheet using the information below.

Saving your work

Make sure you have created the necessary folder!

Income

Each customer you have buys;

one chocolate making kit (butters and powders) = £7.77

one jar of agave = £2.23

the chocolution - SALES
Week	Number of customers	Income kits	Income agave
Week 1	01
Week 2	02
Week 3	03
Week 4	05
Week 5	06
Week 6	13
Week 7	21
Week 8	34
Week 9	55
Week 10	89
Week 11	144
Week 12	233

Expenditure

The raw ingredients for the kits cost you;

£4.80 per kit

£1.78 per jar of agave

calculate the amount you spend on raw materials below

EXPENDITURE
Date	Description	Amount
Month 01	Raw ingredients
Month 02	Raw ingredients
Month 03	Raw ingredients

Task

1. Format the cells to show currency where appropriate, text formatting, borders, shading.
2. Insert an appropriate column heading to calculate the total income each week ie add up the income from the kits and the agave.
3. Insert an appropriate row to show the profit you will make each week
4. In the Header/footer - describe the formatting you have done, the formula you have used.
5. Print out the spreadsheet in full, making sure you have changed the orientation to landscape and have selected the grid lines.
6. Add your name as a Header/footer, insert the date and page. These can be added through the toolbar.
7. Applying a password - please can you to password protect thid file.