Sales sheet

Using Excel formulas, create a new column called "New Salesperson" that replaces all salespeople named "Arthur" with your first name.

New sheet: Dashboard

Create a drop$-$down list that includes the names of all fourteen new salespeople. For the salesperson selected in the drop$-$down list, calculate the following on the dashboard:

The total of "Sales Price" for that salesperson

The average of that salesperson's "Sales Price"

The total number of cars sold by that salesperson

Create another drop$-$down list that includes the names of all three stores. For the selected store, calculate the following on the dashboard:

The total of "Sales Price" for that store

The average of that store's "Sales Price"

The total number of cars sold at that store

New sheet: Pivot tables

Create the following three pivot tables. For each one, be intentional about which placement for row and column headings makes the data easiest to read.

The total "Sales Price" for each new salesperson and inventory type.

The number of cars sold by month and store.

The number of buyers $($units sold$),$ by gender, for each car make and model.