Need help with Excel

[cmf21]

I'm trying to add the numbers in a column say 171 and find the average out of 195. I'm also supposed to round the number off to two decimal places but that's where I get stuck. So far I have =(SUM(C2:C13)/1300)*100 and don't know how to get the round function to work.

This is for an assigement for class where I have to create a spreedsheat that calculates my grades such as quizes, test, exams, and extra credit. They are all worth 25% of my sample grade. I also have to use the functions vlookup and min but don't know quite what they are and how they fit in. Also does anyone have any idea of how to calculate the extra credit in. (say 220/300)?

 

[jbod]

Format cells, Number>Decimal places 2

 

[cmf21]

Thanks. I think my teacher wanted the cell to have the round function built in but she'll only be looking at my print out with the right answers and won't be seeing the functions I used. Any ideas on the other stuff.

 

[jbod]

For Min, click on Fx button, highlight all column data and press OK.

Not sure how to figure Vlookup yet, I forget. Working on it though.

 

[jbod]

VLOOKUP

Lookup_value=(whatever you are looking up, highest grade or lowest grade for example)
Table_Array=highlight column
Col_Index_num=1,2, or 3 whatever column number your data is in.
Range Lookup=FALSE for exact number

I don't understand the question for the extra credit part. Can you give me more info?

 

[cmf21]

Thanks.