Question

Susan is creating a spreadsheet, and she needs to enter the months of the year in column A. Susan should _____.

enter January in cell A1, February in cell A2, March in cell A3, April in cell A4, May in cell A5, June in cell A6, and July in cell A7
enter January in cell A1, place her mouse over the bottom right corner, and drag down
enter January in cell A1 and press the Tab key
enter January in cell A1, highlight the cell, and use copy and paste command

Answer 1

Enter January in A1 hold mouse in bottom right hand corner of cell. Hold mouse button down and drag the mouse. Excel will populate the months of the year

Answer 2

The correct method is enter January in cell A1, place the mouse over the bottom right corner, and drag down

Step-by-step explanation:

We can do the autofill by selecting the cell that contains the starting date, time, weekday, month, or year. Then by dragging the fill handle over the cells that you want to fill can autofill the months. To do this we just write the first month in the cell A1 and then repeating the process. We can also use the Excel autofill option from the smart button.