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

Answer 1

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

Answer 2

Answer:

hello mate here's your answer.

Explanation:

i)SUM

ii)AVERAGE

iii)MAX

iv)MIN