Please solve the following problem using Excel commands

Please see the attached 3 documents: the first one is the problem you will work on. The second one is the step by step instructions, and the third one is the solution of the same typical problem solvedproblem to be solved.docx step by step instruction.pdf example typical problem solved.pdf