Year 8 Homework 3 - HT2

First name

Surname

Form

• 8R
• 8B
• 8G
• 8O
• 8P

Q1. Look at the spreadsheet below and select the correct formulae or functions. What is the formula to add up A1 and B1?

• =A2+B2
• =A1+B1
• =A3+B3
• =A8+B8

Q2. Look at the spreadsheet below and select the correct formulae or functions. What is the formula to work out A2 take away B2?

• =A5-B5
• =A4-B4
• =A3-B3
• =A2-B2

Q3. Look at the spreadsheet below and select the correct formulae or functions. What is the formula to multiply A3 by B3?

• =A3*B3
• =A3*B10
• =A13*B3
• =A4*B4

Q4. Look at the spreadsheet below and select the correct formulae or functions. What is the formula to divide A4 by B4?

• =A10/B10
• =A1/B1
• =A4/B4
• =A5/B5

Q5. Look at the spreadsheet below and select the correct formulae or functions. What is the function to add up A1 to B5?

• =SUM(A1:B9)
• =SUM(A2:B5)
• =SUM(A1:B6)
• =SUM(A1:B5)

Q6. Look at the spreadsheet below and select the correct formulae or functions. What is the function to find out the average of A1 to B5?

• =AVERAGE(A1:B5)
• =AVERAGE(A1:B11)
• =AVERAGE(A2:B5)
• =AVERAGE(A1:B9)

Q7. Look at the spreadsheet below and select the correct formulae or functions. What is the function to find out the lowest number in cells A1 to B5?

• =MIN(A2:B15)
• =MIN(A1:B9)
• =MIN(A1:B5)
• =MIN(A7:B7)