Student Projects/Addition and Multiplication In MS Excel

Addition and Multiplication In MS Excel

Addition and multiplication are two very basic and easy operations which can be performed in MS Excel.

Addition

Addition in MS Excel can be done through 2 pathways:

Autosum

If the data are arranged continuously, select the cells and click on "Autosum" under 'Home' tab. The sum of the selected cells will appear one cell to the right or down of the selection, according to the direction of the selection.

Manual

If the data are segregated , select the cell in which the sum is required, and enter = symbol and manually select the cells one by one, whose values needed to be added, with + symbols between each consecutive selection. Then press the 'Enter' key and the sum appears in the selected cell.

Multiplication

Select the cell in which the product needs to be entered. Enter = symbol and select the cells whose values needs to be multiplied with * symbol in between two consecutive selections. Press the Enter key and the product of the selection appears.