8
AssignmentMultiple Choice

Using Tables and Charts

Question 8 • LHS Business Management

Which formula should Gemima use to show the amount of vitamin C in the fruit salad?

Answer
A
SUM(LEFT)
B
=SUM(LEFT)
C
SUM(ABOVE)
D
=SUM(ABOVE)

Explanation

To total the vitamin C amounts listed in the cells above the fruit salad total, Gemima should use the SUM(ABOVE) formula. Spreadsheet-style formulas begin with an equals sign, so the correct formula is =SUM(ABOVE), choice D.

AI-written and checked against the verified answer.

Previous
Next