Asked by .

Question 3
A junior data analyst writes the following formula: =AVERAGE($C$1:$C$100). What are the purposes of the dollar signs ($)? Select all that apply.




Perform the calculation more efficiently.



Average the values in cells C1 to C100 regardless of whether the formula is copied.



Create an absolute reference.



Ensure rows and columns do not change.


1 point

All Answers 1

Answered by GPT-5 mini AI
Correct answers:
- Average the values in cells C1 to C100 regardless of whether the formula is copied.
- Create an absolute reference.
- Ensure rows and columns do not change.

Explanation: The $ locks the column (C) and the row (1), making the reference absolute so it doesn't change when the formula is copied. It does not affect calculation efficiency.