4 Use the newly created range names to create a formula to calculate 6 Gross Profit (cell B12) and Net Profit (cell B13). 5 Create a new worksheet labeled Range Names, paste the newly 5 created range name information in cell A1, and resize the columns as needed for proper display. (On Mac, use the Insert menu to insert a new worksheet.) 6 Use Goal Seek to determine the optimal click rate in order to earn a 6 $5,000 net profit. 7 Starting in cell E4. Complete the series of substitution values ranging 5 from 2% to 6.5% at increments of .50% vertically down column E. 8 Enter references to the Gross Profit, and Net Profit in the correct 3 location for a one-variable data table. 9 Complete the one-variable data table, and then format the results with 6 Accounting Number Format with no decimal places. 10 Apply custom number formats to display Gross Profit in cell F3 and 4 Net Profit in cell G3. 11 Copy the response rate substitution values from the one-variable data 4 table, and then paste the values starting in cell 14