definition of mixed reference
Answers
Answered by
10
- A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row
- For example, $A1 or A$1. If you want to create a mixed reference- press the F4 key on the formula bar two or three times depending on whether you want to refer to row or column
Answered by
2
Answer:
A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row.
For example, $A1 or A$1. If you want to create a mixed reference- press the F4 key on the formula bar two or three times depending on whether you want to refer to row or column.
hope it helps,
have a fabulous day and pls mark as brainiest...
Similar questions
Social Sciences,
4 months ago
English,
4 months ago
Math,
9 months ago
English,
9 months ago
Physics,
1 year ago