If you're looking for a way to create a student report, Microsoft Excel makes it easy to create a wonderful spreadsheet with tons of information. This video shows an example of a student report being created, which has three simple items in the columns of the sheet, which are the names of the students, the marks obtained and the grades.
Column A and Column B are the inputs by the user and Column C is the grade of the students that is dependent on the following four criteria:
1. If obtained marks are more than or equal to 80, and less than 90, then grade would be "A"
2. "..." 70, and less than 80, then grade would be "B"
3. "..." 60, and less than 70, then grade would be "C"
4. If obtained marks are less than 60, then grade would be "Failed"
For above purpose, put this "IF" function in C4 column. The function is:
=IF(B4>=80,"A",IF(B4>=70,"B",IF(B4>=60,"C","Failed")))
Then copy this function to all the required cells. Then, time for some conditional formatting on column C for the following criteria:
A. If marks are greater than or equal to 80, and less than 90, then background color of the cell should be green
B. "..." 70, and less than 80, then background color of the cell should be purple
C. "..." 60, and less than 70, then background color of the cell should be gray
To achieve this follow the step-by-step process:
1: Select the cells of C column (Grade) where conditional formatting is to be applied.
2: Click Format Menu.
3: Choose Conditional Formatting.. From the menu.
4: Conditional formatting dialogue box will be appeared on the screen. Under condition 1, choose Formula Is from the drop down menu and then type this formula in the text box:
=AND(IF(B4>=80,B4<90))
For the remaining 4 steps, check out the original article.
Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.
Other worthwhile deals to check out:
- 97% off The Ultimate 2021 White Hat Hacker Certification Bundle
- 98% off The 2021 Accounting Mastery Bootcamp Bundle
- 99% off The 2021 All-in-One Data Scientist Mega Bundle
- 59% off XSplit VCam: Lifetime Subscription (Windows)
- 98% off The 2021 Premium Learn To Code Certification Bundle
- 62% off MindMaster Mind Mapping Software: Perpetual License
- 41% off NetSpot Home Wi-Fi Analyzer: Lifetime Upgrades
Be the First to Comment
Share Your Thoughts