Question 1 of 10
| 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 |
SUM Functions Skill Summary - Free Excel Practice Online
This free, interactive exercise teaches you SUM Functions Skill Summary 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 SUM Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising SUM Functions Skill Summary 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 SUM Functions Skill Summary lesson
- Use SUMIF to find the total number of electoral votes for states with MORE THAN 15 Democratic Congressional Seats
- Use SUMIFS to find the total number of electoral votes for states with MORE THAN 15 Democratic Congressional Seats AND FEWER THAN 10 Republican Congressional Seats
- Use SUM to find the total number of electoral votes for all 6 states
- Use SUMIF to find the total sum of Democratic Congressional Seats for states with MORE THAN 10 Democratic Congressional Seats
- Use SUMIF to find the total sum of Democratic Congressional Seats for states that end with "a"
- Use SUMIF to find the total sum of Democratic Congressional Seats for states that DO NOT end with "a"
- Use SUM to find the total number of Republican seats for all 6 states
- Use SUMIF with wildcard matching to get the total sum of electoral votes for states with exactly 8 characters in their name
- What would =SUMIF(A2:A7, "????????", B2:B7) return?
- What would =SUMIF(A2:A7, "?????", B2:B7) return?
SUM Functions Skill Summary practice - FAQ
How do I practice SUM Functions Skill Summary 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 SUM Functions Skill Summary 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 SUM Functions Skill Summary lesson?
This lesson covers SUM Functions Skill Summary as part of the SUM Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.