90.2K

Verified Solution

Link Copied!

How to i create the order info query showing the top 10 sales ranked by descending sales? Please explain step by step the process and use the filter/sort paramaters!!!

Section 3: Gather Specific Data using VLOOKUP and Filter/Sort This sectioe will show the power of retrieving data from a variety of tabs using VLOOKUPs, and then Finking those VLOOKUPs with Filter/Sort to answer specific questions. Bcing able to link LOOKUP functions, as well as other features from Excel, can dramatically increase your efficiency within Excel. MS Excel Instructions - Use the Order Re-creation tab that you create as a template for the following four modified Queries. Order Re-creation Order Re-creation-SC2 Order Re-creation-SC3 Order Re-creation-5C4 Order Re-creation-SCS - You wall show the desired results for each Query by making use of Filier Sort and Hiding the columns that are bot the specific Columns tequcsted. columns with Fitters added, and your data will get out of alignisent and you will get incorrect results. You will use the following Falter/Sort parameters to answer the last questions: - Rank your Query results Asceting Descending by a certain Coluna: Go to the desired Column and click the Filice/Sort anow Click the Sort Senalleat to Largest or Largest to Smallest - Shew 'Top N': - Go to the desired Colamn and click the Filect Sort arrow - Click 'Number Filters' - Click Top 10, and choose the specific number of tecords desired - Show one specific entry type for a certain Celumat - Go to the desired Column and click the Filter/Sort amow - Click the Scarch box - Enter the desired entry and hit enter - Show Date Range: - Go to the desired Colamin and click the Fitree/Sort arrow - Click the 'Select All' box to deseloct everything - Expand the dates to the depth (Year Month Day) needed to nelect the Date Range you recuire structiect) Superstore Assignment Screen Clipping 2 - Create Onder Info Query showing the Top 10 Sales, ranked by Descending Sales. Frofit. Screenshot Answer Sheet Word document. 8 receivils. Oraler ID: CA-2017-143714. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline Or & Order ID (FK) & Order Date & Customer Name & Segment & \begin{tabular}{l} Sales \\ Region \end{tabular} & Product Name & Category & Sub-Category & Sales & Profit \\ \hline c. & CA-2015-103800 & 1/3/2015 & Darren Powers & Consumer & Central & OFF-PA-10000174 & Technology & Phones & 16.448 & 5.5512 \\ \hline 3. C & CA-2015-11232t & 1/4/2015 & Phillina Ober & Home Offic & Central & OFFSTT-10002743 & Office Supplies & Binders & 272.736 & \begin{tabular}{ll} 6 & -64.775 \end{tabular} \\ \hline 40 & CA-2015-11232t & 1/4/2015 & Phillina Ober & Home Offic & Central & OFF.LA-10003223 & Furniture & Tables & 11.784 & 4.2717 \\ \hline 5c & CA-2015-11232t & 1/4/2015 & Phillina Ober & Home Otfic & Central & OFF-BI-10004094 & Office Supplies & Paper & 3.54 & -5.487 \\ \hline 6 & CA-2015-14181: & 1/5/2015 & Mick Brown & Consumer E & East & OFF-AR-10003478 & Office Supplies & Binders & 19.536 & 4.884 \\ \hline 7 & CA-2015-10605t & 1/6/2015 & Jack OBriant & Corporate & South & OFF-AR-10002399 & Office Supplies & Fasteners & 12.78 & 5.2398 \\ \hline 8 & CA-2015-13081: & 1/6/2015 & Lycoris Saunders & Consumer & West & OFF.PA-10002005 & Office Supplies & Paper & 19.44 & 4.9.3312 \\ \hline 9 & CA-2015-167195. & 1/6/2015 & Maria Etezadi & Home Offic & c South & OFF-PA-10000955 & Office Supplies & Paper & 6.54 & 3.0084 \\ \hline 10 & CA-2015-167195 & 1/6/2015 & Maria Etezadi & Home Offic & c South & OFF-AR-10001662 & Office Supplies & Envelopes & 5.48 & 1.4796 \\ \hline & CA-2015-16719: & 1/6/2015 & Maria Etezadi & Home Offic & c South & OFF-FA-10001883 & Technology & Accessories & 31.12 & 0.3112 \\ \hline 12 & CA-2015-167195 & 1/6/2015 & Maria Etezadi & Home Offic: & C. South & FUR-CH-10004063 & Office Supplies & Art & 2573.82 & 2746.408 \\ \hline 13 & CA-2015-167196 & 1/6/2015 & 6. Maria Etezadi & Home Olfic & c South & TEC-PH-10004539 & Furniture & Chairs & 755.96 & 6204.109 \\ \hline 14 & CA-2015-167195: & 1/6/2015 & Maria Etezad! & Home Offic & E South & OFF-81-10004632 & Technolory & Accessories & 609.98 & \begin{tabular}{ll} 3 & 274.491 \end{tabular} \\ \hline 5 & CA-2015-16719! & 1/5/2015 & 5 Maria Etezadi & Home Offic & c South & TEC-PH-10004977 & Furniture & Furnishings: & 391.98 & 8. 113.674 \\ \hline 16. & CA-2015-10541: & 1/7/2015 & 5 Vivek Sundaresam & Consumer & Central & OFF-81-10003708 & Office Supplies & Art & 10.43 & 318.253 \\ \hline 17 & CA.2015-10541: & 1/7/2015 & 6 Vivek Sundaresam & Consumer & Central & FUR.FU-10004S64 & Office Supplies & Paper & 76.728 & 53,71 \\ \hline 18 & CA-2015-13540t & 1/9/2015 & 5. Melanie Seite & Consumer & - Central & TEC-AC-10001266 & Office Supplies & Labels & 31.2 & 9.75 \\ \hline 19 & CA.2015.13540! & 1/9/2015 & 5 Melanie Seite & Consumer & - Central & OFF-AR-10004078 & Otfice Supplies & Paper & 9.344 & 1.168 \\ \hline 20 & CA.2015-149026 & 1/10/2015 & 5 Anthony Jacobs & Corporate & South & FUR-FU-10000965 & Office Supplies & Labels & 51.94 & 4. 21.2954 \\ \hline 21 & C4-2015-14902L & 1/10/2015 & 5 Anthony Jacobs & Corporate & South & OFF.LA-10004272 & Technology & Phones & 2.89 & 13583 \\ \hline 22 & CA-2015-13009: & 1/11/2015 & 5 Seth Vernon & Consumer & East & FUR-FU-10000010 & Technology & Phones & 9,94 & 3.0814 \\ \hline 23 & CA.2015-10923: & 1/13/2015 & 5 Natalie DeCherney & Consumer & South & FUR-CH-10000422 & Technolory & Phones & 545.94 & 87.3504 \\ \hline 24 & CA.2015-11819: & 1/13/2015 & 5 Michael Moore & Consumer & East & OFF.PA-10002947 & Office Supplies & Storage & 37.408 & 13.0928 \\ \hline 25 & CA-2015-11819: & 1/13/2015 & 5. Michael Moore & Consumer & East & OFF-B1-10003476 & Othice Supplies & Art & 3.438 & -2.5212 \\ \hline 28 & CA.2015.15714i & 1/13/2015 & 5 Brian Dahien & Consumer & Wert & OFF.ST-10000078 & Office supplies & Art: & 1325.85 & . 238.653 \\ \hline 27 & CA.2015-157.14: & 1/13/2015 & 5. Brian Dahlen & Contumer. & West & FUP.80-10003034 & Omice supplies & Sterage & 333.999 & . 9294 \\ \hline 28 & CA-2015-15714: & 1/13/2015 & 5. Arian Dahlen & Consumer & Went & OFF.AM-10003514 & Furniture & Tables & 199 & 5.567 \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer