Question

describing how to use formulas
gemima now has the formula dialog box open.

food

milligrams per serving

----

----

orange, medium

70

strawberries, fresh, sliced, ½ cup

49

kiwi, medium

34

total vitamin c content

which formula should gemima use to show the amount of vitamin c in the fruit salad?○ sum(left)○ =sum(left)○ sum(above)○ =sum(above)

Explanation:

Step1: Identify target cells

The vitamin C values to sum are in the cells above the "TOTAL vitamin C content" cell: 70, 49, and 34.

Step2: Match correct formula

The formula needs to sum the cells directly above the total cell. The valid spreadsheet syntax for this is =SUM(ABOVE).

Answer:

=SUM(ABOVE)