Spreadsheet Software Essentials
Grade 7
Write formulas to sort, filter, and calculate a class grade sheet. Complete the interactive challenge to master key computing concepts!
Spreadsheet Software Essentials
Timing05:00
Score100
Filter (≥):
Formulas: 0/3Targets: 0/3
ANAME | BMATH | CSCI | DENG |
|---|---|---|---|
| 2Alice | C2 | ||
| 3Bob | B3 | D3 | |
| 4Charlie | |||
| 5Diana | |||
| 6Statistical Target |
Math Peak=MAX(B2:B5)
--Highest Score
Sci Average=AVG(C2:C5)
--Mean Score
Eng Total=SUM(D2:D5)
--Total Points
Target Cell B6:Type =MAX(B2:B5) to find the top score in column B.