1. Study the following screenshot and then answer the questions below.

a. What is the address of the value 72?

b. What is the address of the value Eve?

c. What is the content of C3?

d. What is the content of D5?

e. Write a formula to calculate the average quiz score for John.

f. Write a formula to calculate the minimum score.

g. What would be the numeric value produced by the formula =COUNT(F4:F6)?

h. What would be the numeric value produced by the formula =SUM(B6:F6)?

2. If the cell G4 contains the formula =G2-G3, what will happen to the content of the cell when it is copied:

a. One row down to G5

b. One column left to F4

3. If the cell G4 contains the formula =D$1*G7-$J5, what will happen to the content of the cell when it is copied:

a. One row up to G3

b. One column right to