Excel Exam For Business Analytics

I need a sharp-turnaround assist for my upcoming Business Analytics laboratory exam that is entirely Excel-based. The exam will require me to build the underlying formulas that drive the analysis and then translate the results into a clear line graph, so I want a ready-to-use workbook that I can study and replicate during the test.

Here is what I must walk away with:
• A single Excel file containing the clean, well-labeled data range.
• All core formulas and functions already in place—no array tricks or VBA, just efficient native functions that can be retyped quickly under exam conditions.
• A professional-looking line graph that dynamically updates when any value in the data table changes.

I will share a sample data set the examiners provided; please use it so I can compare your approach with the grading rubric. Comment each key cell to explain the logic—concise notes are fine, but they should be clear enough that I can reproduce everything without hovering over the formulas.