Question

_____cell reference can be included in relative cell reference?

(i)A3 (ii)$A$4


(ii)A$1 (iv)$D6

Answer 1

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.

Answer 2

A3 cell reference can be included in a relative cell reference.

Option A is the correct answer.

• In spreadsheet-making software like excel,  by default, all cell references are relative references. When copied across cells, they update according to the relative position of rows and columns.
• For example, if we copy the formula =SUM(E5:E7) from E8 to H8 , the formula will become =SUM(H5:H7).
• Relative references are used when we need to repeat the same calculation across multiple rows or columns.
• in the contrary, absolute references do not change when copied or filled. We can use an absolute reference to keep a row and/or column the same.
• An absolute reference is used in a formula by adding a dollar sign ($) before the column and row.  
• for example, in [ =$C$2*C8]
• “$C$2” part of the formula denotes absolute reference. It will remain constant across the row when copied from one cell to another.
• The “C8” part of the formula denotes relative reference and it will change across the row while copying.
• (ii) $A$4  contains the dollar sign which is an absolute reference.

• (ii) A$1 contains the dollar sign which is an absolute reference.
• (iv) $D6 contains the dollar sign which is an absolute reference.

Therefore, A3 cell reference can be included in a relative cell reference. as it has no dollar sign. Option A is the correct answer.

#SPJ2