SHEETTUTOR - TEACHER NOTES AND ANSWER CHECKPOINTS

Suggested sequence: fixed references, conditional counts, date-window sums,
then exact lookups. Adapt the order to the group; no timing is promised.
Ask learners to explain their qualifying rows or references, not just a total.
Browser grading uses the existing task rules and changed authored datasets.
Saved browser progress is local and is not a teacher reporting service.

Answer caches below are checked against the independent authored task rules.
This packaging check does not certify native Excel or Google Sheets execution.
All data and explanations are original SheetTutor material. Existing site
terms apply; free access is not an open-source or open-content licence.

Fill formulas across and down with fixed references - content 2
Source: https://sheettutor.top/learn/absolute-cell-references
Starting-data formula answers:
C2: =$B2*(1+C$1)+$G$2
D2: =$B2*(1+D$1)+$G$2
E2: =$B2*(1+E$1)+$G$2
C3: =$B3*(1+C$1)+$G$2
D3: =$B3*(1+D$1)+$G$2
E3: =$B3*(1+E$1)+$G$2
C4: =$B4*(1+C$1)+$G$2
D4: =$B4*(1+D$1)+$G$2
E4: =$B4*(1+E$1)+$G$2

Price scenarios - Answers 1
{"C2":24,"D2":25,"E2":27,"C3":55.5,"D3":58.00000000000001,"E3":63,"C4":87,"D4":91,"E4":99}

New prices and rates - Answers 2
{"C2":17,"D2":17.96,"E2":18.799999999999997,"C3":40,"D3":42.800000000000004,"E3":45.25,"C4":115,"D4":123.80000000000001,"E4":131.5}

Zero fee and a discount - Answers 3
{"C2":0,"D2":0,"E2":0,"C3":22.5,"D3":25,"E3":31.25,"C4":180,"D4":200,"E4":250}

Count records that meet several conditions - content 3
Source: https://sheettutor.top/learn/countifs-multiple-criteria
Starting-data formula answers:
F6: =COUNTIFS(A2:A9,F2,B2:B9,F3,C2:C9,"<="&F4)

Support tickets - Answers 1
{"F6":4}

Response queue - Answers 2
{"F6":3}

No matching team - Answers 3
{"F6":0}

Sum amounts that meet several conditions - content 3
Source: https://sheettutor.top/learn/sumifs-multiple-criteria
Starting-data formula answers:
G7: =SUMIFS(D2:D9,B2:B9,G2,C2:C9,G3,A2:A9,">="&G4,A2:A9,"<"&G5)

October paid sales - Answers 1
{"G7":430}

November with a refund - Answers 2
{"G7":425}

No matching region - Answers 3
{"G7":0}

Look up a price by an exact ID - content 2
Source: https://sheettutor.top/learn/exact-match-lookup
Starting-data formula answers:
G2: =XLOOKUP(F2,$A$2:$A$7,$C$2:$C$7,"Not found",0)
G3: =XLOOKUP(F3,$A$2:$A$7,$C$2:$C$7,"Not found",0)
G4: =XLOOKUP(F4,$A$2:$A$7,$C$2:$C$7,"Not found",0)

Find catalogue prices - Answers 1
{"G2":5,"G3":9,"G4":"Not found"}

Updated catalogue - Answers 2
{"G2":11,"G3":15,"G4":"Not found"}

Repeated and typed IDs - Answers 3
{"G2":14,"G3":21,"G4":0}

BOUNDARY DISCUSSION
- Fixed references: C2=24 and E4=99 in the first dataset. The base-price
  column, scenario row and fixed-fee cell have different locking rules.
- COUNTIFS: the first F6 is 4. The 5-day record and lowercase blue/open
  record qualify; the 6-day record does not.
- SUMIFS: the first G7 is 430 = 120 + 250 - 30 + 90. Retain the refund;
  exclude the row exactly at the exclusive end and the row before the start.
- Lookup: the first G2:G4 values are 5, 9 and the text "Not found".
  A missing-result label is not numeric zero or an error value.

Keep manifest.json with your assignment. It records exact workbook hashes
and lesson versions. Share the guide URL for the current online exercises.
