Advanced spreadsheet questions often turn on the definition rather than the function name. An OR condition can count a record twice. A top-two list can exclude a tied candidate. An unweighted average of group averages can differ from the overall average.
Use the supplied support export to work through those distinctions. Each question states its tie or blank policy so the result can be checked. Keep output cells clear when a formula spills. LET can give repeated expressions a name, making a longer formula easier to inspect, but any equivalent formula that follows the requested rule is accepted. Check the source columns and the denominator before deciding the result is ready.