EX 6XLCH 6GRADERCAPHw-,-Delta_PaantJAJnstructions . Protected View , Saved to this PC yout References Melings Renew View Help 81el me wh hat you want to do the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing 2 Creace appropriate range names for Total Production Cost (cel 818) and Gross Profit (ell 3,000 821) by selection, using the values in the left column Edr the exsting name range Employee Hourly Wage to Hourly Wages2018 oniginal one. 3 Note, Mac users, in the Dofine Name dialog box, add the new named range, and delete the .000 4 Use the newly created range names to create a formuila to calculato Not Profit (in call 822) Create a new worksheet labeled Range Names, paste the newly created range name nformation in cel Al, and resize the columns as needed for proper display. 5.000 On the Forecast sheet, start in cell E3. Complete the series of substitution values ranging from 10 to 200 at increments of 10 gallons vertically down column E 2.000 Enter references to the Total Production Cost, Gross Prolit, and Net Profit cells in the correct locations (F2, G2, and H2 respectivoly) for a one-variable data table. Use range names3.000 where indcabed. Complete the one-variable data table in the range E2:122 using cell 84 as the column input cell, and then format the resuts with Accounting Number Format with bwo decimal places 5.000 Apply custom number formats to make the formula references appear as descriptive column 9 headings. In F2, Total Costs; in G2, Gross Profit, in H2, Net Profit. Boild and center the .000 headings and substitution values Copy the number of gallons produced subetitution values from the one variable data table and then paste the values starting in coll E26 4.000 8 9