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 2013. She need to keep track of her expenses and income for the year.
-Ellen opens Excel 2013 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.

Question

Quizplus · Accepted Answer

To create a series of months, Ellen can type January in cell A1 and then click and drag the fill handle (a small green square at the bottom right corner of the cell) to the right to create the rest of the months in the year. Excel will automatically fill in the rest of the months based on the pattern it recognizes. Typing = Jan-Dec in cell A1 will not create a series of months, it will only display the text "Jan-Dec". Typing =YEAR in cell A1 will display the current year, not a series of months. Typing =DATE(Jan, Dec) in cell A1 will result in an error message, as Excel is expecting numeric inputs for the DATE function.

Ellen Is a Recent College Graduate