You will work in teams (2-3) for this lab. Each of you will build your own solution but the lab can be solved together. Each will submit your own solution but list the team members.

Step 1 Download the lab4 excel workbook.

You MUST use MS2016 version of Excel

Answer all the questions

Do NOT add any rows or columns. Your solution will not pass any of the tests.

Save your workbook

If you changed the input fields, put them back to their original values.
You will pass the first round of tests at least.

Export your data for grading as .xls. Save as Excel 97-2003 Workbook (.xls)

Use File: Save As: File Format: .xls

We can only grade .xls files

  Submit your .xls file for grading