6. Write the formula to:
A) Calculate the sum of cell A1 to A5 (data present in sheet 2) in sheet 1
B) Calculate the Average of above said content in Book2.
Answers
Answered by
1
In the excel sheet, the sum of data in each column or row can be calculated by using the following formula.
Explanation:
The formula is
= sum ( Cell 1+ cell2 )
Here the number of cells is 5 i.e. from A1 to A5.
It can be calculated as
= sum ( A1, A2, A3, A4, A 5 )
The average formula:
To get the average from A1 to A5 you will write.
= Average ( A1: A5)
Similar questions