Ask Question
29 March, 06:47

Update the cell reference to cell B6, from a relative reference to a mixed reference by making an absolute reference to row 6. Copy the formula from cell B8 to the range B9:B11 and then copy the formulas

+2
Answers (1)
  1. 29 March, 10:24
    0
    Answer: I'm your formula, after inserting B6 press F4

    Explanation: in order to absolute reference the cell B6 in the formula for cells B8-B11, the cell B6 must have the dollar sign as such $B$6 this is to ensure that when copying the formula across B9-B11, it does not change to B7-B9 respectively
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Update the cell reference to cell B6, from a relative reference to a mixed reference by making an absolute reference to row 6. Copy the ...” 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