Task 1

The ICT department needs to sort out the stationery order. Open the link to the spreadsheet above. Save it as Stationery 1 in YOUR area.

Write the following into the spreadsheet. Do NOT write in P, use £ like I have below:

ITEM PRICE

Pencils £0.10

Whiteboard pens £0.65

Card £0.04

Books £4.00

CD-ROMS £35.50

Dictionaries £3.00

Fountain pens £2.60

Cheap pencil sharpeners £0.08

Good pencil sharpeners £0.45

Pack of A4 paper £3.75

Task 2

After looking at all the prices, the ICT department decide to buy the following:

26 pencils, 4 whiteboard pens, 125 sheets of card, 72 books, 6 CD-ROMS, 32 dictionaries, 8 fountain pens, 95 cheap pencils sharpeners, 8 good pencil sharpeners, and 8 packs of A4 paper.

Write these amounts into the "amounts" column on the spreadsheet.

Now calculate the cost of each item in the "cost" column.

HINT: You will need to use a formula. This formula is multiply and you write this as * (asterix) in Excel.

For more handy hints have a look for the cells with the red corners, these give you secret tips......

Task 3

• Put a formula in E12 to work out the TOTAL COST of the order
• Use a function to calculate the average cost of the items and write it in cell E13
• Format the spreadsheet so that it can be given to the office looking nice. Change the colours of cells, writing, change the font, and put borders on it.
• Write your name somewhere on the spreadsheet and PRINT PREVIEW.
• If it fits onto one page, then print it out.

Task 4

Oops, forgot some of the stationery items! Add the following to your spreadsheet:

50 rulers at 50p each, a dozen rollerball pens at 20p each, 24 floppy disks 96p for a box of 12, 25 rubbers at 9p each and finally 29 marker pens at £1.25 each.

Re-calcluate the costs and averages.