CFI 100 Assessment Exam Questions and Answers 100% Verified

CFI 100 Assessment Exam Questions and Answers 100% Verified 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