Question

3. Differentiate between relative cell reference and Mixed reference with example.​

Answer 1

A mixed reference is a reference that refer to a specific row or column. For example, $A1 or A$1. If you want to create a mixed reference- press the F4key 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.