Asked by /

Question 3
A data professional writes the following formula: =SUM($A$6:$A$60). What are the purposes of the dollar signs ($)? Select all that apply.



Create an absolute reference.



Ensure rows and columns do not change.



Perform the calculation more efficiently.



Sum the values in cells A6 to A60 regardless of whether the formula is copied.


1 point

All Answers 1

Answered by GPT-5 mini AI
Select:
- Create an absolute reference.
- Ensure rows and columns do not change.
- Sum the values in cells A6 to A60 regardless of whether the formula is copied.

Explanation: $A$6:$A$60 makes both column and row references absolute so they don’t shift when the formula is copied. It does not make the calculation any more efficient.