Question

"Excel enables you to fill the series data using data fill handle" Explain with Example

Answer 1

Answer:

Meaning : In Microsoft Excel, fill handle is a command that lets you fill data in to your spreadsheet cells, that is based on a pattern you establish. For example, you can use this command to continue a series of numbers, text combinations, or dates.

Fill Handle in excel is used for filling up the data by creating a series of value which either follow a pattern or we can check if the values we entered are of series or not. It is very easy to implement. Fill Handle is available at the right bottom of any cell. Enter some values such as number or alphabets or dates in at least 3 cells to have a pattern. Select the cells with values and then either drag the Fill Handle or double click will also work here.