Spreadsheet Tool : OO Calc I — Question 11

Question 11

Suggest the Calc functions that can be used for carrying out following operations :

(i) To calculate total marks of a student if his marks in five subjects are given in five different cells.

(ii) To calculate average sales made by salesman of a company, if sales made by each of the salesmen is available.

(iii) 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.