The formula to calculate the sum of the value of cell A1,A2 and A3 and then divide by 4 is_____
Answers
Answered by
2
Question:-
Write the formula to calculate the sum of the value of cell A1,A2 and A3 and then divide by 4.
Answer:-
The required formula is,
=SUM(A1:A3)/4
Answered by
2
Formula to calculate the sum of the value of cell A1,A2 and A3 and then divide by 4 is SUM(A1:A3)/4.
Explanation:
- In Microsoft Excel, all cells are represented with names in the like of A1, A2, A3, A4, etc. We can find the sum, difference, averages, etc. and any number of mathematical calculations with the help of Excel sheet.
- There are a number of boxes in an Excel spreadsheet which we call as cells and they are numbered and ordered according to rows and columns. Data is inputted into the spreadsheet by the user and functions are performed.
- Here, SUM function is used to add the numbers from A1 to A4 and the slash is given to divide the sum of the cells by 4.
Hence the formula to calculate the sum of the value of cell A1,A2 and A3 and then divide by 4 is SUM(A1:A3)/4.
Learn more Excel functions
https://brainly.in/question/22829082
Learn more here
https://brainly.in/question/20850779
Similar questions