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

IGNOU Solved Assignment 2023-24 | BCS-012 Basic Mathematics BCA(I)012/Assignment/2023-24

-
Image
IGNOU Solved Assignment 2023-24 | BCS-012 Basic Mathematics BCA(I)012/Assignment/2023-24 Q1. If A = [3 -1],                   [2  1] Show that A^2 - 4 A + 5 I2 = 0. Also, find A^4        Q2. Find the sum of first all integers between 100 and 1000 which are divisible by 7.           (5)   Q3. a) If pth term of an A.P is q and qth term of the A.P. is p, find its rth term.    b) Find the sum of all the integers between 100 and 1000 that are divisible by 9.    Q4. If 1, 𝜔,𝜔 2 are cube roots of unity, show that (2 – 𝜔) (2 – 𝜔 2 ) (2 – 𝜔 19) (2 – 𝜔 23) = 49.     Q5. If α, β are roots of x2 – 3ax + a2 = 0, find the value(s) of a if α2 + β2 = 7/4 .   Q13. Using integration, find length of the curve y = 3 – x            from (-1, 4) to (3, 0).     Q14....
Read more

Generation Of Computer | Computer Generation | कंप्यूटर की पीढ़िया

-
GENERATION OF COMPUTER First Generation Second Generation Third Generation Fourth Generation Fifth Generation   Generation Technology Language First Vacuum Tube Machine Language Second Transistor Assembly Language Third Integrated Circuit (I C) High Level Language (H L L) Fourth Very Large Scale Integrated Circuit (V L S I) Structural Query Language (SQL) Fifth Ultra Large Scale Integrated Circuit (U L S I) Artificial Intelligence (AI) To Know more about click the following link https://youtu.be/O7iDZIO2MAw    
Read more

Fibonacci Series In C-Gaurav Pali

-
Image
 Write a program in C to print the Fibonacci Series Note:- In the Fibonacci series, every next number is the sum of the previous two numbers. #include<stdio.h> #include<conio.h> void main()  {   int a=0,b=1,c,i,n;   clrscr();   printf("Input number of terms you want to print");   scanf("%d",&n);   printf("%d %d ",a,b);   for(i=1;i<=n;i++)    {     c=a+b;     a=b;     b=c;     printf("%d ",c);    }   getch();  } Program ScreenShot OutPut
Read more