Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting

Authors: Heintz and Parry

20th Edition

1285892070, 538489669, 9781111790301, 978-1285892078, 9780538489669, 1111790302, 978-0538745192

More Books

Students also viewed these Accounting questions