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

Sponsored Links

Sunday, July 6, 2014

Students Test Score Grades Result Sheet in Excel

Leave a Comment
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.

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"))))

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.

Download the Original Workbook File Prepared For Students Test Score Grades Result Sheet in Excel

Click to Download Excel Workbook For Students Test Score Grades Result Sheet Students Test Score Grades Result Sheet with Formulas in Excel is normally required to be prepared by the students of a Basic Microsoft Office Training Course. There are very simple formulas used to calculate Grade using the IF logical function. Although, an established institute may use a customized software for preparing Result Sheets, the students of Microsoft Excel will learn the use of different formulas and built-in functions to prepare Students Test Score Grades Result Sheet Worksheet with Formulas. Microsoft Excel can be very helpful to prepare such worksheets.  

0 comments:

Sponsored Links

.