Question: 2 3 4 On the SalesData worksheet in cell B4, use an XLOOKUP function to retrieve the product name for the ProductID in cell

2 3 4 On the SalesData worksheet in cell B4, use an XLOOKUP function to retrieve the product name for the A1 1 2 3 ProductID 4 PRD-00078 5 PRD-000587 6 7 PRD-00056 8 PRD-000837 9 PRD-000173 10 11 PRD-000382 12 1 ProductID 2 PRD-00078 3 PRD-000587 4 PRD-00056 5 PRD-000837 6 PRD-000173 7 PRD-000382 8 PRD-000663 9

2 3 4 On the SalesData worksheet in cell B4, use an XLOOKUP function to retrieve the product name for the ProductID in cell A4, using the table of data about the products at Kelly Computers on the Data worksheet. If the value is not found display a blank (""). Use the AutoFill handle to copy the function down to cell B18. Use the AutoFill Options to Fill Without Formatting. In cell C4, use a VLOOKUP function to retrieve the Unit Price for the ProductID in cell A4, using the table of data about the products at Kelly Computers on the Data worksheet. Copy the formula to cells C5, C7:C9, C11 C12, C14 C15, C17:C18. On the SalesData worksheet, in cell G4, create a formula that will perform a calculation that multiplies the Unit Price by the sum of products sold for January, February, and March. If a product has not sold any units over the past three months, display Discontinue. If the project has sold units, display the results of the Unit Price multiplied by the sum of the products sold for January, February, and March. Copy the formula, and then paste it in cells G5, G7:G9, G11:G12, G14 G15, and G17 G18. Resize the column as needed. A1 1 2 3 ProductID 4 PRD-00078 5 PRD-000587 6 7 PRD-00056 8 PRD-000837 9 PRD-000173 10 11 PRD-000382 12 PRD-000663 13 14 PRD-000446 15 PRD-000660 16 17 PRD-000229 18 PRD-00065 19 20 21 22 23 24 25 26 27 28 29 30 31 X fx Totals by Item Hard Drives Flash Drives Monitors Keyboard RAM Sales Data B Product Data Unit Price Totals Monthly Snapshot Goal 50 75 52 55 12 D January 12 7 20 18 Actual 5 2 13 3 2 E Quarter 1 Sales February 11 6 12 20 Outcome 4 6 11 5 March 12 8 13 19 5 5 12 4 G Total H 1 ProductID 2 PRD-00078 3 PRD-000587 4 PRD-00056 5 PRD-000837 6 PRD-000173 7 PRD-000382 8 PRD-000663 9 PRD-000446 10 PRD-000660 11 PRD-000229 12 PRD-00065 13 14 15 16 17 18 19 20 722742788 21 23 25 26 29 30. 31 32 B Product Name 1TB SSD Hard Drive 8TB HDD Hard Drive 2TB Flash Drive USB 3.0 32GB Flash Drive USB 2.0 128 GB Flash Drive USB 2.0 27" Monitor LED 32" Monitor LED QHD Keyboard Ergo Keyboard 64GB RAM 128GB RAM SalesData Data Category Storage Storage Storage Storage Storage Display Display Keyboard Keyboard Memory Memory D Price $ 169.99 $ 249.00 $ 47.99 $19.99 $ 21.75 $ 175.00 $ 280.00 $ 20.00 $ 35.00 $360.00 $ 650.00 E F

Step by Step Solution

★★★★★

3.51 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The answer provided below has been developed in a clear step by step manner Step 1 2On the SalesData worksheet in cell B4 use an XLOOKUP function to r... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Make announcements for employees in the company This is the case: There is "ABC Training" going on for 2 months and the company divides the training program into 2 part (new employee and refresher...

1. Stella Scott has a work-study position at the fitness center on campus. Her manager has asked her to create a worksheet to keep track of attendance and revenue for the fitness center's classes....

PROJECT STEPS 1. Lizzy is the manager of Cozy Movies, a small local movie theater that has been in business for a very long time. She would like to keep track of the theater's sales and expenses from...

When working with a 'standard" recipe you may sometimes need to make adjustments to it to accommodate special requests. List six (6) substitutes you can use for people with intolerances and allergies.

On the SalesData worksheet in cell B 4 , use an XLOOKUP function to retrieve the product name for the Creductld in cell A 4 , using the table of data about the products at Kelly Computers on the Data...

YO 2 2 _ Excel _ BU 0 3 _ Assessment 2 _ Kelly _ Computers Project Description: As the new accounting assistant at Kelly Computer Services, you have been asked to expand upon the content of an...

2 On the SalesData worksheet in cell B 4 , use an XLOOKUP function to retrieve the product name for the ProductID in cell A 4 , using the table of data about the products at Kelly Computers on the...

On the SalesDate worksheet in cell B4, use an XLOOKUP function to retrieve the product name for the ProductiD in cell A4, using the table of data about the products at Kelly Computers on the Data...

YO16_XL_GRADER_CASE5 - Coffee 1.1 Project Description: Chloe Jants is fulfilling her long-term dream of opening a coffee shop on a busy corner of her hometown. Her town is like many others in the...

Hey please I just need you to show steps like how to do them because I dont know how to do it. PLEASE EXPLAIN LIKE YOURE EXPLAINING TO SOMEONE WHO NEVER USED EXCEL THANKS. STEPS 2-31. Step...

State which of the following sets of quantum numbers would be possible and which impossible for an electron in an atom. a. n = 2, l = 0, ml = 0, ms = + 1/2 b. n = 1, l = 1, ml = 0, ms = + 1/2 c. n =...

Solve with Moore and Hodgson's Algorithm: Consider the following five jobs. Job () Processing Time (p;) 1 2 3 4 5 4 6 6 8 Due Date (d) 18 19 9 21 17 Find the schedule that minimizes the number of...

As the Chief Financial Officer of your municipality, how ensure that your municipality has good credit rating

Compute a simple aggregate price index. Use 2010 as the base period. Price Quantity Item 2010 2018 2010 2018 Aluminum (cents per pound) Natural gas $ per million BLA Petroleum (barrel) Platinum (troy...

A pump that has the characteristic curve shown in the accompanying graph is to be installed as shown. What will be the discharge of water in the system? Elevation = 20 ft L = 50 ft D = 10 in. f =...

Show that the running time of themerge-sort algorithmon an n-element sequence is O(nlogn), even when n is not a power of 2.

Discuss how Google's data mining and GapMinder's data analysis efforts could be used to improve public policy discussion in the United States.

In a five-slit system, how many minima lie between the zeroth-order and first-order maxima?

Corporate governance plays a critical role in shaping ethical behavior and maintaining public trust. When governance fails, the consequences can be enormousnot just for the company, but for...

Modify What SUPs Double Declining Balance Depreciation Schedule You are to add another depreciation schedule for What SUP. Use the ch4-01_DDB_student_name worksheet you created in this chapter. Add a...

From where does most of the information in a form come?

What do validation rules do?

Consider the following partially completed two-way ANOVA table. Suppose there are four levels of Factor A and three levels of Factor B. The number of replications per cell is 5. Complete the table...

There are three hospitals in the Tulsa, Oklahoma, area. The following data show the number of outpatient surgeries performed on Monday, Tuesday, Wednesday, Thursday, and Friday at each hospital last...

A consumer organization wants to know whether there is a difference in the price of a particular toy at three different types of stores. The price of the toy was checked in a sample of five discount...