Excel Practice Exercises PDF with Answers – Includes Class Performance Evaluation and Lookup Values (Left to Right) examples.

Problem Description:

The image contains two exercises related to Excel:

1. Exercise 01: Class Performance Evaluation
- A table with students' names, scores in Chemistry and Physics, and columns for Total, Average, and GPA.
- The task is to calculate the Total, Average, and GPA for each student.

2. Exercise 02: Lookup Values (Left to Right)
- A table with employees' names, Employee IDs, and salaries.
- The task is to use a lookup function to fill in the salaries based on the Employee IDs provided.

---

Solution:

#### Exercise 01: Class Performance Evaluation

##### Step 1: Calculate the Total
The total score for each student is the sum of their Chemistry and Physics scores. Use the `SUM` function or a simple addition formula.

- Formula for Total:
```
=Chemistry + Physics
```

- Application:
- For John: `=65 + 78 = 143`
- For Ross: `=57 + 52 = 109`
- For Natasha: `=58 + 33 = 91`
- For Gibbs: `=54 + 45 = 99`
- For Marco: `=71 + 46 = 117`
- For Diego: `=67 + 57 = 124`

##### Step 2: Calculate the Average
The average score is the total divided by the number of subjects (2 in this case).

- Formula for Average:
```
=Total / 2
```

- Application:
- For John: `=143 / 2 = 71.5`
- For Ross: `=109 / 2 = 54.5`
- For Natasha: `=91 / 2 = 45.5`
- For Gibbs: `=99 / 2 = 49.5`
- For Marco: `=117 / 2 = 58.5`
- For Diego: `=124 / 2 = 62`

##### Step 3: Calculate the GPA
Assuming a standard GPA scale where:
- 90–100 = 4.0
- 80–89 = 3.0
- 70–79 = 2.0
- 60–69 = 1.0
- Below 60 = 0.0

Use an `IF` statement or a nested `IF` statement to determine the GPA based on the average score.

- Formula for GPA:
```
=IF(Average >= 90, 4,
IF(Average >= 80, 3,
IF(Average >= 70, 2,
IF(Average >= 60, 1, 0))))
```

- Application:
- For John: `Average = 71.5 → GPA = 2.0`
- For Ross: `Average = 54.5 → GPA = 0.0`
- For Natasha: `Average = 45.5 → GPA = 0.0`
- For Gibbs: `Average = 49.5 → GPA = 0.0`
- For Marco: `Average = 58.5 → GPA = 0.0`
- For Diego: `Average = 62 → GPA = 1.0`

##### Final Results for Exercise 01:
| Name | Chemistry | Physics | Total | Average | GPA |
|---------|-----------|---------|-------|---------|-----|
| John | 65 | 78 | 143 | 71.5 | 2.0 |
| Ross | 57 | 52 | 109 | 54.5 | 0.0 |
| Natasha | 58 | 33 | 91 | 45.5 | 0.0 |
| Gibbs | 54 | 45 | 99 | 49.5 | 0.0 |
| Marco | 71 | 46 | 117 | 58.5 | 0.0 |
| Diego | 67 | 57 | 124 | 62 | 1.0 |

---

#### Exercise 02: Lookup Values (Left to Right)

##### Step 1: Use the `VLOOKUP` Function
The task is to find the salary corresponding to each Employee ID. Use the `VLOOKUP` function to search for the Employee ID in the right-side table and return the corresponding salary.

- Formula for VLOOKUP:
```
=VLOOKUP(Employee_ID, Lookup_Range, Column_Index, FALSE)
```
- `Employee_ID`: The cell containing the Employee ID to look up.
- `Lookup_Range`: The range where the lookup will occur (e.g., `G17:H22`).
- `Column_Index`: The column number in the lookup range that contains the salary (column 2 in this case).
- `FALSE`: Ensures an exact match.

##### Step 2: Apply the Formula
- For John: `=VLOOKUP(E17, G17:H22, 2, FALSE) = $3,250`
- For Ross: `=VLOOKUP(E18, G17:H22, 2, FALSE) = $2,789`
- For Natasha: `=VLOOKUP(E19, G17:H22, 2, FALSE) = $2,984`
- For Gibbs: `=VLOOKUP(E20, G17:H22, 2, FALSE) = $3,320`
- For Marco: `=VLOOKUP(E21, G17:H22, 2, FALSE) = $2,458`
- For Diego: `=VLOOKUP(E22, G17:H22, 2, FALSE) = $3,300`

##### Final Results for Exercise 02:
| Name | Employee ID | Salary |
|---------|-------------|----------|
| John | E-7531 | $3,250 |
| Ross | E-8851 | $2,789 |
| Natasha | E-8832 | $2,984 |
| Gibbs | E-7845 | $3,320 |
| Marco | E-8758 | $2,458 |
| Diego | E-7785 | $3,300 |

---

Final Answer:

#### Exercise 01: Class Performance Evaluation
| Name | Chemistry | Physics | Total | Average | GPA |
|---------|-----------|---------|-------|---------|-----|
| John | 65 | 78 | 143 | 71.5 | 2.0 |
| Ross | 57 | 52 | 109 | 54.5 | 0.0 |
| Natasha | 58 | 33 | 91 | 45.5 | 0.0 |
| Gibbs | 54 | 45 | 99 | 49.5 | 0.0 |
| Marco | 71 | 46 | 117 | 58.5 | 0.0 |
| Diego | 67 | 57 | 124 | 62 | 1.0 |

#### Exercise 02: Lookup Values (Left to Right)
| Name | Employee ID | Salary |
|---------|-------------|----------|
| John | E-7531 | $3,250 |
| Ross | E-8851 | $2,789 |
| Natasha | E-8832 | $2,984 |
| Gibbs | E-7845 | $3,320 |
| Marco | E-8758 | $2,458 |
| Diego | E-7785 | $3,300 |

Boxed Final Answer:
```plaintext
Exercise 01:
| Name | Chemistry | Physics | Total | Average | GPA |
|---------|-----------|---------|-------|---------|-----|
| John | 65 | 78 | 143 | 71.5 | 2.0 |
| Ross | 57 | 52 | 109 | 54.5 | 0.0 |
| Natasha | 58 | 33 | 91 | 45.5 | 0.0 |
| Gibbs | 54 | 45 | 99 | 49.5 | 0.0 |
| Marco | 71 | 46 | 117 | 58.5 | 0.0 |
| Diego | 67 | 57 | 124 | 62 | 1.0 |

Exercise 02:
| Name | Employee ID | Salary |
|---------|-------------|----------|
| John | E-7531 | $3,250 |
| Ross | E-8851 | $2,789 |
| Natasha | E-8832 | $2,984 |
| Gibbs | E-7845 | $3,320 |
| Marco | E-8758 | $2,458 |
| Diego | E-7785 | $3,300 |
```