Ask 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 formula from cell B8 to the range B9:B11 and then copy the formulas

+3
Answers (1)
  1. 14 December, 00:56
    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 & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers