Computer Science, asked by sisodiadeepika4, 1 month ago

Write appropriate formula for calculating sum of marks of a student .

this is computer question not math question so give answers in computer ​

Answers

Answered by chaudharidipesh4406
2

Answer:

Shah is my favourite to get a job at

Answered by Anmol8432
2

While working on Microsoft Excel, there are a set of built-in features and functions to implement the mathematical operations. Percentage Calculator is one such function available in Excel.

Now, let us consider an option where you can calculate each student's total scores in the class and calculate the overall Percentage. View the following image, for better clarity.

Percentage-In-Excel-Method-1

For calculating the total number of marks of all students, apply the following formula.

=(F3+G3+H3+I3+J3+K3)

Percentage-In-Excel-Method-1-image-3

The formula above works for one student in row number 3. For implementing the same formula for all the rows, you can drag the cell as shown below.

Percentage-In-Excel-Method-1-image-4

Now, in the next stage, you will calculate the Percentage. The formula for calculating the Percentage is as follows.

Percentage = Marks Obtained / Total Marks

That is,

=(L3/M3)

Percentage-In-Excel-Method-5

You might wonder that the fraction is not multiplied by 100. This is because you will use the percentage option as shown in the image below.

-Percentage-In-Excel-Method-1-image-1

To apply the same formula to all the cells, you can drag the cell to all rows, as shown below.

-Percentage-In-Excel-Method-1-image-6

The Final Table looks like this:

Percentage-In-Excel-Method-1-image-20

Advancing, you will try the scenario of calculating the percentage variation in Excel.

Similar questions