excel vba programming 1

Hello

I have an assignment it should be done using excel

I will upload the files below take a deep look at it and solve the answer accurately, correctly, and with full steps.

This assignment worth a lot of grade so please the work should be done correctly and on time.