Question

1. in the function =sum(g1:g35), identify the range.

○ g35
○ g1:g35
○ =sum(g1)
○ =sum

Explanation:

Step1: Recall SUM function syntax

In Excel, =SUM(range) sums values in the specified range. The range is given as a cell range (start:end).

Step2: Analyze the function =SUM(G1:G35)

The SUM function here has the range G1:G35, which is the set of cells from G1 to G35. The "range" in the SUM function's argument is this cell range. Now, check the options:

• Option "G35": Just a single cell, not a range.
• Option "G1:G35": This is the cell range (start G1 to end G35) which is the range argument for SUM.
• Option "=SUM(G1)": Incorrect syntax (SUM of a single cell with wrong format, and not a range).
• Option "=SUM": Just the function name, not the range.

Answer:

G1:G35