Sum, Average And If Function In Excel

-
Use of Sum, Average and If function to calculate Total Marks, Average Marks and check whether the student is pass or fail according to the condition ( in this case if a student got average/percentage of marks greater than or equal to 60 then he will pass otherwise fail. 

Translation:-

कुल अंकों, औसत अंकों की गणना करने के लिए योग, औसत और यदि फ़ंक्शन का उपयोग करें और जांच करें कि क्या छात्र शर्त के अनुसार उत्तीर्ण या अनुत्तीर्ण है (इस मामले में यदि किसी छात्र को 60% से अधिक या उसके बराबर अंक का औसत / प्रतिशत मिला है तो वह होगा  पास होना अन्यथा वह विफल हो जाएगा)



Popular posts from this blog

M3-R4 O-Level Jan-20 MCQ With Answers

-
Image
M3-R4 O-Level   Jan-20 MCQ M3-R4 : PROGRAMMING & PROBLEM SOLVING THROUGH ‘C’ LANGUAGE PART-1 1.  Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein.                                                                                                                                                (1x10 ) To read about  M3-R4 O-Level Jan-20 TRUE Or FALSE  Click on the following link: https://learncomputerpci.blogspot.com/2020/07/m3-r4-o-leveljan-20-true-or-false-m3.html 1.1...
Read more

M3-R4 O-Level Jan-20 TRUE Or FALSE

-
Image
M3-R4 O-Level Jan-20 TRUE Or FALSE M3-R4: PROGRAMMING & PROBLEM SOLVING THROUGH ‘C’ LANGUAGE PART-1   Note:   To read about  M3-R4 O-Level Jan-20 MATCH THE FOLLOWING Click on the following link: https://learncomputerpci.blogspot.com/2020/07/m3-r4-o-leveljan-20-match-following-m3.html 2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and ENTER in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10=10)   2.1 In C, upper and lower cases letter are same. Answer: False 2.2 = is used for comparison, whereas, == is used for assignment of two quantities. Answer: False 2.3 A function can be defined inside another function. Answer: False 2.4 In switch statement, the default case is optional. Answer: True 2.5 strlen() function counts the number of characters in a given string and returns      the integer value. Answer: True 2.6 The continue statement cannot be used with ...
Read more