excel sheet. Can you help and sh$0$ow me with an actually excel Create the following table in Excel.

Using your understanding of the basic functions of Excel and the VLOOKUP function

covered in lecture, calculate the Exam Average for each student as well as the average for

each assignment. The project is out of $10$ points. The exams are out of $100$ points. This

assignment will build upon your previous assignment formula. Again, make sure to

satisfy the following conditions:

$1.$ The lowest exam grade will be dropped.

$2.$ If the project is turned in with a grade of $8$ or higher it will increase the letter

grade to the next higher grade unless its an A in which case it remains an A$.$

$3.$ Rename the primary worksheet to Overview, then create another worksheet in the

workbook and call it Scores.

Student

ID Name Exam $1$ Exam $2$ Exam $3$ Project

$00001$

Swanson,

R$.100819010$

$00002$ Lahey, J$.6667558$

$00003$ May, J$.8074909$

$00004$

Belichick,

W$.9995998$

$00005$

Costanza,

G$.6075757$

$4.$ Add the table above to the Scores worksheet.

$5.$ Using the VLOOKUP function, setup the Overview worksheet to reference the

Scores worksheet to pull the necessary data.

$6.$ Create a table for the grade scale on the Scores worksheet. Utilizing this table,

Absolute References and the VLOOKUP function, calculate the Letter Grade for

each student on the Overview worksheet. Calculate the letter grade based on the

following grade scale:

a$.$ Exam Average $>=90$ is an A

b$.$ Exam Average $>=80$ is a B

c$.$ Exam Average $>=70$ is a C

d$.$ Exam Average $>=60$ is a D

e$.$ Exam Average $<60$ is an F

$7.$ Make sure there are no errors visible when the Overview worksheet is blank.

Student ID Name Project Exam $1$ Exam $2$ Exam $3$ Exam Average Letter Grade

Student $1$ Calculation Calculation

Student $2$ Calculation Calculation

Student $3$ Calculation Calculation

Student $4$ Calculation Calculation

Student $5$ Calculation Calculation

Average Calculation Calculation Calculation Calculation