Answered step by step
Verified Expert Solution
Question
1 Approved Answer
if someone could help me with steps 6-9! I would really appreciate it! thank you!! 6. Select the appropriate cells for the lookup table and
if someone could help me with steps 6-9! I would really appreciate it! thank you!!
6. Select the appropriate cells for the lookup table and give it the range name SalesRangeLookup. Make sure to select only the appropriate cells for the lookup table that would be used in one of the two lookup functions you learned about, as you will be using the named range in the next question. 7. In cell D4, write a formula that will look up the sales rating for sales rep Bud Fox, based on his total sales in cell J4. You must use the named range you created in Step 6 in your formula. Copy the formula to the cell range D5 through D12. Hint: You will need to use one of the two lookup functions you learned about in Lesson 7 in order to complete this step correctly. Based on the format of the lookup table, you should be able to identify which function to use. Since Bud has a total sales of over $1 million, you should expect his sales rating to be WooHoo. 8. In cell K4, write a formula that will look up the low interest loan entitlement for sales rep Bud Fox, based on his total sales in cell J4. You must use the named range you created in Step 6 in your formula. Copy the formula to the cell range K5 through K12. Hint: You should find that your formula is almost identical to the formula you created in Step 7. 9. In cell E4, write a formula that determines the employment status of the sales rep Bud Fox (cell D4). If the sales rating of Bud is equal to Oh-Oh, then his employment status is displayed as Terminated, otherwise his employment status is displayed as Employed. Copy the formula to the cell range E5 through E12. Hint: You will need to use the IF function in your formula to answer this step correctlyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started