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

Question

Computers and Technology

Kelvin Miles

17 September, 06:38

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

+5

Answers (1)

Know the Answer?

Jairo Sweeney · 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