Question

There are two types of cell reference, absolute and relative. SELECT THE RELATIVE CELL REFERENCE.

Answer 1

$A$7 : there are two types of cell reference absolute and relative

Answer 2

Relative cell references are basic references to cells that are used for editing and modification when copying or using Automatic Fill.

Example: = SUM (B5: B8) will be changed to = SUM (C5: C8) when copied to the next cell. A relative cell reference determines how far a cell or group of cells is from another cell in the same spreadsheet, and in order to connect both we use functions. The functions used are listed above. By default, each cell in Excel has a related reference.