Tasks only — Excel Student Grades Practice

Open this HTML file in your browser, then choose Print or Save as PDF. No sign-in, script or upload is needed. This file contains questions and writing space, without the answer key.

Before you start

Use the unchanged default 180-row source file from the page above. Other file sizes require different ranges and totals.

Answers match the default 180-row file. Repeated names do not identify the same student; do not calculate a multi-subject student average from these rows.
Practice-only rules: A at 90, B at 80, C at 70, D at 60, otherwise F. Pass means score at least 60. These are exercise assumptions, not a school policy.
Attendance is a whole percentage: divide by 100 before applying Percentage format. Ranking is descending competition ranking: ties share a rank and later ranks are skipped.
Formulas use English function names and commas. Localized Excel may use different names and separators.

Excel Student Grades Practice — File, Tasks & Answers

Before you start

Confirm the data shape

Calculate the overall mean

Summarize each subject

Apply grade bands

Rank records with ties

Convert attendance correctly

Flag the practice pass rule

Reconcile band counts