Suggest the Excel function that can be used for carrying out following operations:
1. To calculate total marks of a student marks in subject are given in 5 different cell.
2. To calculate average sales made by salesman of a company, if self made by each of the salesman is available.
3. To find out the marks of top scorer in a class, if marks of all the students are available.
4. To find out minimum quoted rate from various available.
Please help me Complete the answer And answer correctly
Share
Verified answer
Answer:
Explanation:
Calc functions that can be used for carrying out the operations.
Explanation:
MS-Excel functions which can be used for the following operations:
(i) To calculate total marks of a student if his marks in five subjects are given in five different cells.
=SUM(A1:A5)
SUM function calculate total marks of a student by adding marks of five subject stored in five different cells i.e A1, A2, A3, A4 and A5
(ii) To calculate average sales made by salesman of a company, if sales made by each of the salesmen is available.
=AVERAGE()
(iii) To find out the marks of top scorer in a class, if marks of all the students are available.
=MAX()
(iv) To find out minimum quoted rate from various quotations available.
=MIN()