5-Step Problem-Solving Strategies for Excel Assignments

Step 1: Understand the problem clearly

Solve each assignment problems below by following the 5-step problem-solving strategies below:
STEP 1: Understand the problem clearly -- read the problem instruction carefully more than once.
STEP 2: Strategize -- begin by thinking roughly as to how the problem can be solved -- write your ideas out in words.
STEP 3: Design solutions-- write a more structured algorithm or draw a flow chart of the ordered set of steps required to solve the problem.
STEP 4: Implementation -- translate your design algorithm to formulae that Excel can execute -- use appropriate functions and name-defined cell ranges for full credit.
STEP 5: Verification -- ensure that the results of your formulae match the example values.
MAIN TASK: READ CAREFULLY BEFORE PROCEDING
1. Create an Excel Workbook containing the solutions to the problems below.
2. Save the workbook as your full name, e.g., peggy_carter.xlsx (all lowercase)
3. Each problem must be solved in its own worksheet; please keep everything compact so that they are easily found and viewable when opened.
4. Rename each sheet tab with the specific problem title, e.g., Mortgage, Invoice, Movies, etc.
5. Use the data as provided in the examples to test your solutions.