Complete the following exercises in Microsoft Excel (preferred) using cell formulas. If the assignment is completed in Microsoft Word, provide explanations (100 words) to each of the answers along wit

Complete the following exercises in Microsoft Excel (preferred) using cell formulas. If the assignment is completed in Microsoft Word, provide explanations (100 words) to each of the answers along with any relevant calculations to receive credit. Your part in completing the assignment is to demonstrate an understanding and application of the concepts and problem-solving. Review the grading rubric below to adhere to assignment/grading criteria.