Answer the above question

Step 1: Create "Student_Data" worksheet and enter data.

• Open a new Excel workbook. Rename "Sheet1" to Student_Data.
• Enter the provided data into cells A1:F6:
  • A1: Adm No, B1: Name, C1: Course, D1: Gender, E1: Fee Paid, F1: Date Paid
  • A2: 101, B2: John, C2: ICT, D2: $M$, E2: 19000, F2: 01-Jan-2023
  • A3: 102, B3: Mary, C3: Commerce, D3: $F$, E3: 15000, F3: 15-Jan-2023
  • A4: 103, B4: Peter, C4: ICT, D4: $M$, E4: 20000, F4: 20-Jan-2023
  • A5: 104, B5: Jane, C5: Arts, D5: $F$, E5: 12000, F5: 25-Jan-2023
  • A6: 105, B6: Paul, C6: Commerce, D6: $M$, E6: 16000, F6: 30-Jan-2023

Step 2: Create "Fee_Analysis" worksheet.

• Rename "Sheet2" to Fee_Analysis.

Step 3: Enter column headers in "Fee_Analysis".

• In cell A1, enter Course.
• In cell B1, enter Total Fee Paid.

Step 4: Use the SUMIF function to calculate total fees per course.

• In cell A2, enter ICT.
• In cell A3, enter Commerce.
• In cell A4, enter Arts.
• In cell B2, enter the formula: =SUMIF(Student_Data!C2:C6, A2, Student_Data!E2:E6)
  • This formula sums the values in Student_Data!E2:E6 (Fee Paid) where the corresponding values in Student_Data!C2:C6 (Course) match the value in A2 (ICT).
• In cell B3, enter the formula: =SUMIF(Student_Data!C2:C6, A3, Student_Data!E2:E6)
• In cell B4, enter the formula: =SUMIF(Student_Data!C2:C6, A4, Student_Data!E2:E6)

Step 5: Format the "Total Fee Paid" column.

• Select cells B2:B4.
• Right-click and choose "Format Cells".
• Go to the "Number" tab, select "Currency", and choose a suitable symbol (e.g., $). Set decimal places to 0. Click OK.

Step 6: Create a Pie Chart.

• Select the data range A1:B4 (including headers).
• Go to the "Insert" tab.
• In the "Charts" group, click "Insert Pie or Doughnut Chart" and select "Pie".
• Excel will generate a pie chart showing the fee distribution by course.
• You can then customize the chart title, data labels, and legend as needed.