Which of the following formulas would use an absolute row reference when filled? = B4B6 = B4/$B6 = $B4B6 = B$4*B6

Question

Carl

Computers & Technology

10 January, 12:21

Which of the following formulas would use an absolute row reference when filled? = B4B6 = B4/$B6 = $B4B6 = B$4*B6

+4

Answers (1)

Know the Answer?

Lillie Peterson · Answer 1

The Answer is = B$4*B6.

In excel spreadsheet, the letter stands for the location of cell in terms of column while the number represents the row. Locking the number by means of '$' will rock the row thus giving absolute value each time the cell is used as reference.

Which of the following formulas would use an absolute row reference when filled? = B4*B6 = B4/$B6 = $B4*B6 = B$4*B6

Which of the following formulas would use an absolute row reference when filled? = B4B6 = B4/$B6 = $B4B6 = B$4*B6