Convert a range to an Excel Table, address it by name with structured references, and explain why a fixed range is the most common cause of a wrong total.
Every formula you write against A2:J315 is right until somebody adds row 316. A Table fixes that permanently, and it takes one keystroke.
0 XP
Step 1 of 6 · 1 point
Select any cell inside the sales data and convert the range to an Excel Table.
A
B
C
D
E
F
G
H
I
J
1
OrderID
Date
Branch
Rep
Category
Product
Qty
UnitPrice
Discount
LineTotal
2
4001
2026-01-05
Fairview
Priya Raghavan
Electrical
Romex 12-2 250ft
4
148.00
0.1
532.80
3
4002
2026-01-05
Fairview
Priya Raghavan
Electrical
Romex 12-2 250ft
5
148.00
0
740.00
4
4003
2026-01-06
Northgate
Marcus Ellery
Paint
Wood primer, 1gal
2
46.75
0.05
88.83
5
4004
2026-01-07
Northgate
Marcus Ellery
Plumbing
Ball valve 1/2in
1
9.25
0.05
8.79
6
4005
2026-01-07
Brookside
Danielle Okafor
Plumbing
Copper pipe 1/2in 10ft
1
31.40
0
31.40
7
4006
2026-01-08
Brookside
Danielle Okafor
Plumbing
Copper pipe 1/2in 10ft
1
31.40
0
31.40
8
4007
2026-01-08
Brookside
Danielle Okafor
Paint
Interior latex paint, 5gal
3
138.00
0.05
393.30
9
4008
2026-01-08
Brookside
Danielle Okafor
Tools
Cordless drill 18V
5
209.00
0.1
940.50
10
4009
2026-01-09
Fairview
Priya Raghavan
Plumbing
Ball valve 1/2in
3
9.25
0
27.75
11
4010
2026-01-09
Northgate
Marcus Ellery
Paint
Roller and tray set
6
14.20
0
85.20
12
4011
2026-01-09
Brookside
Danielle Okafor
Plumbing
Water heater element 4500W
6
24.10
0
144.60
13
4012
2026-01-10
Northgate
Marcus Ellery
Tools
Cordless drill 18V
1
209.00
0
209.00
14
4013
2026-01-10
Northgate
Marcus Ellery
Plumbing
Copper pipe 1/2in 10ft
4
31.40
0.05
119.32
Rows 1 to 14 of 315
Hold the modifiers, then press the last key. We read it straight from your keyboard.