CFI Assessment Questions and Answers Graded A+

CFI Assessment Questions and Answers Graded A+ 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) 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) 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 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() 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 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 c) 0 Given the above screenshot, suppose =SMALL(C2:C6,4) is entered into cell C9. What output will result from this formula? a) 2000 b) 780 c) 50