Question

Give the formula for the following conditions.

a. To calculate total of given mark

b. To find the average of the given mark

c. To find to maximum mark of given mark.​

Answer 1

Answer:

a. To calculate total of given mark:-

{ = SUM ( (response = correct_list) + 0) }

= SUMPRODUCT ( (response = correct_list) + 0)

{ = SUM ( ( key = range ) + 0 ) }

= COUNTBLANK ( range)

= SUMPRODUCT ( ( key <> range ) + 0 ) - COUNTBLANK (range)

b.To find the average of the given mark:-

For example, to find the average of 12, 15, 24, 78, 3, 313 and 10, simply sum the numbers (12 + 15 + 24 + 78 + 3 + 313 + 10 = 455) and divide by the total number of values in the set (7) to get an average of 65.

c.To find to maximum mark of given mark:-

To find the percentage of the marks, divide the marks obtained in the examination with the maximum marks and multiply the result with 100. Example 1: If 1156 is the total score obtained in the examination out of 1200 marks, then divide 1156 by 1200, and then multiply it by 100.

This is the right answers for your question.