Question

difference between relative and absolute cell references in spreadsheet in tabular form.

Answer 1

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 formulawill become =A2+B2.