The range of the function is D. G1:G35
From the information given, we have that the function is ;
=SUM(G1:G35),
This range, G1:G35, represents all the cells within the column G, from cell G1 to cell G35 inclusively. The SUM function in Excel calculates the total sum of all the numbers within this specified range.
Therefore, when using =SUM(G1:G35), it will add up the values contained in cells G1 through G35 to provide a single sum total.