$3.$ Use AutoFill to fill the range A$9$:H$11$ with the formatting from the range A$7$:H$8.$

$4.$ In cell B$8,$ create a formula without using a function that multiplies the value in cell B$7$ by the value in cell B$6$ and then adds the value in B$7.$ In this formula, use a mixed reference for cell B$6$ by including an absolute reference to row $6.$ Copy the formula from cell B$8$ to the range B$9$:B$11$ and then copy the formulas from the range B$8$:B$11$ to the range C$8$:H$11.$

$5.$ 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 A$5$:A$7,$ then copy your formula to cell D$9.$