This spreadsheet is protected, only in the red boxes formulae can be entered
How to work out a fomula or calculation Spreadsheet Operators
1) Click on the cell you want to hold the answer in
2) Enter the = sign Add +
3) Enter the cell reference of your first number Subtract -
4) Enter the operator i.e. add, subtract etc Multiply *
5) Enter the cell reference of your second number Divide /
6) Click on 'Enter' on keyboard
TASK 1
Work out the following as a formula, use Number 1 then Number 2
Number 1 Do What ? Number 2 Formula Answer
5 Add 5
23 Add 22
100 Subtract 50
50 Subtract 40
2 Multiply 5
10 Mulitply 20
20 Divide 10
100 Divide 2
TASK 2
Work out the following by putting in the numbers into the cells
then put the formula which will calculate it in the Answer box provided
You need to enter a formula similar to task 1
but this time, use three cells for your numbers 1, 2 and 3
put your formula in the yellow Answer box
Number 1 Number 2 Number 3
1) Add 5 and 3 and 2
2) Add 10, 20 , 30
3) Subtract 3 and 4 from 20
4) Subtract 30 and 50 from 100
5) Multipy 2 by 2 then by 2
6) Multiply 10 by 2 then by 5
7) Divide 100 by 2 then again by 2
8) Divide 100 by 4 then again by 5
Your Mark for TASK 1 is 0 out of 8
Your Mark for TASK 2 is 0 out of 8
Your total is 0 out of 16
Your grade is F
Grade Boundaries:
Mark Grade
0 F
2 E
5 D
8 C
11 B
14 A
16 A*
be entered
heet Operators
plus
minus
star
forward slash
Correct? 0 /8
Formula
Correct? 0 /8
Answer
TASK 1 Enter formulae in cells that have a red triangle only the rest of the spreadsheet is protected
Sean and Jane are doing a car boot sale and have priced up the following items.
Sean Jane
Toy car £4.00 Doll house £5.50
Computer game £7.50 Racing bike £12.00
Train set £11.00 Monopoly game £3.50
BMX bike £15.00 Old coat £6.00
Old football boots £8.00 Video £2.00
Total Total
Who will get the most money if they sell everything?
TASK 2
They also have some CDs and DVDs to sell.
Cost Each Number Total
CDs £4.00 23
DVDs £4.50 18
Total
AUTOSUM TASK
Find the total of this list of numbers
50
650
456
324
200
300
234
567
Total =
You have scored: 0 out of 7
Mark Comment
0
2 (E) You need to try again!
3 (D) You did OK!
5 (C) That's good, well done!
6 (B) Excellent, well done!
7 (A) Wow, a Perfect score!
HOLIDAY
WEATHER
Hotel Sol Hotel Grande Hotel Bueno
Athens Paris Barcelona
Greece France Spain
MONTH
January 10 8 11
February 13 8 13
March 14 12 15
April 15 15 15
May 15 15 15
June 29 20 22
July 29 15 25
August 25 22 24
September 20 18 18
October 18 13 16
November 12 8 10
December 10 7 9
Greece France Spain
Minimum Temp
Maximum Temp
Average Temp
TASK 1 - Enter a function for each of the cells inside the red rectangle
TASK 2 - Create a column chart to compare the weather for the three countries.
