what formula would you use on Microsoft Excel?

Question

i have to figure out my grade when my test score average is 30% of my total grade and my assignments average is 70%.

test score average-93%
assignments- 100%

i know this is a simple calculation, I am learning how to use Excel for future endeavors-this is just what i need to know to finish up my homework!

Answer 1

93x.3=cell a1
100x.7=cell b1
c1=a1+b1


or =((93*.3)+(100*.7))

Answer 2

.3 times 93% + .70 times 100

Answer 3

Put average test scores in one cell and average assignment score in another - let's say cells A5 and B5.

Then your answer cell content would be:

=((.3*A5) + (.7*B5))

To add a step, keep your individual test and assignment scores in two columns, and at the end of each column, use the average function. Make those two cells the ones you refer to. That way, you can add a new test or assignment score and automatically update your total grade.

Answer 4

Well since you already have the averages figured out you don't really need excel to figure this out since it is just an algebra question. But if you wanted to do this in excel it would be:
=.30*()+ .70*()

if you have all of your individual test score percents in cells A2 through A5 and you have your assignment percents in cells B2 through B10 then you could modify the formula to look something more like:

=.3*(AVERAGE(A2:A5)) + .70*(AVERAGE(B2:B10))

Then when you add more info you can jut change the average range and you don't have to recalculate your averages each time. You can make it as complicated as you want/need.

Answer 5

It would take more time to turn on the computer and input the number than to do it on paper, anyway Excel will work very nice for what you want but you need to know basic math for what you want, Microsoft has a Excel tutorial just for what you want....http://www.microsoft.com/education/ManagingGrades.mspx