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.

Question

Quizplus · Accepted Answer

By typing January in cell A1 and then using the fill handle (the small black square at the bottom-right corner of the cell), Ellen can easily create a series of months for the year. She can simply click and hold the fill handle and drag it down to fill the cells with the remaining months. Additionally, the other options provided do not apply to creating a series of months.

Case 3-1 Ellen Is a Recent College Graduate. She Has Decided to Decided