# Must Know Excel functions that solve 80% of your work: How to use Excel as gradebook

September 17, 2020

Suppose your class is devided into groups for a impromptu quiz competation for extra credit. And you as the TA needs to keep tracking of the scores.
Like this?
Or, this?

Wait! Before you actually do that, why not keep reading to find out the best solution with WPS college.

### Calculation of the toal- Summation

Let's keep using in class quiz as an example ðŸ‘‰

• Step 1: Prepare the table in advance

Record the score during the competation.

• Step 2: Using excel formula to quickly calculate the Total
1. Select the total columns of first team
2. Enter "=sum()"
3. Select all 6 socres for team 1
4. Press 'Return' on keyboard

Then you will have the total score for the first team!

• Double click and drag the plus arrow down the list to find total scores for all groups

### Rank Function

To be able to record ranking ASAP, the easist way is to quickly sort the data based on the 'Total' results. And it's so easy! Just keep on readingðŸ‘‰

• Step 1: Select the table
1. Find Data under the top menu bar
2. Select the option 'Sort'

• Step 2: Select correct parameter on the opration interface
1. For this example specifically, choose columnn P(The total column)
2. Select option 'Largest to smallest'

• Step 3: Enter rankings
Done!

Thank you for staying with WPS. Hope to see you in a bit!