Question

Which of the following is a mixed referencing
1) $D$4
2) R5
3) G$7
4) S$12$

Answer 1

Answer:

A mixed reference is a reference that refers to a specific row or column. 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. Press F4 one more time to go back to the relative cell reference.