answer part A B & C. PLEASE SHOW FUNCTIONS
Assignment 6 Part A: Tiger Company sells used cars. Tiger has 3 different locations and 12 total salespeople. Data about each salesperson is as follows: All of the required formulas must use at least one function from the material in chapter 9 . You may use the numbers listed in the required items in the formulas. Required: - Enter the above data, as shown, with Salesperson starting in cell FI. - The answer for each requirement must be calculated using a single formula. - For all of the following, use the number as a label in column B and put the formula that calculates the answer in column C. 1. What is the total years of experience of the salespeople working at the Montgomery location? 2. How many total cars did Tiger Company sell? may use the numbers listed in the required items in the formulas. Required: - Enter the above data, as shown, with Salesperson starting in cell F1. - The answer for each requirement must be calculated using a single formula. - For all of the following, use the number as a label in column B and put the formula that calculates the answer in column C. 1. What is the total years of experience of the salespeople working at the Montgomery location? 2. How many total cars did Tiger Company sell? 3. What is the total price of all cars sold for the Opelika location? 4. How many cars were sold by salespeople with less than 8 years of experience? 5. How many cars were sold by salespeople that work at the Montgomery location and have more than 3 years of experience? 6. Calculate the total price of all cars sold by salespeople who sold 15 or more cars, and round the total price to the nearest dollar. 7. Calculate the total price of all cars sold by Tiger Company and round the total price to the nearest $1,000. 8. Calculate the total years of experience of all salespeople with less than 10 years of experience. 9. Truncate the total price of all cars sold by salespeople with 8 years of experience to the nearest $10,000. 10. Determine the remainder (modulus) from dividing the total price of all cars sold by Tiger Company by the total number of cars sold by Tiger Company. Part B: You have an upcoming job interview with ACME Accounting and Finance. ACME makes hiring decisions based on the results of an interview and a skills exam. a. The interview is scored on a scale of 150. b. The skills exam is scored on a scale of 1100. c. The job offer is determined by the sum of the interview and skills exam scores. i. If the combined score is 125 or higher, then the applicant is offered a manager job. ii. If the combined score is 100-124, then the applicant is offered a salesperson job. iii. If the combined score is less than 100 , then the applicant is not offered any job. Required: Create your solution on a worksheet named Interview. - Predict your scores on the interview and skills exam using RANDBETWEEN functions. - Your interview and sales exam scores are independent of each other. - Use an IFS function to determine the job offer that you will receive based on your predicted scores. Part C: AUM wants to predict the outcome of the next softball game. The coach figures that the probabilities for the number of runs scored are as follows: Ine runs scored by each team is independent of the runs scored by the other team. Required: - Predict the score of the game. - Use RAND and VLOOKUP functions to predict the goals scored by AUM and TROY, - Do not nest any functions for this part! - Use an IF function to determine the winner of the game. If AM wins, then say: AUM is the best! If Troy wins, then say. Troy won. If it is a tie, then say Tie score. Remember to follow all items in the Excel Requirements document
