Plough Farm - Shop Spreadsheet

 Plough farm have a shop on the site and they use a spreadsheet to help keep a track of what they sell.

Your task is to set up that Spreadsheet
 

• On a new spreadsheet label Cell A1 Item, Cell B1 Price, Cell C1 Number sold and Cell D1 Income
• Format the Cells in column B to show as currency (that is show the pound sign)
• Type in the items for columns A, B and C as given in the picture below

• In cell D2 put in a formula to multiply the cells B2 and C2.
• Fill in the formulae for the rest of column D
• At the bottom of column D put in a formula to add up the total income.
• To make the spreadsheet easy to read make the rows alternate in colour (eg. Put all the even rows light grey)
• Rename sheet 1 so that it says Shop income (to do this click the right hand button on the sheet 1 tab and choose the rename option

You should now have created a spreadsheet that the shop can use to work out how much they make from the sale of all their items.

Well Done.

BACK TO MAIN PAGE