Complete excel steps.

Activity 1:

Create a table the includes the following fields: Name

Score 1

Result 1

Provide 5 records with the following data:

Steve, 77

Tony, 90

Carol, 95

Natasha, 82

Bruce, 59

Use an IF statement to show if they have an A, B, C, D, or F given the following scale: A 90 or above

B 80-89 C 70-79 D 70-69 F Below 60

Activity 2:

Create three new columns in the table that includes

Score 2

Results 2

Scored a C or higher on both

Provide 5 records with the following data:

Steve, 60

Tony, 86

Carol, 92

Natasha, 44

Bruce, 46

Use an IF statement to show if they have an A, B, C, D, or F given for the second results the following scale:

A 90 or above B 80-89 C 70-79

D 70-69

F Below 60

Use the AND function to show if the student scored a C or higher in both scores.

Activity 3:

Create a new column in the table that is titled Score a C or higher on either

Use the OR function to show if the student scored a C or higher on either score.

Activity 4:

Create a new column in the table that is titled Not Score Well

Use the NOT function to show if the student did not score a C or higher in both scores.

Activity 5:

Create two new columns in the table that is titled

Good, Bad, and Yikes for Score 1

Good, Bad, and Yikes for Score 2

Create a Nested If statement that shows if the student Score 1 is an A it was Excellent, if Score 1 is a B it is Good, If Score 1 is a C it is OK, If Score 1 is a D it is Bad, and if Score 1 is a F it is Yikes. Do the same for Score 2