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. ​