Question

Draw format of Excel sheet which calculates and displays the total marks of percentage of 10 student and 5 different subject also find the highest and the lowest total marks percentage. write all the formulas properly.​

Answer 1

Answer:

The percentage is calculated as the proportion per hundred. In other words, the numerator is divided by the denominator and the result is multiplied by 100. The percentage formula in Excel is = Numerator/Denominator (used without multiplication by 100). To convert the output to a percentage, either press “Ctrl+Shift+%” or click “%” on the Home tab’s “number” group.