Excel work need help

Plz finish those step by step, don’t just give answers without formula calculation.

This work contains 5 chapters, and I’ll provide sample form and solutions. Btw, the soulutions of the questions are almost same with my questions, just changed number.