Question

Distinguished between relative and mixed
refrence? ​

Answer 1

Explanation:

If you want to merge the first name with the last name and place them in column D, you don't have to enter them manually, but you can merge them by using the relative references, instead. ... A mixed reference is a reference that refer to a specific row or column. For example, $A1 or A$1.

Answer 2

If you want to merge the first name with the last name and place them in column D, you don't have to enter them manually, but you can merge them by using the relative references, instead. ... A mixed reference is a reference that refer to a specific row or column. For example, $A1 or A$1.