Chapter 1 Sums and averages ・ MISSION 3
Mission 3: Count people and test takers
Task
In F1, count the people on the list. In F2, count the people with a score (the test takers).
F1fx
A
B
C
D
E
F
1
Name
Score
People
2
Emma
82
Test takers
3
Liam
Absent
4
Olivia
91
5
Noah
67
6
Ava
Absent
7
Lucas
75
8
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 3
Count people and test takers
In F1, count the people on the list. In F2, count the people with a score (the test takers).
A
B
C
D
E
F
1
Name
Score
People
2
Emma
82
Test takers
3
Liam
Absent
4
Olivia
91
5
Noah
67
6
Ava
Absent
7
Lucas
75
8
A
B
C
D
E
F
1
Name
Score
People
6
2
Emma
82
Test takers
4
3
Liam
Absent
4
Olivia
91
5
Noah
67
6
Ava
Absent
7
Lucas
75
8
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: F1: =COUNTA(A2:A7) F2: =COUNT(B2:B7)
COUNTA counts non-empty cells. COUNT counts only cells with numbers, so the text “Absent” is not counted.
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).