MS Excel Mark sheet


Hello friends..!!
Aaj hum MS EXCEL me MARK SHEET kaise bnate hai vo btayege
Question: -HOW TO MAKE THE MARK SHEET (STEP BY STEP)?
§  Let’s start ->
Step 1:- Open the MS Excel.


Step 2:- Make a Data of student.

Step 3:-Make the column also Total, Percentage, Grade & Result.

Step 4:- Add the Total formula
Formula                 
=sum(first no. cell address:end no. cell address )


Step 4:- Add the Precentage formula
Formula
=total cell address/no. subject )


Step 4:- Add the Grade formula
Formula 
=IF(percentage cell address>85,"A“,IF(percentage cell address>75,"B",IF(percentage cell address>65,"C",IF(percentage cell address>50,"D","F“))))



Step 4:- Add the Result formula
Formula 
=IF(AND(Ist subject no. cell address>33, IInd subject no. cell >33,IIIrd subject no. cell >33),"pass","fail")




Result:-

 If you have any doubts mention on the Comment Box.

Please follow the my Blog, Share and Comment.

Comments

Post a Comment

Popular posts from this blog

MS EXCEL :-SALARY SHEET

Image
Hello friends..!! Aaj hum MS EXCEL me SALARY SHEET kaise bnate hai vo btayege Question: -HOW TO MAKE THE SALARY SHEET (STEP BY STEP)? §   Let’s start -> Step 1:- Open the MS Excel. Step 2:- Make a Data of Employee. Step 3:-Make the column also HRA, DA, CCA, TA, Gross Gross, Income Tax, Advance, Medical, PF, Deduction, and Net Salary. Step 4:- Add the HRA formula Formula                                            =30% *basic salary cell address Step 5:- Add the DA formula Formula                                          =2% *b...
Read more

Forage Solutions

Image
  Here some Forage Internships Solution Forage Solution: - Tata Data Visualisation: Empowering Business with Effective Insights Forage Solution: - Accenture Data Analytics and Visualization Job Simulation If you have any doubts mention on the Comment Box. Please follow my Blog, Share and Comment.
Read more