Dragging the AutoFill handle is the most common way to apply the same formula to an entire column or row in Excel. There we can search for anything we want. Adding and subtracting two columns in one formula.
For example just type 2 2 in a cell of your choice and Excel will perform the requested calculation.
Simple formulas always start with an equal sign followed by constants that are numeric values and calculation operators such as plus minus - asterisk or forward slash signsLets take an example of a simple formula. This process activates all the functions or formulas of excel. You can add in Microsoft Excel in a variety of different ways from adding within a cell to totaling up an entire columns contents. Add or subtract a combination of days months and years tofrom a date.