12 Product les 10 B 780 C460 1150 50 2000 350 120 SMALL(,4 10 Given the above screenshot, suppose -SMALL(C2:C6,4) is entered into cell C9. What output will result from this formula? 2000 780 50 #NUMI 13 Review Later Suppose -IFERROR(5000/2,1000) 100 is entered into a cell. What is the resulting output of this formula? #NUM! 1100 #VALUE! 2600 14 According to the information mentioned in the course, which of the following color schemes is best practice forfinancial modeling? Hard Codes in Blue, Formulas in Black Hard Codes in Black, Formulas in Blue Hard Codes in Black, Hard Codes in Red Hard Codes in Red, Formulas in Black 15 Which of the following formulas correctly anchors ONLY the row in cell A1? F1$1 SA$1 SA1 A1 17 What is the correct syntax for the-YEARFRAC function? -YEARFRAC(basis,start_date,end_date) -YEARFRAC(start_date,end_date.[basis]) YEARFRAC(start date) YEARFRAC(end date,start date) 18 The result of # ROUND(513.2413,2) is 19 B C 1 Time Periods 5142017 u Dats DATE YEAR SCS1)+G1,12,31) aiven the sovw scershnt 12/31/2021 12/31/2019 12/31/2020 9/30/2017 20 1 Assets 2 Cash 3 Accounts Receivable 5 Current Assets 6 Property& Equipment 7 Goodwill 8 Total Assets 67,971 5,100 7.805 80,876 45,500 20,000 146,376 10 Liabilities 1 Short Term Debt 12 Accounts Payable 13 Current Liabilities 14 Long Term Debt 5 Total Liabilities 6 Shareholder's Equity 7 Equity Capital 18 Retained Earnings 19 Shareholder'sE 20 Total Liabilities & Shareholders E 21 3,902 3,902 50,000 53,902 70,000 2,474 72,474 126,376 -IF 08-D20 OK) 23 24 Given the above screenshot, what is the resulting value in cell D22? TRUE OK FALSE ERROR