1.In cell B8, blank a formula without using a function that multiplies the value in cell B7 by the value in cell B6 and then adds the value in B7. (I used =B7*B6+B7)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 from the range B8:B11 to the range C8:H11.