Question

describe different types of cell references.​

Answer 1

Answer:

Here's your answer

Explanation:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

Answer 2

Answer:

The 3 types of references are:

Relative reference, Absolute reference, and Mixed reference.

1. Relative Reference: A relative cell reference refers to cells in relation to the cell that contains the formula. When the formula is moved, it references new cells based on their location relative to the formula. Relative cell reference is the default type of Excel cell reference.   A relative cell reference does not use any dollar sign before the column address or the row address.  When a formula is copied or dragged to another cell or range, relative cell reference changes accordingly. For example, A1.
2. Absolute Reference: An absolute cell reference always refers to a specific cell or range of cells, regardless of where the formula is located in the worksheet, even when the formula is copied to any other cell in the worksheet.  The row and column references do not change after copying the formula because the reference is to an actual cell address. An absolute reference uses two dollar signs in its address: one for the column letter and one for the row number.
3. Mixed Reference: A mixed cell reference is an Excel cell reference that uses an absolute column or row reference, but not both. Only one of the address parts is absolute. A mixed cell reference uses a dollar sign either before the column address or before the row address. It is a combination of relative and absolute references (mixed reference type in excel).

I was not able to write dollarsign examples in the answer as Brainly isn't allowing me for some reasons...Sorry for that

Please mark my answer as the brainliest...