Question 1 of 10
=AVERAGE(B2:B7)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | State | Electoral Votes | Democratic Congressional Seats | Republican Congressional Seats |
| 2 | California | 55 | 47 | 6 |
| 3 | Texas | 38 | 13 | 25 |
| 4 | New York | 29 | 23 | 5 |
| 5 | Florida | 29 | 13 | 16 |
| 6 | Illinois | 20 | 15 | 5 |
| 7 | Pennsylvania | 20 | 10 | 10 |
AVERAGE Function - Free Excel Practice Online
This free, interactive exercise teaches you AVERAGE Function 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 Statistical Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising AVERAGE Function 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 AVERAGE Function lesson
- The AVERAGE functions returns the average of a group of cells. To get the average number of electoral votes among the top 6 states, type =AVERAGE(B2:B7)
- Use AVERAGE to find the average number of DEMOCRATIC Congressional Seats for the top 6 states
- Use AVERAGE to find the average number of REPUBLICAN Congressional Seats for the top 6 states
- Use AVERAGE to find the average number of electoral votes for the top 4 states
- Use AVERAGE to find the average number of Republican congressional seats for the top 3 states
- What would =AVERAGE(D2) return?
- What would =AVERAGE(1, 1, 1, 1, 1, 1, 1) return?
- What would =AVERAGE(50, 100, 150) return?
- Use AVERAGE to find the average number of electoral votes for Texas, Florida, and Pennsylvania
- Use AVERAGE to find the average number of Republican Congressional Seats for California, New York, and Illinois
AVERAGE Function practice - FAQ
How do I practice AVERAGE Function 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 AVERAGE Function 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 AVERAGE Function lesson?
This lesson covers AVERAGE Function as part of the Statistical Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.