Question: Please answer this question ASAP. & provide the correct function to use. D G H 1 In Chapter 6 we learned about Text functions. The

Please answer this question ASAP. & provide the correct function to use.

D G H 1 In Chapter 6 we learned about Text functions. The table below contains Pro luct Prices in form ID, Product, Price. We learned how to use Text functions to rip apart data. Using functions only (Text to Columns is not allowed) put the names in the order shown in Cell G6. Hint, you can FIND the hyphens then use the LEFT, RIGHT, MID, and LEN functions. You can use any version of concatenate to put it all back together. (10 points) example Product Buy the APPLE IPHONE 12 128G APP8513649751 for $1,299.00 online at Amazon today. Combined Price ID Product Prices APP8513649751-APPLE IPHONE 12 128G-$1,299.00 APPL943687122-APPLE IPHONE XR 64G-$799.00 SAM2647985210-SAMSUNG GALAXY 12-$899.00 MICR674896021-MICROSOFT SURFACE PRO-$1,399.00 LEN1122578963-LENOVO THINKCENTREX1 CARBON-$1,699.00 APPLES 8742364-APPLE MACBOOK PRO-$1,199.00 FIRE0025008990-FIRE TV ULTRA HD TV-$299.00 LG30008990105-LG 4K TV-$599.00 SONOS302008991-SONOS ARC-$699.00 SONOS302008985-SONOS ONE-$399.00 RING2021-RING FLOODLIGHT CAM-$ 719.00 D G H 1 In Chapter 6 we learned about Text functions. The table below contains Pro luct Prices in form ID, Product, Price. We learned how to use Text functions to rip apart data. Using functions only (Text to Columns is not allowed) put the names in the order shown in Cell G6. Hint, you can FIND the hyphens then use the LEFT, RIGHT, MID, and LEN functions. You can use any version of concatenate to put it all back together. (10 points) example Product Buy the APPLE IPHONE 12 128G APP8513649751 for $1,299.00 online at Amazon today. Combined Price ID Product Prices APP8513649751-APPLE IPHONE 12 128G-$1,299.00 APPL943687122-APPLE IPHONE XR 64G-$799.00 SAM2647985210-SAMSUNG GALAXY 12-$899.00 MICR674896021-MICROSOFT SURFACE PRO-$1,399.00 LEN1122578963-LENOVO THINKCENTREX1 CARBON-$1,699.00 APPLES 8742364-APPLE MACBOOK PRO-$1,199.00 FIRE0025008990-FIRE TV ULTRA HD TV-$299.00 LG30008990105-LG 4K TV-$599.00 SONOS302008991-SONOS ARC-$699.00 SONOS302008985-SONOS ONE-$399.00 RING2021-RING FLOODLIGHT CAM-$ 719.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Finance Questions!

Please answer this question ASAP. & provide the correct function to use. B C D E F G H In Chapter 7 we leariled how to use Date functions to find the differences between dates. The table below...

Please answer this question ASAP. & provide the correct function to use. In Chapter 20 & 21 we learned the functions COUNTIF and AVERAGEIF in class. Using the data and solutions in the Q2 tab of this...

Please answer this question ASAP. & provide the correct function to use. G E F H In Chap 21 w.mad how to use the SUMF, SU MIPS, AVERAGBIF, and AVERAGES Runctions. 2. The class worked in the campus...

Please answer this question ASAP. & provide the correct function to use. B D E F In chapter 3 we leared about LOOKUP functions. Use the Curve Table below to assign a lette each student in the list...

Please answer this question ASAP. & provide the correct function to use. In Chapter 10 we earned to use functions to determine the payment, interest, and principal on a loan. Use functions to...

Please answer this question ASAP. & provide the correct function to use. In Chapter 10 we learned about using functions to determine the cumulative interest and cumulative principal. Evaluate the 3...

Please answer this question ASAP. & provide the correct function and formula to use. N 0 P Q R Solution Team Washington Statistic Away Average 74,811 C D E F H 1 K L M 1 In Chapter & 5 we learned...

please calculate and answer the questions below. Formulas for Excell needed as well. D G H K M Information from McCormick Your task is to make an estimate of McCormick & Company's Weighted Average...

AutoSave OF AAOF... Lopez_excelproject_howtotutorial_ View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibrl (Body) v 11 X G v A A 25 Wrap Text General FO) v Paste YA...

please calculate with formulas and answer the questions below. what is not clear??? i took screen shots and its very clear on my end. i already took a lot of pictures. which one exactly is not clear?...

Certain transactions and procedures relating to federal and state unemployment taxes follow for Fashion Sense, a retail store owned by Nancy Roberts. The firms address is 2007 Trendsetter Lane,...

Let L: V V be a linear operator defined by L(v) = cv, where c is a fixed constant. Prove that the representation of L with respect to any ordered basis for V is a scalar matrix.

What values will the following variables have after the assignments have been completed? Amount 100 TotalPrice Amount * 3.5 Discount +0.2 Final Price TotalPrice Total Price Discount - Name "Nikki"...

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

Book protected time in your diary and allow 11.5 hours for the feedback debrief.

Prepare for the meeting by reading the feedback, identifying the key themes, etc. 2. Give an overview of key points regarding 360 reports and the feedback session

They are purely a set of perceptions, not fact.