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

Question

Computers & Technology

Kamryn

11 October, 18:45

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

+1

Answers (1)

Know the Answer?

Kasey Thompson · 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