Course
Excel table exercises
Five exercises, from creating a table to calculated columns, structured references and filters. Each sheet is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Turn the orders into a table
Click any cell of the orders, press Ctrl + T (or click Table above the formula bar), check that the range is A1:E9, keep My table has headers ticked and click OK.
| Region | Product | Qty | Price | Total |
| North | Laptop | 2 | 900.00 | 1,800.00 |
| South | Monitor | 3 | 250.00 | 750.00 |
| East | Keyboard | 10 | 45.00 | 450.00 |
| North | Monitor | 4 | 250.00 | 1,000.00 |
| West | Laptop | 1 | 900.00 | 900.00 |
| South | Keyboard | 6 | 45.00 | 270.00 |
| East | Laptop | 3 | 900.00 | 2,700.00 |
| South | Monitor | 2 | 250.00 | 500.00 |