excel

In cell F14 determine the weighted response value by entering a formula that multiplies the value in cell F5 by the value in F4. Use a relative reference to the cell F5 and an absolute reference to the cell F4 in the formula. Use autofill to fill the range F15:F18 with the formula you created in cell F14.