This is a MS Excel assignment. The software is freely available as part of the Office 365 package for students. Download and install to your system if you have not done so already.
others
Description
This is a MS Excel assignment. The software is freely available as part of the Office 365 package for students. Download and install to your system if you have not done so already.
Be sure to aim for appropriate formulas and functions that are flexible, elegant and optimally
comprehensible/meaningful as discussed in lectures.
RECOMMENDED: Solve each assignment problem 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). Be sure to save your workbook as a normal Excel workbook file.
3. Each problem must be solved in its own worksheet within one workbook so rename each sheet tab with the specific problem title, e.g., Mortgage, Invoice, Movies, etc. (Ensure to keep everything compact so that they are easily found and viewable when opened.)
4. You may use the raw data as provided in the examples and supplementary files to test your solutions.
5. Be sure to include all required components in appropriate format for each problem solution.
6. Up to 50% penalty will be applied for not using named ranges optimally
