In the formula =A8*$A$1,which of the following describes A8?
A) Relative cell reference
B) Absolute cell reference
C) Function
D) AutoSum

Name: In the formula =A8*$A$1,which of the following describes A8? A) Relative cell reference B) Absolute cell reference C) Function D) AutoSum
Brand: Quizplus
Rating: 4.9 (40 reviews)

Question

Quizplus · Accepted Answer

A8 is a relative cell reference as it will change based on where the formula is copied or dragged. $A$1 is the absolute cell reference as it will always refer to cell A1 no matter where the formula is copied or dragged.

In the Formula =A8*$A$1,which of the Following Describes A8