Question

Suggest the Excel functions that can be used for carrying out following operations
To calculate total marks of a student if his marks in five subjects are given in
five different cells.
(i) To calculate average sales made by salesman of a company. if sales made by
each of the salesman is available
(it) To find out the marks of top scorer in a class, if marks of all the students are
available
(iv) To find out minimum quoted rate from various quotations available​

Answer 1

Answer:

1. =SUM()

2. =MAX()

3. =SUM()

4. =MIN()

Explanation:

Hope you like my answer... Please mark me the brainliest...