Excel 2007 : Formula Help!!-compute the student’s test average

[Cpena1026]

I am doing a Project for one of my classes and this is what I have to do:

Click in cell G4 and type the formula to compute the student’s test average, and drop the lowest grade if the student has taken all five exams.

What Formula do I use?

Also, I need to Create a formula in cells J3 through J18 that calculates the students’ grade and displays
the word Pass when students are taking the course for credit only and pass.

I know you do not have all the information and numbers infront of you but anything will help.

Please help! This project is killing me, I've been infront of the computer for hours trying to figure it out

[Paul]

Cpena,

Please take a moment to read the forum rules, then start a new post with a proper thread title.