Question

Differentiate between relative referencing and mixed referencing with respect to a
presentation tool. ​

Answer 1

Answer:

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.

¤ Mixed cell references are a bit more tricky than the absolute and relative cell references. There can be two types of mixed cell references: The row is locked while the column changes when the formula is copied. The column is locked while the row changes when the formula is copied.

Answer 2

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.