Question: In cellB2, type the value from A20. Insert a function in cell D2 that will return the arrival date of any ring based on the

In cellB2, type the value from A20.
Insert a function in cell D2 that will return the arrival date of any ring based on the ID entered in cell B2.
Insert a function in cell F2 that will return the Special Notes of any ring based on the ID entered in cell B2.

9. Type > 1.0 carat and

10.Create an advanced search using the search criteria in the cell range H7:M8 and the inventory data where the results will be displayed in the search results (starting in cell H17).

11.Insert functions in range H12:K12 that will return the Count, Carat Ave, Min. Price and Max. Price of the search results returned from range H7:M8.

iDo Analysis Work Maddox AutoSaveFF Home Insert View Comments HESU- Draw Page Layout Calibri (Body) 11 B IU B Formulas A A A Data = E Review = = Tell me Wrsa Text E Merge & Center 2 insert 2 Delete E Accounting $ % AY- O 2 Sort & Find & Filter Select Share 4 Ideas Peste & Conditional Format Formatting es Table cell Styles Sensitivity Format X 13 x fx =AVERAGEIF(88:8157,">=1",08:0157) Ring ID Search Arriun Date Special Notes Overall Ave. 9,457.89 >1 Carst Ave. 9,573.65 1 Yew Ave. 1,024.76 $ 1.457.39 4543,413333 $ Search Criteria Arrival Date Price ID | Carat Days in iny Special 100001 100032 1.64 Search Summary Data M.AX Prices 1000341 100035 0.38 1000371 100038 100009 11 3.79 0.42 1.15 1.73 Search Results Arrhal Date sin 100010 0.17 100011 1000121 1000131 100014 100015 100016 100017 0.13 2.54 0.47 100019 100020 Inventory Arrival Date Price Days in Iny 9/12/2017 $ 3,016,00 5/3,2018 $ 4,320.00 6/22,2017 $ 7.948.00 5/10/2016 S 10.082.00 10/22, 2016 $ 11,829.00 5.113_2017 9 14,599.00 4/19/2018 $ 7,986,00 8/3,2017 $ 8,940.00 1010 9/11/2016 $ 1.370.00 1367 8/7/2016 $ 2,879.00 3/13,2018 $ 7,044.00 5/27,2016 $ 4,977.00 1443 B/24/2017 $ 8,096,00 6/6/2016 $ 14,659.00 9/2/19 $17.295.00 2/20/2016 $ 12,478.00 3/18/2018 $ 7,213.00 2/24/2017 S 9,027.00 1.701 9/11/18 S 1,303,00 B/25, 2016 $ 4,748.00 9/4/2017 5 12,4.2.00 1001 5/21/18 S 4,630.00 10/5/2016 $ 8,138.00 1312 3/4/2018 $ 14,942.00 7/22/2018 $ 7,545.00 7/5,2018 $ 15,811.00 6/2/2017 5 12,603.00 1072 5/3/2017 $ 2,588.00 1/4, 2016 $ 8,325.00 1587 2/9,2018 $ 6,020.00 5/27/2016 $ 11,337.00 9/1/18 $ 9,321.00 3/22/2017 4,101.00 1:43 9/22/18 $ 16,8$6.00 2/18/2017 $ 11,658.00 1113.2016 5 1,730.00 1579 10/6/2017 $ 15,133,00 Loan Sales Total + 1.26 0.67 1.59 WWW NNUNUNN + 1.641 1.48 1000221 100023 100024 1000251 0.14 100026 0.56 1.26 0.66 0.507 1.54 1.37 1000221 10008 100029 100030 100031 100032 100033 1000341 100035 10003 100037 Inventory 0.55 69 43 1.7 1.69 19 # 3 - - + 100% iDo Analysis Work Maddox AutoSaveFF Home Insert View Comments HESU- Draw Page Layout Calibri (Body) 11 B IU B Formulas A A A Data = E Review = = Tell me Wrsa Text E Merge & Center 2 insert 2 Delete E Accounting $ % AY- O 2 Sort & Find & Filter Select Share 4 Ideas Peste & Conditional Format Formatting es Table cell Styles Sensitivity Format X 13 x fx =AVERAGEIF(88:8157,">=1",08:0157) Ring ID Search Arriun Date Special Notes Overall Ave. 9,457.89 >1 Carst Ave. 9,573.65 1 Yew Ave. 1,024.76 $ 1.457.39 4543,413333 $ Search Criteria Arrival Date Price ID | Carat Days in iny Special 100001 100032 1.64 Search Summary Data M.AX Prices 1000341 100035 0.38 1000371 100038 100009 11 3.79 0.42 1.15 1.73 Search Results Arrhal Date sin 100010 0.17 100011 1000121 1000131 100014 100015 100016 100017 0.13 2.54 0.47 100019 100020 Inventory Arrival Date Price Days in Iny 9/12/2017 $ 3,016,00 5/3,2018 $ 4,320.00 6/22,2017 $ 7.948.00 5/10/2016 S 10.082.00 10/22, 2016 $ 11,829.00 5.113_2017 9 14,599.00 4/19/2018 $ 7,986,00 8/3,2017 $ 8,940.00 1010 9/11/2016 $ 1.370.00 1367 8/7/2016 $ 2,879.00 3/13,2018 $ 7,044.00 5/27,2016 $ 4,977.00 1443 B/24/2017 $ 8,096,00 6/6/2016 $ 14,659.00 9/2/19 $17.295.00 2/20/2016 $ 12,478.00 3/18/2018 $ 7,213.00 2/24/2017 S 9,027.00 1.701 9/11/18 S 1,303,00 B/25, 2016 $ 4,748.00 9/4/2017 5 12,4.2.00 1001 5/21/18 S 4,630.00 10/5/2016 $ 8,138.00 1312 3/4/2018 $ 14,942.00 7/22/2018 $ 7,545.00 7/5,2018 $ 15,811.00 6/2/2017 5 12,603.00 1072 5/3/2017 $ 2,588.00 1/4, 2016 $ 8,325.00 1587 2/9,2018 $ 6,020.00 5/27/2016 $ 11,337.00 9/1/18 $ 9,321.00 3/22/2017 4,101.00 1:43 9/22/18 $ 16,8$6.00 2/18/2017 $ 11,658.00 1113.2016 5 1,730.00 1579 10/6/2017 $ 15,133,00 Loan Sales Total + 1.26 0.67 1.59 WWW NNUNUNN + 1.641 1.48 1000221 100023 100024 1000251 0.14 100026 0.56 1.26 0.66 0.507 1.54 1.37 1000221 10008 100029 100030 100031 100032 100033 1000341 100035 10003 100037 Inventory 0.55 69 43 1.7 1.69 19 # 3 - - + 100%

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 General Management Questions!

