Write the steps for using SUM function and AVERAGE function in MS Excel.
Answers
Answer:
Sum function
Step1: Click on the cell where you want to get your result.
Step2: Type '=Sum(' and click on cells which you want to put in sum function. For example: =sum(A1,B1,C1)
Step3: Press enter. The result will be displayed.
Average function
Step1: Click on the cell where you want to get your result.
Step2: Type '=average(' and click on cells which you want to put in average function. For example: =average(A1,B1)
Step3: Press enter. The result will be displayed.
Please mark me Brainliest
Explanation:
The SUM function totals one or more numbers in a range of cells.
Select the blank cell in the row below the cells that you want to sum, cell A5 in this example.
Click the AutoSum command on the Ribbon's Home tab, ...
A SUM formula will appear in the active cell, with a reference to the cells above.
For example, the AVERAGE function below calculates the average of the numbers in cells A1 through A3.
2. The formula below produces the exact same result.
Sum and Count
3. The following AVERAGE function calculates the average of the numbers in cells A1 through A3 and the number 8.
Calculate Average
4. The AVERAGE function ignores logical values (TRUE or FALSE), empty cells and cells that contain text.