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.

$1$ point

Average the values in cells C$1$ to C$100$ regardless of whether the formula is copied.

Create an absolute reference.

Perform the calculation more efficiently.

Ensure rows and columns do not change.