Question 12 (1 point) B D E 2 Find out the Sales for a specific day of a week mino co oo 4 Day Weather Sales Mon Good 100 6 Tue Bad 110 Wed Fair 120 Thu Poor 130 Fri Good 140 10 Sat Poor 150 11 Sun Good 160 12 13 Input 'Day Wed 14 Output - sales 15 16 You would like to find out 'sales' for a particular day. 17 You input the 'day' in Cell C13. 18 And write a formula in Cell C14 to get the Sales on that day. 19 20 The appropriate formula for cell C14 is: =VLOOKUP(C13,A5:C11,3,FALSE) No correct answer option is given =VLOOKUP(C14,A5:B11,2,FALSE) =VLOOKUP(C13,A5:C11,2,FALSE) =HLOOKUP(C13,A5:C11,3,FALSE) Question 13 (1 point) 700 B C E F 1 Roni started a business and expected to generate cashflows for next three years, as follows. 2 (All cash flows will be generated at the end of the year) 3 4 Year1 500 5 Year2 6 Year 3 800 7 8 He has to pay 300 each year from his cash flows to Mr. Jansim. 9 He can keep the remaining amount for himself. 10 His expected return is 796 11 12 Present value of remaining cash flow is: 13 14 The appropriate formula in cell C12 is: = (B4-$B$8)/(1+B10)+(B5-$B$8)/(1+B10)+(B6-$B$8)/(1+$B$10) No correct answer option is given =(B4-$B$8)/(1+B10)+(B5-$B$8)/(1+B10)^2+(B6-$B$8)/(1+$B$10)^3 =(B4)/(1+B10)+(B5)/(1+B10)^2+(B6)/(1+$B$10)^5-300 =(B4-500)/(1+B10)+(B5-500)/(1+B10)^2+(B6-500)/(1+$B$10)^4