CFI Assessment Exam 15 Questions with Verified Answers,100% CORRECT

CFI Assessment Exam 15 Questions with Verified Answers What combination of keys will autofill highlighted cells to the right? Review Later a) CTRL + R (PC and Mac) b) CTRL + D (PC and Mac) c) ALT + R (PC) / Alt + R (Mac) d) ATL + D (PC) / Alt + D (Mac) - CORRECT ANSWER a) CTRL + R (PC and Mac) What combination of keys turns the value in a cell into a percentage? a) CTRL + H (PC) / Command + H (Mac) b) ALT + H + P (PC) / Ctrl + Shift + % (Mac) c) ALT + M (PC) / Ctrl + M (Mac) d) ALT + P (PC) / Ctrl + P (Mac) - CORRECT ANSWER b) ALT + H + P (PC) / Ctrl + Shift + % (Mac) Which of the following formulas properly produces the string "Income Statement"? a) = "Income "+"Statement" b) = "Income"&" "&"Statement" c) = "Income"&"Statement" d) =Income&Statement - CORRECT ANSWER b) = "Income"&" "&"Statement" Suppose today is December 14, 2014. Which of the following functions will NOT return 12/14/2014 as a date? a) 12/14/2014 b) =DATE(2014,12,14) c) =12/14/2014 d) =TODAY() - CORRECT ANSWER c) =12/14/2014 Given the above screenshot, which of the following formulas will NOT produce the correct weighted average of 7,751 as in cell D10? a) =D8/C8 b) =SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7) c) =SUMPRODUCT(C3:C7,D3:D7)/C8 d) =(C3*D3+C4*D4+C5*D5+C6*D6+C7*D7)/C8 - CORRECT ANSWER a) =D8/C8 Suppose the following formula is inputted into Excel:=MROUND(1/4,100)The output in the cell will be: a) 1 b) 0.2500 c) 0 d) 0.25 - CORRECT ANSWER c) 0 Given the above screenshot, suppose =SMALL(C2:C6,4) is entered into cell C9. What output will result from this formula? a) 2000 b) 780 c) 50 d) #NUM! - CORRECT ANSWER b) 780 Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula? a) 2600 b) 1100 c) #VALUE! d) #NUM! - CORRECT ANSWER a) 2600 According to the information mentioned in the course, which of the following color schemes is best practice for financial modeling? a) Hard Codes in Black, Hard Codes in Red b) Hard Codes in Black, Formulas in Blue c) Hard Codes in Red, Formulas in Black d) Hard Codes in Blue, Formulas in Black - CORRECT ANSWER d) Hard Codes in Blue, Formulas in Black Which of the following formulas correctly anchors ONLY the row in cell A1? a) A$1 b) A1 c) $A$1 d) $A1 - CORRECT ANSWER a) A$1 What is the result of inputting =IF(59,ok,error) into a cell? a) 5 b) error c) #NAME? d) ok - CORRECT ANSWER c) #NAME? What is the correct syntax for the =YEARFRAC function? a) =YEARFRAC(basis,start_date,end_date) b) =YEARFRAC(start_date) c) =YEARFRAC(end_date,start_date) d) =YEARFRAC(start_date,end_date,[basis]) - CORRECT ANSWER d) =YEARFRAC(start_date,end_date,[basis]) The result of =ROUND(513.2413,2) is __ - CORRECT ANSWER 513.24 Given the above screenshot, which of the following is the resulting value in cell G2? a) 9/30/2017 b) 12/31/2020 c) 12/31/2019 d) 12/31/2021 - CORRECT ANSWER b) 12/31/2020 Given the above screenshot, what is the resulting value in cell D22? a) ERROR b) FALSE c) TRUE d) OK - CORRECT ANSWER b) FALSE