Industrial Training Institutes (ITI) Updates


Hello friends..!!

Welcome to ITI Updates.


Comments

Post a Comment

Popular posts from this blog

SOME COMPUTER QUESTIONS

Hello Everyone, If you have VIVA in school, College, other Paper. So I've some questions for viva.  Click below for the questions.      →    SOME COMPUTER QUESTIONS If you have any doubts mention in the Comment Box. Please follow my Blog, Share and Comment. THANK YOU
Read more

MS Excel Mark sheet

Image
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","...
Read more