Chapter 1 Sums and averages ・ MISSION 1
Mission 1: Add up the sales
Task
In B6, find the total sales of the 4 branches.
B6fx
A
B
C
1
Branch
Sales
2
New York
1200
3
Chicago
980
4
Boston
1540
5
Denver
760
6
Total
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 startsSums and averages
Chapter 1 ・ MISSION 1
Add up the sales
In B6, find the total sales of the 4 branches.
A
B
C
1
Branch
Sales
2
New York
1200
3
Chicago
980
4
Boston
1540
5
Denver
760
6
Total
7
A
B
C
1
Branch
Sales
2
New York
1200
3
Chicago
980
4
Boston
1540
5
Denver
760
6
Total
4480
7
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =SUM(B2:B5)
SUM(range) adds up the numbers in the range. With a formula instead of a typed number, the total updates when the sales change.
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).