CFI ASSESSMENT QUESTIONS & ACCURATE COMPLETE SOLUTIONS

CFI ASSESSMENT QUESTIONS &
ACCURATE COMPLETE SOLUTIONS

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?