CFI Assessment Test Questions and Answers

CFI Assessment Test Questions and 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) - 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) 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