Question

cell address a4 in a formula means it is a

Answer 1

mixed cell reference is correct answer

Answer 2

Cell address a4 in a formula means it is a mixed reference.

1. A mixed reference is made up of both an absolute reference and relative reference. This means that part of the reference is fixed, either the row or the column, and the other part is relative.
2. When we make any column or row constant then the column name or row number does not change as we copy the formula to other cell(s).
3. The mixed reference is designated by a dollar sign($) in front of the row or column.
4. Mixed references can be used to set up formulas that can be copied across rows or columns without the need for manual editing.
5. It locks just one of the cells.

Hence, the cell address a4 in a formula means mixed reference.

Related Links

https://brainly.in/question/41297970

https://brainly.in/question/9045840

#SPJ6