If a user enters "jan" and "feb" in cells E1 and E2,selects those two cells and drags the small black box to three more cells below them,then ________.
A)the three cells display "mar,apr,may" respectively
B)the three cells remain empty
C)Excel displays an error message
D)the three cells display "jan,feb,jan" respectively

Question

Quizplus · Accepted Answer

Excel has an inbuilt feature to recognize the series of month names and automatically fill the rest of the cells with the next month names. Hence, the three cells will display "mar, apr, may" respectively.

If a User Enters "Jan" and "Feb" in Cells E1