Neco 2018 Data Processing Question 19

An academic spreadsheet records a student's marks (out of 100) in cells B2:B6 and the corresponding credit units in cells C2:C6 as follows: | Subject | Marks (B) | Credits (C) | |---|---|---| | A | 78 | 3 | | B | 65 | 2 | | C | 58 | 4 | | D | 48 | 2 | | E | 42 | 3 | The grade point for each subject is assigned according to the table: - 70 - 100 → 5 points - 60 - 69 → 4 points - 50 - 59 → 3 points - 45 - 49 → 2 points - 40 - 44 → 1 point - below 40 → 0 point Write a single spreadsheet formula (using only built‑in functions and no helper columns) that computes the weighted grade point average (GPA) defined as \(\displaystyle \frac{\sum (\text{grade point} \times \text{credit})}{\sum \text{credit}}\). Then calculate the GPA for the data above and state whether the student qualifies for honors (GPA ≥ 4.5).