Ask Question
23 March, 09:11

Enter a formula in cell c4 that divides the value in cell b4 by the value in cell b12, using an absolute cell reference to cell b12.

+2
Answers (1)
  1. 23 March, 10:47
    0
    The formula is: "=B4/$B$12"

    Explanation:

    Follow the following steps:

    Step-1:

    Select the cell C4.

    Step-2:

    In the "fx" bar at the top, write the following formula:

    "=B4/$B$12"

    Make sure to add "equal" symbol before B4/$B$12; furthermore, the absolute reference of a cell can be used by using the "$" (dollar) symbol before the cell number. As, in this case, the cell B12 can be represented in terms of absolute reference as $B$12. As you can see that there is a "$" symbol before "12".
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Enter a formula in cell c4 that divides the value in cell b4 by the value in cell b12, using an absolute cell reference to cell b12. ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers