MP Description

Download

Similar to MP4, the data and questions for MP5 are all contained in the Excel file downloadable here.

Important Details

Requirements

You will find fifteen questions about the data set all within the Excel file you just downloaded. When completing this MP, ensure that:

• Your answers must appear in F7:F21. This means you must not add any rows or columns that might move the location of those cells.
• When an input field is specified in Column E, it must be used as part of the formula such that changing the value in Column E will update the answer in Column F.
  • As an example, E9 initially contains 2000 when the sheet is opened for the first time.
  • If you change E9 to 1970, F9 should automatically update to a new value based of the input of 1970.
• Your file must be an Excel .xlsx file. If we are unable to open your file using Excel, you file will not be graded and you will not earn any points. If you are not sure, you should double check that your file opens on a CITES ITS computer before submitting.

Submission and Grading

Your Excel file must open with Excel to receive any credit at all. We will award points for your program completing the following:

• 2 x 15pts, 2 points for each question

Submit MP5 here