Header Banner
WonderHowTo Logo
WonderHowTo
Discover the Best New iOS 18 Features
WonderHowTo Gadget Hacks Next Reality Null Byte
wonderhowto.mark.png
Gadget HacksNext RealityFood HacksNull ByteThe Secret YumiverseInvisiverseMacgyverismsMind HacksMad ScienceLock PickingDriverless
how to
Home
Microsoft Office

How to Make an Excel gradebook that removes the lowest score

Apr 27, 2010 11:58 PM
Table displaying student names, scores for quarters and tests, total scores, and grades in an Excel spreadsheet.

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.

Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Table displaying student names, scores for quarters and tests, total scores, and grades in an Excel spreadsheet.
Microsoft Office
how-to

How to Automatically Hide the Ribbon Menu System in Excel

Table displaying student names, scores for quarters and tests, total scores, and grades in an Excel spreadsheet.
Microsoft Office
Forum Thread

How to Make a Simple Report Card Template in Excel

Comments

No Comments Exist

Be the first, drop a comment!