Respuesta :
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%
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%
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