Calculate the average score for each student and the overall lowest score across all subjects, rounding averages to the nearest whole number.

Assume the scores are in columns C, D, E, and F, starting from row 2. The average score column will be G.

• Formula for Liam (S012) in cell G2: $$=\text{ROUND}(\text{AVERAGE}(\text{C2:F2}),0)$$
• Calculations:
  • Liam (S012): $(55+53+50+58)/4 = 216/4 = 54$. Rounded: $\boxed{54}$
  • Maria (S013): $(72+70+68+75)/4 = 285/4 = 71.25$. Rounded: $\boxed{71}$
  • Nthabiseng (S014): $(81+85+79+80)/4 = 325/4 = 81.25$. Rounded: $\boxed{81}$
  • Oliver (S015): $(60+59+58+62)/4 = 239/4 = 59.75$. Rounded: $\boxed{60}$
  • Priya (S016): $(88+90+85+87)/4 = 350/4 = 87.5$. Rounded: $\boxed{88}$
  • Quinn (S017): $(47+49+46+44)/4 = 186/4 = 46.5$. Rounded: $\boxed{47}$
  • Rudo (S018): $(69+67+66+65)/4 = 267/4 = 66.75$. Rounded: $\boxed{67}$
  • Sipho (S019): $(52+50+48+54)/4 = 204/4 = 51$. Rounded: $\boxed{51}$
  • Thabo (S020): $(76+74+73+72)/4 = 295/4 = 73.75$. Rounded: $\boxed{74}$

Assume the scores are in the range C2:F10.

• Action: Merge cells A22:B22 and type "Lowest score". Left align the text.
• Formula: $$=\text{MIN}(\text{C2:F10})$$
• Result: The lowest score is $\boxed{44}$.

Assume the scores are in the range C2:F10.

• Action: Merge cells A23:B23 and type "Highest score". Left align the text.
• Formula: $$=\text{MAX}(\text{C2:F10})$$
• Result: The highest score is $\boxed{90}$.

Assume the "Average score" is in column G. The "Grades Status" column will be H.

• Formula for Liam (S012) in cell H2 (using IFS function): $$=\text{IFS}(\text{G2}\ge 75, \text{"Distinction"}, \text{G2}\ge 65, \text{"Merit"}, \text{G2}\ge 50, \text{"Pass"}, \text{G2}<50, \text{"Fail"})$$
• Grades Status for each student:
  • Liam (Average 54): $\boxed{\text{Pass}}$
  • Maria (Average 71): $\boxed{\text{Merit}}$
  • Nthabiseng (Average 81): $\boxed{\text{Distinction}}$
  • Oliver (Average 60): $\boxed{\text{Pass}}$
  • Priya (Average 88): $\boxed{\text{Distinction}}$
  • Quinn (Average 47): $\boxed{\text{Fail}}$
  • Rudo (Average 67): $\boxed{\text{Merit}}$
  • Sipho (Average 51): $\boxed{\text{Pass}}$
  • Thabo (Average 74): $\boxed{\text{Merit}}$

Section B: Data Formatting

• Select the header row (e.g., A1:F1 or A1:H1 if average and status columns are added).
• Apply Bold formatting.
• Set Centre Align.
• Set Font size to 12pt.

• Select the entire data range (including headers and all calculated columns).
• Go to "Format as Table" or "Table Design" options.
• Choose a Dark Green table style, such as "Table Style Medium 4" or any suitable green option.

• Insert a new row above the first row of the existing data.
• In cell A1, type "BSc 1st year Final Marks".
• Set the Font size to 14pt.
• Apply Bold formatting.
• Merge and centre align cells A1 through I1.

Section C: Data Analysis

• Select Data: Highlight the "Name" column (B2:B10) and the four subject score columns (C2:F10) for the 9 students. (Assuming the 1st 10 students refers to all 9 students listed).
• Insert Chart: Go to the "Insert" tab in your spreadsheet software.
• Choose Chart Type: Select "Column Chart" and then choose the "2D Column" option.
• Customize (if needed): Ensure the chart displays student names on the horizontal axis and subject scores as columns.