In cells D10:I20 (the green area), create a data table which will calculate the Net_Cost_of_Discount for input values for market size of 100, 150, 200, 250, and 300, and input values of Percent Discount of 0%, 5%, 10%, 15%, 20%, 25%, 30%, 35%, 40%, and 45%.

QUESTION 1: What formula should you put in cell D10?

1. a) Leave it blank

2. b) =Net_Cost_of_Discount

3. c) =Profit

4. d) =Sales_Volume*List_Price-Net_Price

5. e) None of the above

AutoSave OFF Esve Supplement Spreadsheet Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) X LO . Ai = = v 11 EVAS ab Wrap Text General L. LIX Ou 3 v Paste a. Av E + $ % ) .00 00 0 Insert Delete Merge & Center v Format Ideas Conditional Format Formatting as Table Cell Styles v Sort & Filter Find & Select A B D E F H 1 K L M N o P Q R s T V w X 40 List_Price Market_Share Market_Size Percent_Discount 30% 200 10% Net_Price Sales_Volume Revenue_without_Discount Revenue_With_Discount Net_Cost_of_Discount 36 60 2400 2160 240 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 A Problem 1 and 2 Problem 3 and 4 Problem 5 and 6 + Ready @ + 100%