How to calculate percentage of marks in Excel?

8 Views | Posted 12 months ago

1 Answer

Answered by

8 months ago

You can make calculations like calculating the percentage of marks in Excel sheet using certain formulas. To calculate the percentage of marks in Excel, the formula that you will is:

Formula for the Percentage of Marks in Excel = (Obtained Marks / Total Marks) * 100

The steps involved in calculating the percentage of marks in Excel sheet are given below.

Set up your data:
- Create separate columns for Subject, Obtained Marks, and Total Marks.
- Input the corresponding data for each subject in these columns.
Create a column for Percentage: Add a column named "Percentage."
Apply the percentage calculation formula for Excel:
- In the first cell of the

...more

You can make calculations like calculating the percentage of marks in Excel sheet using certain formulas. To calculate the percentage of marks in Excel, the formula that you will is:Formula for the Percentage of Marks in Excel = (Obtained Marks / Total Marks) * 100The steps involved in calculating the percentage of marks in Excel sheet are given below.<ul><li>Set up your data:<ul><li>Create separate columns for Subject, Obtained Marks, and Total Marks.</li><li>Input the corresponding data for each subject in these columns.</li></ul></li><li>Create a column for Percentage: Add a column named "Percentage."</li><li>Apply the percentage calculation formula for Excel:<ul><li>In the first cell of the "Percentage" column, enter the following formula (adjust cell references as needed):<ul><li>= (B2/C2)*100</li><li>Here, B2 is the cell containing the obtained marks for the first subject, and C2 is the cell containing the total marks for the same subject.</li></ul></li></ul></li><li>Copy the formula: Copy the formula down the "Percentage" column for all subjects.</li><li>Format as percentage:<ul><li>Select the entire "Percentage" column.</li><li>Click on the percentage format button in the "Number" group on the Home tab.</li></ul></li></ul>For example, the percentage of marks calculated by applying the above formula in Excel will give results as in the table below. <table dir="ltr" border="1" cellspacing="0" cellpadding="0"><colgroup><col style="width: 25%;" width="100"><col style="width: 25%;" width="83"><col style="width: 25%;" width="143"></colgroup><tbody><tr><th colspan="4">Calculation of Percentage of Marks in Excel</th></tr><tr><th>Subject</th><th>Obtained Marks</th><th>Total Marks</th><th style="width: 25%;">Percentage</th></tr><tr><td>Math</td><td>85</td><td>100</td><td>85%</td></tr><tr><td>Science</td><td>72</td><td>100</td><td>72%</td></tr><tr><td>English</td><td>90</td><td>100</td><td>90%</td></tr></tbody></table>

0 Upvotes 0 Downvotes

Similar Questions for you

Which Indian actress went to Oxford?

Priya Garg

The Indian actress who went to the Oxford University is Soha Ali Khan. Soha Ali Khan completed a study in Modern History from the Balliol College of Oxford University

What is Oxford University known/famous for?

Jiya Arora

University Oxford is famous for its academic excellence, world-class research, universities & tutorial system. It's one of world's the oldest universities known for its groundbreaking research work like COVID-19 vaccine & conventional teaching style.

Which is the best field after BSc biotechnology?

Priya Garg

The best field after BSc Biotechnology depends on your interests and aspirations. However, top areas include Pharmaceuticals (drug discovery, QA/QC), Clinical Research ( CRA, data management), Bioinformatics, Agricultural Biotech and Environmental Biotech. Students aiming for specialised roles go for a master's degree like M.Sc, M.Tech or MBA in biotechnology or a similar field or the one that adds value to their resume.

What are the course requirements for a Post Study Work Visa UK?

Jiya Arora

Along with the essential course completion requirements, your application for the Graduate Visa in UK depends on the following aspects of your course as well:

the university or your course provider
how long did you study in the UK
what kind of a course you studied - bachelor's, master's or any doctoral course

Can I study on a post study work visa in UK?

Rashmi Shekhar

No, studying on a Graduate Visa in UK is generally not possible. Students can do so only if their chosen course is not eligible for a student visa in the UK. If you choose a course that is eligible for a student visa then you can apply for the extension of your UK student visa instead. The courses allowed on a Grdauate visa may include professional, recreational or online courses like short courses or skills development that are not covered by a full Student visa.