Excel practice worksheets with answers

Includes learner instructions, teacher notes, four original workbooks and a versioned file manifest. The workbooks include answer sheets.

Use the same source online and in a workbook

Share this page as an assignment link, or download the pack and open README.txt. It contains four existing SheetTutor workbooks, TEACHER-NOTES.txt and a manifest with content versions, source links, answer cells and file hashes. Each workbook has Read me, Practice and Answers sheets for its original datasets.

Start in Practice 1. Read its row and column labels, enter formulas in the named answer cells and compare with the matching Answers sheet after attempting the task. The other Practice sheets change the source data. A useful formula should handle those cases too.

The browser lessons are free and can be opened without an account or an Excel installation. A downloaded XLSX file needs a compatible spreadsheet application. The lookup workbook uses XLOOKUP, which is not available in Excel 2016 or Excel 2019. The answer sheets are included for everyone; this is practice material, not a secure examination.

1. Keep the right references fixed

In the fixed-reference task, column B contains base prices, row 1 contains rate scenarios and G2 holds a fixed fee. Enter the formula in C2, then fill across and down. Lock the base-price column, rate row and fee cell separately.

For the starting data, C2 is 24 and E4 is 99. Checking both corners helps expose references that drift during filling. Use the changed Practice datasets before accepting a formula that happens to match one cell.

2. Count records with an inclusive threshold

Count records whose team is Blue, status is Open and age is at most 5 days. The starting answer in F6 is 4. A record exactly 5 days old qualifies; a 6-day record does not. The supplied lowercase blue/open row also qualifies under this matching policy.

Keep the age test in the criteria range that contains ages. A count of the whole team alone answers a different question.

3. Sum a date window without losing refunds

Sum paid East-region amounts from the inclusive start date to the exclusive end date. In the starting data, G7 is 430: 120 + 250 - 30 + 90. The negative refund stays in the sum. The record exactly at the end date and the record before the start are excluded.

Dates in this task are numeric serial values in the 1900 system. This is a window with both bounds, so it uses SUMIFS. For a single upper cutoff, the linked SUMIF date examples explain date-only values versus timestamps.

4. Separate an exact match from a missing ID

The lookup task retrieves prices using exact product IDs. For the starting requests, G2 is 5, G3 is 9 and G4 contains the text Not found. The lowercase request p-105 matches P-105 under this task policy.

The missing result is deliberate text, not a numeric zero or a spreadsheet error. Ask learners to explain which source row matched, which request had no match and whether the formula still works after switching datasets.

Check reasoning as well as one displayed answer

Ask learners to predict the qualifying rows or lookup match before calculating. After a passing attempt, switch the authored dataset and repeat. For the date task, discuss the refund and the row at the upper boundary; for the count task, discuss the exact threshold.

The browser checks use the existing independent rules and changed datasets. Saved progress is local to the current browser; this pack does not create an instructor account or collect class results. Choose your own assessment and collection process.

Share the version with the assignment

Use this guide URL as the reference and keep the downloaded manifest with the assignment. It identifies the lesson content versions and SHA-256 hashes of the included workbooks. Future downloads can be compared without assuming an older local copy has changed.

These sources and explanations are original SheetTutor material. No student data is included. Browser checks and workbook cache checks cover the supplied examples; native Excel and Google Sheets recalculation remain separate validation.

Try the idea

• Fill formulas with fixed references →
• Count records with several conditions →
• Sum amounts over a date window →
• Look up a price by exact ID →
• Single-cutoff SUMIF date examples →

References

• Microsoft: relative, absolute and mixed references ↗
• Microsoft: COUNTIFS ↗
• Microsoft: SUMIFS ↗
• Microsoft: XLOOKUP ↗

Examples and explanations are original. Source links describe the related Excel features; native Excel workbook testing is separate from browser learning checks.