Create a new worksheet labeled Range Names, paste the

$4$

newly created range name information in cell $A1,$ and resize the columns as needed for proper display. Ensure that the data is sorted by range name, column $A.$

Follon

$5($point On the Forecast sheet, start in cell E$3.$ Complete the series of

$3$

substitution values ranging from $10$ to $200$ at increments of $10$ gallons vertically down column $E.$

Enter references to the Total$\_$Produc$$ion$\_$Cost, Gross$\_$Profit, and Net Profit cells in the correct locations $($F$2,$ G$2,$ and H$2$ respectively$)$ for a one$-$variable data table. Use range names where indicated.

$8$

Complete the one$-$variable data table in the range E$2$:H$22$ using cell B$4$ as the column input cell, and then format the results with Accounting Number Format with two decimal places.

$9$

Apply custom number formats to make the formula references

$3$

appear as descriptive column headings. In F$2,$ Total Costs; in G$2,$ Gross Profit, in H$2,$ Net Profit. Bold and center the headings and substitution values.