AutoSave ⌄⌄⩡SUM, AVERAGE, MIN, MAX, COUNT.xlsx ⛉ C1 ⌄ Search─▢✕File
⇪ Share ⌄Font⌟
Number⌟
Styles
⌄⌄⋮⌃
Type = to start a formula. While typing a formula, click a cell to add its address. F4 adds the $ signs.
| A | B | C | D | E | F | G | H | I | J |
|---|
| 1 | Subject | Test 1 | Test 2 | | | | | | | |
|---|
| 2 | Maths | 68 | 72 | | | | | | | |
|---|
| 3 | English | 74 | 70 | | | | | | | |
|---|
| 4 | Life Sciences | 59 | 48 | | | | | | | |
|---|
| 5 | Accounting | 81 | 85 | | | | | | | |
|---|
| 6 | Geography | 65 | 66 | | | | | | | |
|---|
| 7 | | | | | | | | | | |
|---|
| 8 | Total | | | | | | | | | |
|---|
| 9 | Average | | | | | | | | | |
|---|
| 10 | Highest | | | | | | | | | |
|---|
| 11 | Lowest | | | | | | | | | |
|---|
| 12 | How many | | | | | | | | | |
|---|
| 13 | | | | | | | | | | |
|---|
| 14 | | | | | | | | | | |
|---|
| 15 | | | | | | | | | | |
|---|
| 16 | | | | | | | | | | |
|---|
| 17 | | | | | | | | | | |
|---|
| 18 | | | | | | | | | | |
|---|
| 19 | | | | | | | | | | |
|---|
| 20 | | | | | | | | | | |
|---|
| 21 | | | | | | | | | | |
|---|
| 22 | | | | | | | | | | |
|---|
‹›+
