Please answer the following questions using excel

Description

please answer the questions and show your work on excel. Thank you