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

Count the no of lowercase letters in a text file bca.txt in C

-
Image
Write a program in C to count the no of lowercase letters in a text file bca.txt This program reads one character at a time by using fgetc() function until the EOF (end of file) returns. Then it checks whether the current character is lowercase or not. If it is a lowercase letter it increments the value of c by 1. It also displays the contents of file named bca.txt. And finally print the total number of lowercase letters present in the file, which is the main purpose to write the program Program #include<stdio.h> #include<conio.h> void main()  {   FILE *fptr;   char ch;   int c=0;   if((fptr=fopen("bca.txt","r"))==NULL)    printf("File doesn't exist\n");   else    {     while((ch=fgetc(fptr))!=EOF)      {       if(ch>=97&&ch<=122) c++;       printf("%c",ch);      }    }    printf("\nTotal lowercase letter in bca.txt file ...
Read more

Write a program in C to check whether the number is prime or not.

-
Image
/*Write a program in C to check whether the number is prime or not.*/ /*Note: Prime numbers are those numbers which is divisible by 1 or itself */ /* Solution 1: */ #include<stdio.h> #include<conio.h> void main()  {    int num,i=2;        /* Variables Declaration of integer type num and i  and             initialize the value of i*/    clrscr();                        /* Function to clear the console screen */    printf("Enter a number\n");  /* General message for the user */    scanf("%d",&num);      /* Input a number by the user/through the keyboard*/    while(i<num)              /* Starting of while loop */         {       if(num%i==0)        /* Check whether the input number is...
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