SHEETTUTOR - EXCEL PRACTICE TEACHING PACK

Free browser practice and original starter workbooks with answer sheets.
Guide: https://sheettutor.top/guides/excel-practice-teaching-pack

1. Pick a task below and open its workbook from the workbooks folder.
2. Read the Read me sheet. Begin in Practice 1 and enter formulas in the
   stated answer cells. Each Practice sheet has its own starting data.
3. Predict which records or references matter before calculating.
4. Compare with the corresponding Answers sheet after your attempt, then
   switch to the other Practice datasets and try the same rule again.

You can also use each browser lesson without signing up or installing Excel.
Downloaded XLSX files need a compatible spreadsheet application. The lookup
workbook uses XLOOKUP, unavailable in Excel 2016 and Excel 2019. Answers are
included for everyone: this is a practice pack, not a secure examination.
No learner data or central class gradebook is included.

1. Fill formulas across and down with fixed references
Fill C2:E4 with base price × (1 + rate) + fixed fee. Use the base in column B, the rate in row 1 and the fee in G2.
File: workbooks/absolute-cell-references.xlsx
Answer cells: C2, D2, E2, C3, D3, E3, C4, D4, E4
Browser lesson: https://sheettutor.top/learn/absolute-cell-references

2. Count records that meet several conditions
In F6, count rows matching the team in F2, status in F3 and maximum age in F4.
File: workbooks/countifs-multiple-criteria.xlsx
Answer cells: F6
Browser lesson: https://sheettutor.top/learn/countifs-multiple-criteria

3. Sum amounts that meet several conditions
In G7, total amounts where region and status match G2:G3 and the date is at least G4 but before G5.
File: workbooks/sumifs-multiple-criteria.xlsx
Answer cells: G7
Browser lesson: https://sheettutor.top/learn/sumifs-multiple-criteria

4. Look up a price by an exact ID
Fill G2:G4 with the price for each ID in F2:F4. Use an exact match, return the first match, and show Not found when no ID matches.
File: workbooks/exact-match-lookup.xlsx
Answer cells: G2, G3, G4
Browser lesson: https://sheettutor.top/learn/exact-match-lookup
