Mr Lowe's Lessons...
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
How to do it step by step
READ THE INSTRUCTIONS CAREFULLY
-
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