In cell B 2 , type the value from A 2 0 . Insert a function in cell D 2 that will return the arrival date of any ring based on the ID entered in cell B 2 .

I need help with #7 and #8. I dont need the answer, just help woth what function to use 7. Insert a function in cell D2 that will return the arrival date of any ring based on the ID entered in cell...

I need help with #7 7. Insert a function in cell D2 that will return the arrival date of any ring based on the ID entered in cell B2. 7. Insert a function in cell D2 that will return the arrival date...

You need to create a search by VIN and an advanced search of any criteria and return the required results. a . Enter the value from cell A 7 in cell B 2 . b . Insert a function in cell D 2 that will...

Calculate Cumulative Statistics for One Condition You need to create a search by serial number and an advanced search of any criteria and return the required results. e. Enter the value 24545262 in...

8. Insert a function in cell F2 that will return the Special Notes of any ring based on the ID entered in cell B2. 8. Insert a function in cell F2 that will return the Special Notes of any ring based...

I need help with #7 and #8 2. On the Inventory worksheet, insert a function in E8:E157 to calculate the number of days each ring has been in inventory using 10/1/2018 as today's date. 3. Insert a...

Car Inventory You have been tasked with creating an Excel workbook that will allow sales persons the ability to search existing inventory by VIN. They must also be able to define any combination of...

(NOTE: I DO NOT NEED HELP WITH PROBLEM #'s 2-7, THEY ARE ONLY THERE FOR YOUR REFERENCE) Use the Donors worksheet through Step 13. The first column displays the name of the college or school (such as...

Exam 2: Modules 5-7 (100 pts) Car Inventory You have been tasked with creating an Excel workbook that will allow sales persons the ability to search existing inventory by VIN. They must also be able...

Describe the features of an AMA, its advantages, and its disadvantages.

In the Hollywood movie A Beautiful Mind, Russel Crowe plays John Nash who developed the Nash Equilibrium concept in his PhD thesis at Princeton University. In one of the early scenes of the movie,...

What does the equity risk rise in capital structure selected by industry risk financial risk liquidy risk strategic risk risk

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...