Which of the given cell reference can be included in relative reference?
A. $D6
B. A3
C. A$1
D. $1A
Answers
Answer:
By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2. A3 can be included in relative reference because others having doolar sign($)in them which is used in absolute reference only.
Explanation:
your answer is B part hope it will help you
Answer:
B. A3
Explanation:
B. A3
Because A3 contains the dollar symbol ($), which is exclusively used in absolute references, it can be included in a relative reference. All cell references are by default relative references. They modify based on the relation between rows and columns when replicated across many cells. For instance, the formula =A1+B1 will become =A2+B2 if you transfer it from row 1 to row 2.
Every cell in Excel has a relative reference by default. When you enter "=A1+A2" in cell A3 for relative references and then copy and paste that formula into cell B3, it automatically becomes "=B1+B2." When a formula is copied, the cell address remains the same for absolute references.
#SPJ2