Question

what is the difference between relative, absolute and mixed references​

Answer 1

Answer:

Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. ... If it precedes the column or row (but not both), it's known as a mixed reference. You will use the relative (A2) and absolute ($A$2) formats in most formulas.

Explanation:

hope it's help

Answer 2

Answer:

An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. If it precedes the column or row (but not both), it's known as a mixed reference. You will use the relative (A2) and absolute ($A$2) formats in most formulas. Mixed references are used less frequently.