Question

Cell address $B$5 in a formula means
(a) it is a mixed reference
(b) it is an absolute reference
(c) it is a relative reference
(d) None of the above

Answer 1

Answer:

it is b absolute reference as $ signis for absolutely things in excel

Answer 2

Option b is the correct answer for the above question

Explanation:

• The absolute address is the address which is not changed for the changing value of the column. This can be written with the help of putting the dollar sign with the name of the row and column address.
• The B is the name of the column and the 5 is the name of the row from the above-defined address. So when the dollar signed is fixed as mentioned on the question, it can be treated as an absolute address. So the option b is the correct answer for the above question while the other is not because:-

1. Option 'a' states about the mixed address in which dollar sign is not present.
2. Option c states about the relative address in which dollar sign is not present.
3. Option d states about the none option is correct but the option b is the correct answer.

Learn More:

• absolute address: https://brainly.in/question/11280153