Spreadsheets task 2a+b

What are C3, D5, E9 an examples of?

• Cell references

• Formulas

• Functions

• Charts

What are the symbols on a keyboard for addition, subtraction, division and multiplication?

• Addition: +, Subtraction: -, Division: /, Multiplication: *

• Addition: -, Subtraction: +, Division: *, Multiplication: /

• Addition: *, Subtraction: /, Division: +, Multiplication: -

• Addition: /, Subtraction: *, Division: -, Multiplication: +

What are the symbols on the keyboard for ‘greater than’ and ‘less than’?

• Greater than: >, Less than: <

• Greater than: <, Less than: >

• Greater than: =, Less than: -

• Greater than: %, Less than: $

What FUNCTION do you use to total up a range of cells?

• SUM

• AVERAGE

• MIN

• COUNTIF

What FUNCTION do you use to work out the average of a range of cells?

• AVERAGE

• SUM

• COUNT

• MAX

Can you name any other functions?

• Examples: MIN, MAX, COUNT, IF

• Examples: CAT, DOG, BIRD, FISH

• Examples: ADD, SUBTRACT, MULTIPLY, DIVIDE

• Examples: RED, BLUE, GREEN, YELLOW

What are C3, D5, E9 an examples of?

• A cell reference

• A formula

• A worksheet

• A chart

What are the symbols on a keyboard for addition, subtraction, division and multiplication?

• +,-,/,*

• =,_,\,|

• @,#,$,%

• !,?,&,^

What are the symbols on the keyboard for ‘greater than’ and ‘less than’?

• Greater than is > and less than is <. To do greater than/less than or equal to you use >= or <=

• Greater than is < and less than is >. To do greater than/less than or equal to you use <= or >=

• Greater than is = and less than is ≠. To do greater than/less than or equal to you use == or !=

What FUNCTION do you use to total up a range of cells?

• =SUM()

• =AVERAGE()

• =COUNT()

• =MIN()