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
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","...
Comments
Post a Comment