$1.$ Only use the given values in the workbook provided to you in the Content area of our course for the assignment. Note that there are different values in the text for Gross Revenues. These values are adjusted in the file to reflect new class sections.

$2.$ Check your text to understand what you are being asked to do$.$ For Dealer Satisfaction and End$-$User Satisfaction, start with year $2014$ for first set of data you copy. The next set will be for $2015,$ then $2016,2017$ and $2018.$ This exercise will give you practice copying, pasting, and manipulating data in spreadsheets. The areas shaded in green in the worksheet are the areas where you will input the appropriate data, formulas, functions, etc. For example, on the $$Dealer Satisfaction$$ worksheet, the answer area is shaded:

$3.$ The new worksheets referenced in numbers $3$ and $4$ have already been created. They are labeled $$Gross Revenues$$ and $$Market Share$,$ respectively. You will need to use an absolute cell reference when creating formulas for Gross Revenues.

$4.$ Place your name in each worksheet in cell A$200$ and your student number in A$201$ to receive credit for your Excel worksheets for this assignment.

$5.$ Summarize your findings and observations in your Word document report. Provide recommendations for future decisions, supported by data from your Excel worksheets. Think about any potential areas for growth and ways to increase profits. Reread the case study in your text for context and ideas for areas you could address in your report.