The worksheet tab named Problem 1 and 2 from Supplement_Spreadsheet contains a model which takes as inputs the following variables: List_Price Market_Share Market_Size Percent_Discount As discussed in class, you can do this by putting the names you want to use in one column, for instance, you could write List_Price in cell A3, and then select the cell with the name you entered and the cell to its right (so select cells A3:B3), then select Formulas, Create from selection, Create names from the values in the left column. Then write Market_Share in cell A4, select cells A4:B4 and again select formulas and create names from values in the left column, etc. With input values entered as follows List_Price = 40 (so, enter 40 in cell B3 which is the cell named List_Price) etc Market_Share = 30% Market_Size 200 Percent_Discount 10% The model calculates the following: Net_Price = List_Price*(1-Percent_Discount) Sales_Volume = Market_Share*Market_Size Revenue_Without_Discount = List_Price*Sales_Volume Revenue_With_Discount = Net_Price*Sales_Volume Net_Cost_of_Discount = Revenue_Without_Discount - Revenue_With_Discount YOUR TASK: 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? a) Leave it blank b) =Net_Cost_of_Discount c) =Profit d) =Sales_Volume*List_Price-Net_Price e) None of the above QUESTION 2: What value appears in cell F18? Hint: It is an integer (Enter the value, for instance, if your answer is that 1357 appears in cell F18 enter 1357 in the answer box with no spaces, no decimal point). The worksheet tab named Problem 3 and 4 from Supplement_Spreadsheet has the prime numbers from 2 up to 23 entered in order in cells A7, B7, C7, A8, B8 and C8. Cell C12 contains the formula =A7*B7*A8*C8, and displays the value 546 (which is equal to 2*3*7*13). YOUR TASK: Modify the formula in C12 by doing nothing but adding dollar signs ($). Do not change the order of the cell in the formula. Create a formula in C12 that does not change the value that appears on cell C12, and that you can copy and paste to the cell D13 so that this cell shows the value 6279. Hint 6729 = 3*7*13*23, or B7*A8*C8*C9 QUESTION 3: Which of the following formulas uses an absolute row reference and a relative column reference? a) A10 b) A$10 c) $A10 d) $A$10 e) None of the above QUESTION 4: What formula did you enter in cell C12? (Enter your answer with no spaces, with capital letters, and with the = equal sign, for instance, if your formula in C12 was =$A$7*$B$7*$A$8*$C$8 then enter exactly =$A$7*$B$7*$A$8*$C$8 in the answer box. Double check your answer, because typos will make it wrong

please, answer number 4: what forumla did you enter in cell A12

The worksheet tab named "Problem 3 and 4" from Supplement_Spreadsheet has the prime numbers from 2 up to 23 entered in order in cells A7, B7, C7, A8, B8 and C8. Cell A12 contains the formula "=A7*87*A8*C8", and displays the value 546 (which is equal to 2*3*7*13). YOUR TASK: Modify the formula in A12 by doing nothing but adding dollar signs ($). Do not change the order of the cell in the formula. Create a formula in A12 that does not change the value that appears on cell A12, and that you can copy and paste to the cell B13 so that this cell shows the value 6279. Hint 6729 = 3*7*13*23, or B7*A8*C8*C9 QUESTION 3: Which of the following formulas uses an absolute row reference and a relative column reference? a) A10 b) A$10 c) $A10 d) $A$10 e) None of the above QUESTION 4: What formula did you enter in cell A12? (Enter your answer with no spaces, with capital letters, and with the = equal sign, for instance, if your formula in A12 was =$A$7*$B$7*$A$8*$C$8 then enter exactly =$A$7'$B$7*$A$8*$C$8 in the answer box. Double check your answer, because typos will make it wrong