Skip to main content

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.

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
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.  

Comments

Popular posts from this blog

Explain different types of storage devices

Topic: Explain different types of storage devices in Computer systems Storage Devices Storage devices are used to store data and instructions permanently. Storage devices are also called secondary storage devices / backing storage devices / external storage devices or auxiliary storage devices. Examples of storage devices include Hard Disk, CD and DVD etc. Why Secondary Storage Devices are Used? Secondary storage devices are used because: Primary memory(RAM) is volatile and temporary. When computer is switched off, all data in ram is erased. Storage devices can store large amounts of data and instructions permanently whereas Primary memory has less capacity of storing data. Types Of Storage Devices There are three main types of storage devices:  Magnetic Tape   Magnetic Disk   Optical Disk   Flash Memory storage devices 1. Magnetic Tape Magnetic tape is the oldest storage device. It is made of plastic coated with m...

Electricity Bill Calculator Formulas in Excel

Today, we will discuss How to create an Electricity Bill Calculator Worksheet by using Electricity Bill Calculator Formulas in Excel . The following formulas will be used in Electricity Bill Calculator Worksheet: Q: Prepare a worksheet according to the following instructions: Create a worksheet in MS Excel according to the requirements Enter sample data of Electricity units consumed by customers in a city Apply formula to calculate Units Consumed Apply formula to calculate Electricity Charges Apply formula to calculate Surcharge Apply formula to calculate Bill Payable Note: Every formula will start from  =  Units Consumed Formula=D5-C5 Electricity Charges Formula=IF(E5>200, E5*15,IF(E5>100, 1000+(E5-100)*12, E5*10)) SURCHARGE FORMULA = IF(F5>5000, F5*5%,IF(F5>1000, F5*3%, 0)) BILL PAYABLE FORMULA = SUM(F5:G5) Download Excel Electricity Bill Calculation Worksheet Free  Image for Electricity Bill Calculator Formulas ...

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...