which of the following formulas would use an absolute row reference when filled?\n=b4*b6\n=b4/$b6\n=$b4*b6\n=…
which of the following formulas would use an absolute row reference when filled?\n=b4*b6\n=b4/$b6\n=$b4*b6\n=b$4*b6
Answer
Answer:
D. =B$4*B6
Brief Explanation:
In Excel, a dollar - sign before the row number ($4) in a cell reference creates an absolute row reference. In option D, B$4 has an absolute row reference. When the formula is filled or copied, the row number 4 will not change while the column letter may change if the formula is copied horizontally.