According to the information mentioned in the course, which of the following color schemes is best practice for financial modeling? Hard Codes in Blue, Formulas in Black Hard Codes in Red, Formulas in Black Hard Codes in Black, Hard Codes in Red Hard Codes in Black, Formulas in Blue Page 9 of 15 Nex Prev Page 11 97 DOD FS - GOD 74 80 F3 F2 $ 4 & * 7 V 8 9 9 0 % 5 # 3 1 06 CEP 1 2 yo U T LY T Question Set What is the result of inputting =IF(5>9,0k, error) into a cell? 11 error ok Page 11 of 15 #NAME? Prev Page * & 000 COD FA DF3 $ % E 5 0 6 17 V8 Y CAN 0 F1 # T estion Set What is the correct syntax for the =YEARFRAC function? 12 =YEARFRAC(end_date,start_date) Page 12 of 15 =YEARFRAC(start_date,end_date, (basis]) =YEARFRAC(start_date) =YEARFRAC(basis,start_date, end_date) Prev Page * F Y V 4 14 D E G H 5/14/2017 0 2 1 Time Periods 2. Annual Data =DATE(YEAR SCS1)+G1,12,31) Given the above screenshot, which of the following is the resulting value in cell G2? 9/30/2017 12/31/2020 12/31/2021 12/31/2019 Page 14 of 15 TE D E 67.971 5.100 7 805 80,876 45,500 20.000 146,376 1 Assets 2 Cash 3 Accounts Receivable 4 Inventory 5 Current Assets 6 Property & Equipment 7 Goodwill 8 Total Assets 9 10 Liabilities 11 Short Term Debt 12 Accounts Payable 13 Current Liabilities 14 Long Term Debt 15 Total Liabilities 16 Shareholder's Equity 17 Equity Capital 18 Retained Earnings 19 Shareholder's Equity 20 Total Liabilities & Shareholder's Equity 21 22 23 24 3,902 3,902 50,000 53,902 70,000 2474 72,474 126,376 IF(08-020 "OK" Given the above screenshot, what is the resulting value in cell D22? OK FALSE