Which of the terms below would be most closely associated with the following formula:
=$J1+44
A) mixed reference
B) absolute reference
C) named range
D) relative reference

Question

Quizplus · Accepted Answer

The formula =$J1+44 uses a mixed reference, where the column is absolute (indicated by the $ sign before J) and the row is relative (indicated by the lack of a $ sign before the 1), allowing the row number to change when the formula is copied to other rows.

Which of the Terms Below Would Be Most Closely Associated