Excel gives advantage of auto editing the result. explain in short
Answers
lainib
Excel's Auto Fill feature greatly enhances the data entry process. The program can automatically fill in cells, create a row of dates, and even copy formatting from one cell to the next. You can use Auto Fill by clicking and dragging the fill handle: the small black box that appears in the bottom-right corner of selected cells.
Automatic and Format Copying
The Auto Fill function in Excel can copy the contents of individual cells, as well as the formatting each cell contains. The auto-copy function will activate if you drag the Auto Fill handle after selecting either a single cell that does not contain a date, time or formula, or multiple cells that do not contain a logical progression such as "1, 2, 3, 4." Excel automatically copies the contents of a single cell or, for multiple cells, repeats the pattern of the initial entry. By default, clicking and dragging the small Auto Fill handle will copy the cell contents and formatting. You can also right click while dragging the Auto Fill handle and select from among "Copy Cells," "Fill With Formatting" or "Fill Formatting Only."
Automatic Ordering
One of the most helpful Auto Fill features is the automatic enabling of linear trends; e.g., "1, 2, 3, 4" or "5, 10, 15, 20." If you fill in two or more adjacent cells with different numbers, highlight them and drag the Auto Fill handle, Excel fills in its best guess regarding your trend. Excel also automatically fills in dates; if you type in "January" and drag the Auto Fill handle, Excel fills in "February," "March" and onward. If you format a date as "mm/dd/yyyy," Excel also fills in subsequent dates. You can adjust this process by holding down the right mouse button while dragging the Auto Fill handle and selecting "Series..."
Automatic Completion
Excel can automatically complete the contents of a cell. While you are typing, the program may suggest an auto completion. For instance, you may type the letters "C-O-N-S" and Excel may fill in the word "Constant," with "T-A-N-T" highlighted. In general, it only AutoCompletes cells with suggestions of entries already in the spreadsheet, which makes it easier to work with repeated data labels. Press "Enter" to accept a completion.
Automatic Formulas
Auto Fill also automatically replicates formulas, which are equations with variables that are often the values from other cells. When doing this, Excel estimates the intended source of the formula's variables. If you fill in a formula in cell B1 with a value from cell A1, then fill down the column, the formula seeks values from cells A2, A3, and so on. This is useful for producing graphs of individual equations; if you fill in the function in the first cell from the first in a series of variables, you can Auto Fill the same equation for each subsequent variable.