Question Question: A company is looking into four potential projects and will accept them if the Internal Rate of Return (IRR) is 12% or higher (as shown in the cell E2). Which one of the following formulas can be used in the cell C2 to get the results in column C. Note that the fill handle on C2 was used to populate C3 to C5. A B C D E IRR Accept or Reject Decision rule 2 Project 1 13.50% Accept 12% 3 Project 2 10.12% Reject 4 Project 3 9.50% Reject 5 Project 4 12.20% Accept O =IF(B2>=E2,"Accept","Reject") O =IF(B2>E2,"Accept","Reject") O =IF(B2>$E$2,"Accept","Reject") O =IF(B2>=$E$2,"Accept","Reject")Question: The revenue of five companies in year 2018 is shown in the spreadsheet below' We want to invest in the companies with the annual revenue of $200, 000 or more, which one the following formulas can be used in cell D2 to return "Yes" it the revenue is $200, 000 or more and "NO" if the revenue is less than $200, 000 '2 The results are shown in column D. Note that the fill handle on D2 was used to populate D2 to D6. rs v a > V/ I: A A B c D 1 Companies Threshold Annual Revenue Invest? A Company 1 200,000 160,000 No 3_ Company 2 170,000 No L Company 3 200,500 Yes i Company 4 220,000 Yes i Company 5 210,000 Yes L o =|F(CbB2,"Yes","No") O =|F(C2>$B$2,"Yes","No") o =|F(Cb=BZ,"Yes",\"No") =|F(C2>=$B$2,"Yes","No") Question: Which one of the following error messages has the wrong definition? 0 #NULL: The formula refers to a cell range that Excel cannot understand. #VALUE: The formula includes a function that was used incorrectly, takes an invalid argument, or is misspelled. 0 #N/A: You used a cell range name in the formula, but the name is not defined. #DlV/O: You tried to divide a number by zero. O Question Question: A teacher stored the student marks on a spreadsheet. He wants to know how much Sara scored in Math. Which formula is used in the cell H2 to generate that result? A B C D E F G H |V O UI A W N - Subject Name Math Physics Chemistry Biology Sara's Math score: 91 Math 42 56 72 69 Sara 91 87 64 51 Tom 57 55 83 37 Jeniffer 62 88 80 95 Maria 75 61 90 91 Sam 81 93 49 56 O =VLOOKUP("Sara",A3:E8, 1,0) O =VLOOKUP("Sara",A3:E8, 1, 1) O =VLOOKUP("Sara",A3:E8,3, 1) O =VLOOKUP("Sara",A3:E8,2,0)Question: Which of the following formulas can be used to generate the following results in cell A1? 2019-10-28 11:59 0 =HOUR() O =NOW() o =WEEKDAY() o =DATE()