Question

What is the cell reference if cell in column A & ROW 5?

Answer 1

Explanation:

In working with spreadsheets, you need to know about relative vs. absolute cell references.

In working with spreadsheets, you need to know about relative vs. absolute cell references.Here is the issue: when you COPY A FORMULA that contains cell references, what happens to the cell references?

In working with spreadsheets, you need to know about relative vs. absolute cell references.Here is the issue: when you COPY A FORMULA that contains cell references, what happens to the cell references?Usually the CELL REFERENCES will CHANGE! If you copy a formula 2 rows to the right, then the cell references in the formula will shift 2 cells to the right. If you copy a formula 3 rows down and 1 row left, then the cell references in the formula will shift 3 rows down and 1 row left. These are called "relative" cell references, since they change relative to where you copy the formula.