Testing knowledge for basic excel formulas
Click the button below to start.
Question 1 of 2
Which Excel formula would calculate the total tonnes moved in cells B2 to B10?
=AVERAGE(B2:B10)
=COUNT(B2:B10)
=SUM(B2:B10)
=MAX(B2:B10)
Question 2 of 2
A Mining Operations Supervisor wants to know the average tonnes per truck load. Which formula should they use?
=MAX(C2:C20)
=AVERAGE(C2:C20)
=COUNT(C2:C20)
=MIN(C2:C20)