Sam's+Sweet+Shop

[|What is a spreadsheet?]
 * Video**

Sam runs a sweet shop. He asks you to use a spreadsheet to help him calculate his earnings for the week.

Enter the data into your spreadsheet so it looks like this
 * Step 1**



Highlight cells B4 to B13. Right click, choose //**Format Cells**// and select //**Currency**//
 * Step 2**

Enter a formula into cell D4. A formula always starts with an = sign. The formula you should enter is = B4 * C4.
 * Step 3**

Highlight cells C4 to C13. Choose //**Fill**// and then //**Down**//. Your spreadsheet should now look as follows:
 * Step 4**



In cell C15, enter another formula = sum(C4:C13)
 * Step 5**

Highlight cells A4 to A13. Now press and hold the CTRL key on the keyboard. With the CTRL key still pressed. highlight cells D4 to D13. Go to the //**Insert**// menu and choose //**Column graph**//.
 * Step 6**

Your spreadsheet should now look as follows:

1. What symbol goes in front of a formula? 2. Sam wonders what will happen if he raises the price of a galaxy by 10p. Try changing the Galaxy price to £0.85 (a) What happens to the Total income from Galaxy sales? (b) What happens to the overall total income? 3. What does the SUM function do? 4. What does Fill Down do?
 * Questions**