Question

I am doing Microsoft Excel 2016 project, I need help with doing the formula for % of Grand Total? I need help what formula i should use and how you cam up with that formula. Step by step please.

Answer 1

the formula should be:
correct answers / total answers x 100 = percent.

first you have to find out the number of answers correct in the grand total. for example, let's say someone got 64 answers correct on a test of 75.

then you divide those numbers:

64 / 75 = 0.8533333

once you have that number. you need to turn it from a decimal to a percentage. to do this, you multiply by 100.

0.8533333 x 100 = 85.33333

this means if someone got 64 questions correct on a test of 75, their total in percentage would be 85.33%

Answer 2

you should first sum up grand total

by using sum formula

the exact formula to sum up is =(sum(cell range))

cell range consists of cells you want to get the total from

after getting sum you should

use percentage formula

or you can do the same by following formula

=(grand total/total number)*100

this is formula for percentage

percentage=(grand total/total number)*100