# Perfect Computer Notes

Super Easy Short Computer Notes To Improve Computer Literacy and Your IT Skills

# Students Test Score Grades Result Sheet in Excel

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
1. Create a worksheet in MS Excel according to the requirements as shown above
2. Enter sample data of Roll No. and Test Score Columns as shown in above table.
3. Apply formula to calculate Grade on the basis of test scores obtained by the student.

### Image for Students Test Score Grades Result Sheet in Excel Students Test Score Grades Result Sheet in Excel

Solution:
1. Create a new workbook in MS Excel and save as with the name Students Test Score Grades Result Sheet in Excel
2. Enter sample data for one to five Roll Numbers of students as shown in above table.
3. Enter formula for Grade in the cell C3 Formula=IF(B3>=90,"A",IF(B3>=80,"B",IF(B3>=70,"C",IF(B3>=60,"D","F"))))and press Enter.
So, the worksheet with Electricity Bill Calculator Formulas Worksheet in Excel has been prepared successfully.