Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria
5. In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14:F15. For example, if total sales in Quarter 1 are between $5900 and $5999, the Performance rating is Good. Enter the performance ratings as follows: 6. 7. a. In cell B12, start to enter a formula using the HLOOKUP function. b. Use the Total Q1 sales (cell B8) as the value to look up. C. d. Use the Revenue Amts and Rating information (range $B$14:$F$15) as the table containing the lookup data, using absolute references to specify the range. Specify that row 2 contains the value you want to return, which is the performance rating. e. Specify an approximate match (TRUE) because the Revenue Amts represent ranges of values. f. Fill the range C12:E12 with the formula in cell B12 to enter ratings for Quarters 2- 4. In the range 13:L7, Benicio listed information about the managers of the DIG Technology main offices in the U.S., Canada, and Mexico. He needs to add a link to the email address of the U.S. manager. In cell L5, create a link to the tfenton@example.com email address without changing the display text. Benicio also wants to make it easy to access more detailed information about the managers, which he has stored in a Word document. Create a link to a file as follows: a. In cell 19, create a link to the Word document Support EX365_2021_CS5- 8a Management.docx. b. Use Management Details as the text to display. C. Use Access manager details as the ScreenTip text.
Step 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