Chapter 1 Sums and averages ・ MISSION 4
Mission 4: Highest and lowest score
Task
Show the highest score in E1 and the lowest score in E2.
E1fx
A
B
C
D
E
1
Name
Score
Highest
2
Emma
82
Lowest
3
Liam
58
4
Olivia
93
5
Noah
67
6
Ava
75
7
Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.
Chapter 1 ・ MISSION 4
Highest and lowest score
Show the highest score in E1 and the lowest score in E2.
A
B
C
D
E
1
Name
Score
Highest
2
Emma
82
Lowest
3
Liam
58
4
Olivia
93
5
Noah
67
6
Ava
75
7
A
B
C
D
E
1
Name
Score
Highest
93
2
Emma
82
Lowest
58
3
Liam
58
4
Olivia
93
5
Noah
67
6
Ava
75
7
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: E1: =MAX(B2:B6) E2: =MIN(B2:B6)
MAX returns the largest value and MIN the smallest. You do not need to sort; just pass the range.
To practice one function at a time:Function drillExcel function list
* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.
* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).