Which of the following formulas displays E5 as an absolute cell reference?
A) =A2*E5*
B) =A2*$.E5
C) =A2*$E*5
D) =A2*$E$5

Name: Which of the following formulas displays E5 as an absolute cell reference? A) =A2*E5* B) =A2*$.E5 C) =A2*$E*5 D) =A2*$E$5
Brand: Quizplus
Rating: 4.9 (36 reviews)

Question

Quizplus · Accepted Answer

The $ symbol is used to make a cell reference absolute. "$E$5" indicates that both the column letter "E" and the row number "5" are absolute, meaning they will not change if the formula is copied to another cell.

Which of the Following Formulas Displays E5 as an Absolute