Year 6 spreadsheets

Which function would you use to find the total of a column of numbers in a spreadsheet?

• AVERAGE

• SUM

• MAX

• MIN

If you want to add the numbers in cells A1, A2, and A3, which formula would you use?

I want to find out how much 4-packs of biscuits are. What formula do I use below?

• =sum(B6*D3)

• =sum(B5*D3)

• =sum(B6*D2)

• =sum(B3*D1)

What formula do I use to find out how much coffee, tea and bread equal?

• =sum(B1+B2+B5)

• =sum(B3+B2+B5)

• =sum(B2*B3+B5)

• =sum(B5+B2*B3)

What formula would I use to find my 10% discount from biscuits?

• =sum(B6/C2)

• =sum(B6+C2)

• =sum(B5*0.10)

• =sum(B6*C2)

What formula would give me the total of 5 teas?

• =sum(B2*D2)

• =sum(B2+D2)

• +sum(B3+D3)

• =sum(B3*D2)

I want to find what 5% off my milk would be. What function will I use?

• =sum(B4*C3)

• =sum(A4*C3)

• =sum(B4+C3)

• =sum(B3*C3)

What column has the data type 'integer'?

• A

• B

• C

• D

Type in the cell location of bread

Type in the content of cell D3