Answers
1. 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)
2. 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)
1/
7
, 3. Which of the following formulas properly produces the string
"Income State- ment"?
a) = "Income "+"Statement"
b) = "Income"&" "&"Statement"
c) = "Income"&"Statement"
d) =Income&Statement
Answer b) = "Income"&" "&"Statement"
4. 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
5. Given the above screenshot, which of the following formulas will
NOT pro- duce the correct weighted average of 7,751 as in cell
D10?
2/
7