Free practice
You just read about QUERY. Now type one.
Three QUERY questions, right here in the page. Type your formula, press Check, and you find out right away. No sign-up needed.
Question 1 of 3
Try it yourself
In A13, query the table for the Salesperson, the Region and the Revenue, in that order.
A
B
C
D
E
F
G
H
I
J
K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Date
Salesperson
Region
Product
Units
Revenue
Commission
1/5/2026
Sherlock Holmes
Baker Street
Listening Device
12
$239.88
$24.00
1/7/2026
Irene Adler
Scotland Yard
Forensic Chemistry Set
8
$360.00
$36.00
1/8/2026
Inspector Lestrade
Baker Street
Pocket Watch
15
$525.00
$52.50
1/10/2026
Sherlock Holmes
Baker Street
Field Binoculars
5
$325.00
$32.50
1/12/2026
Mycroft Holmes
Scotland Yard
Cipher Decoder
20
$570.00
$57.00
1/14/2026
Irene Adler
Whitehall
Magnifying Glass
25
$624.75
$62.50
1/15/2026
Inspector Lestrade
Scotland Yard
Listening Device
10
$199.90
$20.00
1/18/2026
Sherlock Holmes
Baker Street
Disguise Kit
3
$269.97
$27.00
1/20/2026
Mycroft Holmes
Whitehall
Brass Telescope
8
$336.00
$33.60
1/22/2026
Irene Adler
Scotland Yard
Lockpick Set
6
$330.00
$33.00
Exercise 1 result
Still working through the theory? The QUERY guide covers the same ground in writing.