The user can select a cell or cells and fill a range of cells with the same value or with values that have been adjusted with special options.

See Using Drag Fill for more information.