CFI ASSESSMENT TEST WITH GRADED SOLUTIONS -21

CFI ASSESSMENT TEST WITH GRADED SOLUTIONS #21

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

Suppose the following formula is inputted into Excel:=MROUND(1/4,100)The output in
the cell will be:

A) 1
B) 0.2500