CFI Assessment Questions And Answers Graded A+

CFI Assessment
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

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"

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


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)


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() - ✔️✔️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