Question #2 (5 marks) Worksheet 2. Newmark Car Company a) Enter the following table in Excel. Newmark Car Company Earnings by Prof. Mayo Last First Salary Sales Commission Earnings Above Average Earnings Dan $79,000 $500,500 Dean Rod $55,000 $140,000 Doe Jane $75,000 $450,000 Martin Mary $85,000 $530,800 May Jill $65,000 $345,000 Shannon George $39,000 $174,900 Smith John $60,000 $200,000 Min: Crow Max: Total: Average: b) Complete the rest of the table using formulas and functions, note the following: 1. Commission is 1.5% of Sales. Commission is a dollar amount, not a percent. 2. Earnings are Salary plus Commission. 3. The summary section should be completed for the columns Salary, Sales, Commission, and Earnings 4. In the Above Average Earnings column put a True or a False (IF statement) Use borders and double borders as shown. c)