Year 8 Homework 3 - HT2

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)

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

• =MAX(A1:B5)
• =MAX(A3:B5)
• Option 3
• =MAX(A1:B10)

Q9. What are formulas in a spreadsheet?

• Formulas are simple calculations. They always start with an equal sign (==).
• Formulas are simple calculations. They always start with an equal sign (=).
• Formulas are simple calculations. They always start with an equal sign (===).
• Formulas are simple calculations. They always start with an addition sign (+).

Q10. What are functions in a spreadsheet?

• Functions make complex calculations. Common ones: GRAND, HIGH, AVERAGE.
• Functions make complex calculations. Common ones: TOTAL, HIGH, LOW, AVERAGE.
• Functions make complex calculations. Common ones: SOME, MA, MINE, AVERY.
• Functions make complex calculations. Common ones: SUM, MAX, MIN, AVERAGE.