View image, showing additions of 10, 20 and 30. Select the cell where you want the result to appear in this example as cell C6. Then type in cell = sign in, now choose first cell C3 then type “+” sign then choose second cell C4, then type + and third cell choose C5. Now
Read moreExcel Calculation
Sigma addition in Excel
Select the cell to display the result then click the Sigma button at the right end of the ribbon in the Home tab. You will see the image below: Now select the list of data you want to add. You will see the image below, and then press the Enter key to get the result.
Read moreHow to do subtraction in Excel
This is similar to the addition of only the sign with the minus sign “+”. Select the cell where you want the result to appear in this example as cell C6. Then type in cell = sign in, now choose first cell C3 then type – “sign then choose second cell C4. Now press enter
Read moreHow to calculate average in Excel
Select the cell to display the result e.g. Cell C9 in the image shown below. Now type “=” sign in the cell and type “average” then type the opening bracket. Now select the data, cell from C4 to C7 then press Enter key to get the result.
Read moreSigma calculate average in Excel
Select the cell to display the result. Click the small arrow next to the Sigma button in the Home tab, and left click the Average option. You will see the image below. Then press the Enter key to get the result.
Read more