Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: How to Create gradereport with Microsoft Excel

30 Jun 2012   #1

windows 7 ultimate x86
How to Create gradereport with Microsoft Excel

Hi,I'm trying to create a student's grade report for my teacher using MS Excel .Here's the draft of the report:

1. how can I set the Grade automatically once I insert the score?i.e, once I insert 90marks, the grade there will automatically appear grade A.

2. How can I set the GPA score automatically after the insertion of the Grade according to the grade table below?

3.Since there are about 20 students and the sheet need to print out, how can I save all the 20 students grade and print them out? creating a new sheet for a new student?

there's my problem I faced since I seldom use MS Excel. The format should be like this . Can someone helps me to clear my problems?I really appreciate your help!thanks!

My System SpecsSystem Spec

30 Jun 2012   #2

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64


You need to use some conditional statements and formulas. Since you aren't that familar with Excel, its easier if you upload a copy of the spreadsheet here, and I'll be glad to add it in for you.

My System SpecsSystem Spec
30 Jun 2012   #3

windows 7 ultimate x86

Hi,here's the link of my draft sheet:
sorry, ignore the 1st one,i try to upload 2nd sheet:
this is it!

you can manipulate the scores for testing =) the scores i stated are just for trying.
My System SpecsSystem Spec


 How to Create gradereport with Microsoft Excel

Thread Tools

Similar help and support threads for2: How to Create gradereport with Microsoft Excel
Thread Forum
Can I create a pie chart with data in an existing excel file? Microsoft Office
About microsoft excel Microsoft Office
How to create two adjacent Y-axes in Excel 2010 Microsoft Office
Solved Microsoft Excel Difficulties Microsoft Office
Microsoft Access/Excel Microsoft Office
Microsoft Excel Help Software
microsoft excel 2010 Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 02:04 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33