Today, we will discuss How to create an Students Test Score Grades Result Sheet in Excel using Formulas / Functions ( IF Function ) . The following formulas will be used in Students Test Score Grades Result Sheet: Q: Prepare the following Students Test Score Grades worksheet in MS Excel. Apply suitable formula and functions: Test Score >=90 A grade, 80-89 B grade, 70-79 C grade, 60-69 D grade, below 60 F grade, as shown in the following table: Roll No. Test Scores Grade 1 90 A 2 80 B 3 75 C 4 60 D 5 50 F Create a worksheet in MS Excel according to the requirements as shown above Enter sample data of Roll No. and Test Score Columns as shown in above table. Apply formula to calculate Grade on the basis of test scores obtained by the student. Grade Formula in Students Test Score Grades Result Sheet Grade Formula=IF(B3>=90,"A",IF(B3>=80,"B",IF(B3>=70,"C",IF(B3>=60,"D","F"))))
Study and Download Perfect Computer Notes on Concepts of Information Technology and Computer Science.