CFI Assessment Questions and Answers Latest Version (2024/2025) Already Passed

1



CFI Assessment Questions and Answers Latest Version
(2024/2025) Already Passed
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) - (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) - (ANSWER)b) ALT + H + P (PC) / Ctrl + Shift + %
(Mac)

, 2


Which of the following formulas properly produces the string "Income
Statement"?




a) = "Income "+"Statement"

b) = "Income"&" "&"Statement"

c) = "Income"&"Statement"

d) =Income&Statement - (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() - (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?