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