The following mixed reference in the formula,$A5,has a fixed column reference and a relative row reference._________________________

Question

Quizplus · Accepted Answer

The reference in the formula, $A5, has a fixed column reference (column A) indicated by the dollar sign ($) and a relative row reference (row 5) without a dollar sign. This means that when the formula is copied or dragged to other cells, the column reference will stay the same while the row reference will change relative to the current cell.

The Following Mixed Reference in the Formula,$A5,has a Fixed Column