Question

What is Auto fill feature in excel ? Give two examples of series that can be generated by Auto fill.

Answer 1

Answer:

Excel has a feature that helps you automatically enter data. If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.

AutoFill a List of Dates

-- Data in Next Column.

-- No Data in Next Column, or Blank Cells in Next Column.

You can use a custom list with the AutoFill feature. ...

--AutoFill Weekday Names.

--AutoFill Month Names.

--AutoFill Your Own List.

-- AutoFill Dates by Week.

-- AutoFill Dates by Weekday