please show the excel functions also

everything you need to solve is in the pictures.

(1) The worksheet named Qicarsales contains information about sales made at the ford dealership in Evansville. (10 points) Part 1:Your boss asked you write an Excel function to display unit sold for each model if a salesperson is chosen. a. In B16, use Data Validation fuction to create a list which allows a user to choose one of the salesperson's name. Make the drop-down artow always visible as I illustrated in slides and video. Names of all models were provided in B17:617. b. In B18, write one Excel function to display the unit sold for each of the six models. Only one function in B18 is needed, but all unit solds would be generated automatically by the function typed in B18. 1 Part 11: 20 21 Part b: 22. Salesperson 2) Model 24 Unit Sold In B22, use Data Validation fuction to create a list which allows a user to choose one of the saiesperion' name, Same as Part 1. In B23, use Data Validation fuction to create a list which allows a user to choose one of the models. No need to make the drop-down arrow visible since you have demonstrated that in part t In 824, use one Excel function to find the unit sold given the chaice a user made in 822 and 323 , in other words, if a user choose Michael and EcoSport SE, Cell 824 should display 9. 21 Part b: 22 Salesperson Michael 23 Model Ecosport se 1. (1) The worksheet named Qicarsales contains information about sales made at the ford dealership in Evansville. (10 points) Part 1:Your boss asked you write an Excel function to display unit sold for each model if a salesperson is chosen. a. In B16, use Data Validation fuction to create a list which allows a user to choose one of the salesperson's name. Make the drop-down artow always visible as I illustrated in slides and video. Names of all models were provided in B17:617. b. In B18, write one Excel function to display the unit sold for each of the six models. Only one function in B18 is needed, but all unit solds would be generated automatically by the function typed in B18. 1 Part 11: 20 21 Part b: 22. Salesperson 2) Model 24 Unit Sold In B22, use Data Validation fuction to create a list which allows a user to choose one of the saiesperion' name, Same as Part 1. In B23, use Data Validation fuction to create a list which allows a user to choose one of the models. No need to make the drop-down arrow visible since you have demonstrated that in part t In 824, use one Excel function to find the unit sold given the chaice a user made in 822 and 323 , in other words, if a user choose Michael and EcoSport SE, Cell 824 should display 9. 21 Part b: 22 Salesperson Michael 23 Model Ecosport se 1