Multiple Choice
Case 3-1
Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year.
-Ellen opens Excel 2016 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.
A) Type = Jan-Dec in cell A1 and then press Enter.
B) Type January in cell A1 and then drag the filll handle.
C) Type =YEAR in cell A1 and then press Enter.
D) Type =DATE(Jan, Dec) in cell A1 and then press Enter.
Correct Answer:

Verified
Correct Answer:
Verified
Q5: An error value indicates that some
Q11: Lookup tables can be constructed for exact
Q34: The IF function is a logical function
Q40: By default,AutoFill copies only the content not
Q42: The _ category of Excel functions returns
Q69: A(n)_ function is a function that works
Q70: When you copy a formula that contains
Q74: _ is a set of rules which
Q81: The following mixed reference in the
Q95: Optional arguments are always placed first in