$7.$ In cell D$4,$ write a formula that will look up the sales rating for sales rep Bud Fox, based on his total sales in cell J$4.$ You must use the named range you created in Step $6$ in your formula. Copy the formula to the cell range D$5$ through D$12.$ 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.