You will find six multi-part questions about the data set all within the Excel file you just downloaded.
When completing this MP, ensure that:
Your answers must appear in cells originally provided (eg: E10, D20, etc). This means you must not add any rows or columns that might move the location of those cells.
You may use multiple cells to calculate the result, so long as the final answer appears in the originally provided cell.
When an input field is specified (in an orange cell), it must be used as part of the formula such that changing the value in the input updates the result.
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: