Question

How would you make a formula Links to an external site. = SUM (C2: C40) would get caught in the column, but would it change the line reference when dragging it?

Group of answer choices

= SUM (C2: C40)

= SUM ($ C $ 2: $ C $ 40)

= SUM ($ C2: $ C40)

= SUM (C $ 2: C $ 40)

Answer 1

Answer:= SUM (C2: C40)

= SUM ($ C $ 2: $ C $ 40)

= SUM ($ C2: $ C40)

= SUM (C $ 2: C $ 40)

Step-by-step explanation: