Spreadsheet Formula Quiz

You have a spreadsheet that tracks the total sales of milk across all months in cells B2:B13. Which formula should you use to find the total?

• =B2+B13

• =SUM(B2:B13)

• =COUNT(B2:B13)

• =B2+B3+B4+B5+B6+B7+B8+B9+B10+B11+B12+B13

A business owner wants to find the difference between total income in cell B2 and total expenses in cell B3 . Which formula should they use?

• =B2-B3

• =SUM(B2-B3)

• =B3-B2

• =SUBTRACT(B2,B3)

A school is tracking the number of textbooks purchased per month, listed in cells B2:B7. What formula should be used to get the total number of textbooks?

• =SUM(B2,B3,B4,B5,B6,B7)

• =TOTAL(B2:B7)

• =C2+C7

• =SUM(B2:B7)

A bakery is checking how much more flour they used this month (cell B3) compared to last month (cell B2). What formula should they use?

• =SUM(B2,B3)

• =B2-B3

• =B3-B2

• =DIFFERENCE(B4,B2)

A supermarket wants to find the total of weekly fruit sales in cells B2 to B9. Which of these is the best formula to use?

• =B2+B9

• =SUM(B2:B9)

• =ADD(B2:B9)

• =TOTAL(B9:B2)

You have a spreadsheet that lists the salaries of employees in cells B2:B6 . Which formula should you use to find the total salary expenditure?

• =COUNT(B2:B6)

• =AVERAGE(B2:B6)

• =SUM(B2:B6)

• =B2+B3+B4+B5+B6