Question 1 of 10
Look at all that data on development indicators! It would be easier to analyze with a pivot table.
Click the "Insert" tab, then click "Pivot Table" and click "ok" on the Create Pivot Table dialog box.
Note: If you don't have Excel, you can follow along on this version, though some functionality may be a bit different.
Press Check Answer to continue.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
Pivot Tables 1 - Free Excel Practice Online
This free, interactive exercise teaches you Pivot Tables 1 in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Tables track and works right in your browser - no Excel install, no download, and no signup.
Practising Pivot Tables 1 this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this Pivot Tables 1 lesson
- Download this file to get started with pivot tables!Look at all that data on development indicators! It would be easier to analyze with a pivot table.Click the "Insert" tab, then click "Pivot Table" and click "ok" on the Create Pivot Table dialog box.Note: If you don't have Excel, you can follow along on this version, though some functionality may be a bit different.Press Check Answer to continue.
- On the "PivotTable Fields" pane on the right side, drag Country Name to the Rows box.Drag 2018 to the Values box.Drag Indicator Name to the Filters Box.Press Enter to continue.
- At the top of the pivot table, select the Indicator Name drop-down and choose Access to Electricity. Right click anywhere in the table, click Sort, then sort smallest to largest. Which country had 11.024525194 for 2018?
- Switch the indicator name to GDP. For countries where GDP is not blank, which country's GDP is the lowest in 2018?
- Switch the indicator name to International Tourism and sort largest to smallest. Which country had the most visitors in 2018?
- Switch the indicator name to Military Expenditure and sort largest to smallest. Which country had the largest percentage of military expenditure in 2018?
- In the PivotTables Fields pane, un-check the box for 2018 and check the box for 2000. Sort from largest to smallest Which country had the largest percentage of military expenditure in 2000?
- Change the Indicator Name to Access to Electricity and sort from smallest to largest.In which country did 67.3% of the population have access to electricity in 2000?
- In which country did 77.5% of the population have access to electricity in 2005?
- In which country did 99.8% of the population have access to electricity in 2005?
Pivot Tables 1 practice - FAQ
How do I practice Pivot Tables 1 in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the Pivot Tables 1 exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this Pivot Tables 1 lesson?
This lesson covers Pivot Tables 1 as part of the Tables track. You practice the syntax step by step until it becomes muscle memory you can use at work.