Create a new worksheet and create newly created range name information in cell A1, and resize the columns as needed for proper display.

B 5 Copy of Calderon_Exp19_Excel_Ch06_Cap_ File Home Insert Page Layout Formulas Data Review View Help Acrobat Tell e Define Name Use in Formula Insert AutoSum Recently Financial Logical Test Date & Lookup & Math & More Function Used - Time - Reference Tig Functions - ager Create from S Function Library Defined Names fr C14 1 H D E A 1 Direct Marketing 2 3 Inputs 4 Number of Ads 10000 5 Click Rate 5.00% 6 7 Parameters 8 Design Fee $ 2,000.00 9 Cost Per Ad $ 2.25 10 Total Clicks 500 11 Profit Per Click S 12.50 12 Gross Profit 13 Net Profit 14 15 16 17 18 19 20 21 22 Direct Marketing Range Names Direct Marketing 2 Ready Type here to search RI Il Calderon_Exp19_