Question

2
2. Prepare a worksheet containing the Name and marks in 3 subjects in
columns A, B, C and D respectively from columns 1 to column 6, the first row
contains the headings and the remaining rows contain data. Use your own
data.
Carry out the following operations on this worksheet.
1. Obtain the total marks of each student in column E.
2. Construct the 3D Pie diagram for the totals.
3. Display legend and data labels.
4. Display only those students' details that have total marks exceeding
180.

Answer 1

Answer:

you have to do it practically in ms excel