CBSE Class 9 Computer Applications
Question 39 of 39
Microsoft Excel 2010 - I — Question 5
Back to all questions 5
Question Question 5
Suggest the Excel functions which can be used for the following:
(a) To calculate the average marks obtained by a student in SA1 assuming that his/her marks of individual subjects are given.
(b) To find the highest marks of Hindi in your class, if marks of all students are given.
(c) To calculate the quarterly sales of a sales executive, if the sales data of all months are given.
(d) To find out the minimum quoted tender rates submitted by various companies to the Govt. of India.
(a) = AVERAGE ()
(b) = MAX ()
(c) = SUM ()
(d) = MIN ()