You're a registrar finalizing semester grade reports. Columns A–B hold 12 students and their numeric grades. The standard 5-band rubric:
| Score range | Letter |
|---|
| 90–100 | A |
| 80–89 | B |
| 70–79 | C |
| 60–69 | D |
| Below 60 | F |
Your task:
- In column C (Letter Grade), write an IFS chain (or SWITCH) that returns the right letter for each student.
- The formula must drag-fill from C2 → C13.
Graded cells: C3 (76 → C), C6 (55 → F), C7 (95 → A).
Open this problem on a desktop to attempt it.