In cell B$8,$ create a formula without using a function that multiplies the value in cell B$7$ by the value in cell $B6$ and then adds the value in $B7.$ In this formula, use a mixed reference for cell $B6$ by including 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.$

Switch to the Cost Estimates worksheet. In cell A$9,$ create a formula using the AVERAGE function that calculates the average of the values in the range $A5$:$A7,$ then