The answers to the question are in the second picture in red. Show me how to work out the problem to get to the answer.

Chapter 9 Problem 16 Answers Notes: ns) One: Only enter answers into the "Green" Cells. Two: You MUST use the Excel Formulas, do NOT simply Three: A few Cells may have some guidance to help you Step 1: Chapter 9 Problem 16 Answers Notes: ns) One: Only enter answers into the "Green" Cells. Two: You MUST use the Excel Formulas, do NOT simply Three: A few Cells may have some guidance to help you Step 1