Need help, please

The solutions do not matchthe key given and not sure why.

Excel file:

Formulas

Key:

Check your work:

Rose Sayer has a 64.8% for current and final grade and a D; her ID is 129

Melanie Daniels has a C in her current grade but if she doesnt turn anything in, shed have a 16.7% in her final grade

Tommie DeVito has a 72.4 currently but if he doesnt make up his missed grade, his final grade would be a 56.5

0 Students have an A in the course

1 Student is Failing but just barely.

The mode grade is a C+, 6 Students have a C+

The average counting blanks as 0 for column D 2 is 74.9. The average noting counting zeros is 80.6.

The sum of all of the class ranks should equal 406

Darth Vader is second in the class.

Ace Ventura is 22nd.