I’m trying to study for my Excel course and I need some help to understand this question.

Chapter 8: Questions and problems: 1, 2,5, 6, 7, 8, 9, 10 Page 265/266

Chapter 12: Questions and Problems: 2, 5, 6, 9 Pages 415-417

MUST BE DONE IN EXCEL