PING: Excel users ... using functions

[DeToxRox]

I am stumped on this question in my Excel class:

In this exercise, you are given a worksheet, grades.xlsx, which contains scores from five quizzes for a group of students. Each quiz is scored out of 100. Your task is to determine the final score for each student by taking the average over best three out of five quizzes. The formula(s) you write should automatically select the best three quizzes for each student. Hint: Use the worksheet function LARGE.

I am not sure where to even begin since functions are new to me. Any help is appreciated.

[Fighter of Foo]

LARGE says give me the xth largest number in a group.

so large(a1:e1, 3) where a1 through e1 are 7, 15, 8, 12, 3 would return 8 (8 being the third largest number.

I'll stop there since it's your homework

[DeToxRox]

Originally Posted by Fighter of Foo

LARGE says give me the xth largest number in a group.

so large(a1:e1, 3) where a1 through e1 are 7, 15, 8, 12, 3 would return 8 (8 being the third largest number.

I'll stop there since it's your homework

Touche! Appreciate the help man. Seems so easy now.

[FrogMan]

you can also hit the F1 key in Excel and you'll get some help there too

FM