Average the five scores
What is the average of the scores in B2:B6?
Formula: =AVERAGE(B2:B6) → 75.2
Hands-on Excel exercises
Excel Exercises with Answers
Try Excel exercises with answers in a live spreadsheet. Practice formulas, lookups, cleanup, PivotTables, and charts with guided solutions.
A useful answer does more than reveal the final formula. It shows how to read the question, choose the right cells, select a function, and check whether the result makes sense. These Excel exercises with answers are organized around that process. First use the live spreadsheet to change inputs and formulas. Then open a linked task and let the checker tell you whether your workbook actually meets the goal.
The set covers common work: totals, logical tests, conditional sums, exact lookups, error handling, data cleanup, PivotTables, and charts. The tasks are drawn from existing FormulaCamp lessons rather than simplified text quizzes. That means you work with a sheet, not a multiple-choice description of one. Access badges beside the links are computed from the lessons themselves and stay accurate if the Free course boundary changes.
After attempting the tasks, compare your reasoning with the worked sections below. Several formulas can sometimes produce the same visible number, so the steps emphasize ranges, match behavior, and quick validation checks. Treat the solution as a method you can reuse on a different table, not as an answer to copy once.
Your turn
Your turn: in F2, count the scores that are at least 70.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Learner | Score | ||||
| 2 | Ari | 68 | ||||
| 3 | Bea | 91 | ||||
| 4 | Chen | 75 | ||||
| 5 | Dina | 54 | ||||
| 6 | Eli | 88 |
Not yet solved.
Answer: =COUNTIF(B2:B6,">=70")
Related exercises
Open a task in its lesson.
- Fill in the totals for the other items (D3:D6).
- In C7, calculate how many items were bought in total.
- In F2:F4, calculate each manager's revenue.
- In F2, calculate the total of Emma's deals in Boston.
- In G2:G4, look up the item price.
- In D2:D6, calculate the average sale (revenue / units sold). Where there were no sales, show 0 instead of an error.
- In G2:G6, turn the text in column A into numbers (some have spaces at the edges).
- Build a second PivotTable: the average deal amount by city, with the result in F8.
- Build a line chart of revenue and expenses together (A1:C7).
Worked answers
Try the spreadsheet first, then compare your formula and result.
Find the highest score
What is the highest score in B2:B6?
Formula: =MAX(B2:B6) → 91
Count scores below 70
How many scores in B2:B6 are below 70?
Formula: =COUNTIF(B2:B6,"<70") → 2
Frequently asked questions
Are the answers shown before I try?
The worked methods are available on the page, but the linked lesson checker lets you attempt each spreadsheet task before reviewing a solution.
Do the exercises accept only one formula?
Each task states the required result, and some also name the function or feature to use. Follow that instruction, then use the worked answer to compare formulas.
Are there beginner and advanced exercises?
Yes. The list starts with basic formulas and continues through multi-criteria calculations, cleanup, PivotTables, and charts.