Scribd
Upload
96 views2 pages

Computer Application Assignment 2

The document provides instructions for creating a table in MS Excel to record student marks across three subjects. It details steps to calculate the average marks, total marks, and percentage for each student by adding new columns and using specific functions. Finally, it instructs to save the Excel file after completing the tasks.

Uploaded by

Pritom Banerjee
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
96 views2 pages

Computer Application Assignment 2

The document provides instructions for creating a table in MS Excel to record student marks across three subjects. It details steps to calculate the average marks, total marks, and percentage for each student by adding new columns and using specific functions. Finally, it instructs to save the Excel file after completing the tasks.

Uploaded by

Pritom Banerjee
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Assignment: II

1. Prepare the following table in MS Excel

Sl No Roll_No Sub1(100) Sub2(100) Sub3(100)

1 001 53 45 59

2 002 85 82 65

3 003 87 91 81

4 004 66 75 95

5 005 92 56 90

i). Add a new column which contains the average marks of each student.
ii). Find the total marks of each student.
iii). Find the percentage of marks of each student by adding a new column percentage.

Answer : P1
Steps-
1. Select & copy the table from the MS Word document & paste it in MS Excel.
2. Add a new column in cell F1. Set the column heading name as i) Average Marks.
3. In the cell F2, Write the following function to calculate average –
=AVERAGE(C2:E2). Drag the fill handle icon (the + sign in the below right corner of
the cell) down till F6 cell. The result will automatically be generated.
4. In the similar way, add a new column in G1 cell & set the column heading name as ii)
Total Marks.
5. In G2 cell, write the function =SUM(C2:E2). In the previous way, drag the fill handle
icon (the + sign in the below right corner of the cell) down till G6 cell. The result will
automatically be generated.
6. Similarly, in H1 cell, add a new column & name it as iii) Percentage.
7. In H2 cell, write the following function =G2*100/300 to calculate percentage value.
8. In the similar way mentioned above, drag the fill handle icon (the + sign in the below
right corner of the cell) down till H6 cell. The result will automatically be generated.
9. Save the file by pressing ctrl & S simultaneously or clicking the save button in File
tab.

P2

You might also like