Recent Question/Assignment

I'd like it to be completed in an excel format while off course following the instructions which has been stated in the assignment question.