Answer the above question

Question 1

Answer · 2026-03-18T08:02:44.854Z

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.

Question 2

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.

Answer the above question

Still stuck on this one?

More Biology Questions