CFI Assessment Questions And Answers Graded A+

Which of the following formulas correctly anchors ONLY the row in cell A1? a) A$1 b) A1 c) $A$1 d) $A1 - ️️a) A$1 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) - ️️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 - ️️b) = "Income"&" "&"Statement" 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 - ️️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 - ️️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! - ️️b) 780 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) - ️️a) CTRL + R (PC and Mac) 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! - ️️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 - ️️d) Hard Codes in Blue, Formulas in Black Given the above screenshot, what is the resulting value in cell D22? a) ERROR b) FALSE c) TRUE d) OK - ️️b) FALSE What is the result of inputting =IF(59,ok,error) into a cell? a) 5 b) error c) #NAME? d) ok - ️️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]) - ️️d) =YEARFRAC(start_date,end_date,[basis])