I have the screen shot of the Excel file presented below anything will help thank you.

LESSON 4: DATA QUERIES AND GOAL SEEK/WHAT-IF SCENARIO A. Queries Use the file, nyntory.xls. Filtering 1. Click on Data and Filter 2. Click on the down arrow button in a numeric field (column) in the table. For example, code. 3. Click on Number Filters. 4. Choose Custom Filter. 5. Use the appropriate operator such as Equal, Greater than , etc. for your queries. Showing All Records after Filtering Choose Data > Filter Removing AutoFilter Lists Click on Filter Inventory Query Questions Retrieve NVNTORY, and use queries (other functions if necessary) to answer the following questions. 1. What items are out of stock? 2. What items have more than 25 units on hand? 3. What items cost less than $50? 4. What chairs are priced over $50? 5. What items constitute the 5000 line (i.e. codes in the 5000's)? 6. What changes (updates) would routinely have to be made to this inventory spreadsheet to maintain it and keep it current? Be specific. 7. How would the use of FIFO or LIFO complicate this spreadsheet? Could the spreadsheet be used as it is currently designed? Be specific. * You must indicate which filtering criteria you have used for your data queries. * You should print out the results of your filtering of the inventory query data. 12 OS WA 1 A D H M N O R S T U 1060 bod 1070 dresser 2010 chair 2020 lamp 2030 sofa 2040 table 2050 desk 2060 bed 2070 dresser 3010 chair 3020 lamp 3030 sofa 3040 table 3050 desk 3060 bed 3070 dresser 4010 chair 4020 lamp 4030 sofa 4040 table 4050 desk 4060 bed 4070 dresser 5010 char 5020 lamp 5030 sofa 5040 table 5050 des 5060 bed 5070 dresser 6010 char 5020 lamp 5030 sota 5040 table 8050 desk 8060 bed 8070 dresser 7010 chair 7020 lamp 7030 sota 7040 table 7050 desk 7060 bed 7070 dresser C uw . King. Wood Finish Standup 5 drawer Straight Back Chandeler Love Seat Dining Room Deluxe with Glass Cabinet Queen, Woad Finish Wakt High Double Rocking Brass. Stand Up Hide-e-bed Coffee Wood Finish Professional Single, Wood Finish Waist High, Single LMng Room Table Large Comer Unit End, for Corner Unit Comer Trundle Camer White ENAMAI White Porcelain White Love Seat White Enamel While Enamel King. White Ename White Enamel Camauter Desk Flourescent Small Comer Unit Computer Computer Bunk Camauter Kitchen Tifany Bay Window Kitchen Kitchen Fold-away Calenial 300 3001 45 90 120 500 150 250 250 30 75 200 100 150 225 175 175 25 300 150 250 120 300 60 80 180 90 150 275 125 50 401 180 125 150 120 100 420 420 53 126 168 700 210 350 350 42 105 280 140 210 315 245 245 35 420 210 350 188 420 94 112 252 126 210 385 175 70 56 252 175 210 188 140 42 168 210 186 105 105 224 2 3 25 5 4 B 0 . 3 15 12 6 7 4 20 9 11 30 2 2 3 3 1 1 9 8 9 2 - 7 8 3 6 22 40 D 13 8 8 15 30 5 2 10 6 120 150 140 75 75 180 3 LESSON 4: DATA QUERIES AND GOAL SEEK/WHAT-IF SCENARIO A. Queries Use the file, nyntory.xls. Filtering 1. Click on Data and Filter 2. Click on the down arrow button in a numeric field (column) in the table. For example, code. 3. Click on Number Filters. 4. Choose Custom Filter. 5. Use the appropriate operator such as Equal, Greater than , etc. for your queries. Showing All Records after Filtering Choose Data > Filter Removing AutoFilter Lists Click on Filter Inventory Query Questions Retrieve NVNTORY, and use queries (other functions if necessary) to answer the following questions. 1. What items are out of stock? 2. What items have more than 25 units on hand? 3. What items cost less than $50? 4. What chairs are priced over $50? 5. What items constitute the 5000 line (i.e. codes in the 5000's)? 6. What changes (updates) would routinely have to be made to this inventory spreadsheet to maintain it and keep it current? Be specific. 7. How would the use of FIFO or LIFO complicate this spreadsheet? Could the spreadsheet be used as it is currently designed? Be specific. * You must indicate which filtering criteria you have used for your data queries. * You should print out the results of your filtering of the inventory query data. 12 OS WA 1 A D H M N O R S T U 1060 bod 1070 dresser 2010 chair 2020 lamp 2030 sofa 2040 table 2050 desk 2060 bed 2070 dresser 3010 chair 3020 lamp 3030 sofa 3040 table 3050 desk 3060 bed 3070 dresser 4010 chair 4020 lamp 4030 sofa 4040 table 4050 desk 4060 bed 4070 dresser 5010 char 5020 lamp 5030 sofa 5040 table 5050 des 5060 bed 5070 dresser 6010 char 5020 lamp 5030 sota 5040 table 8050 desk 8060 bed 8070 dresser 7010 chair 7020 lamp 7030 sota 7040 table 7050 desk 7060 bed 7070 dresser C uw . King. Wood Finish Standup 5 drawer Straight Back Chandeler Love Seat Dining Room Deluxe with Glass Cabinet Queen, Woad Finish Wakt High Double Rocking Brass. Stand Up Hide-e-bed Coffee Wood Finish Professional Single, Wood Finish Waist High, Single LMng Room Table Large Comer Unit End, for Corner Unit Comer Trundle Camer White ENAMAI White Porcelain White Love Seat White Enamel While Enamel King. White Ename White Enamel Camauter Desk Flourescent Small Comer Unit Computer Computer Bunk Camauter Kitchen Tifany Bay Window Kitchen Kitchen Fold-away Calenial 300 3001 45 90 120 500 150 250 250 30 75 200 100 150 225 175 175 25 300 150 250 120 300 60 80 180 90 150 275 125 50 401 180 125 150 120 100 420 420 53 126 168 700 210 350 350 42 105 280 140 210 315 245 245 35 420 210 350 188 420 94 112 252 126 210 385 175 70 56 252 175 210 188 140 42 168 210 186 105 105 224 2 3 25 5 4 B 0 . 3 15 12 6 7 4 20 9 11 30 2 2 3 3 1 1 9 8 9 2 - 7 8 3 6 22 40 D 13 8 8 15 30 5 2 10 6 120 150 140 75 75 180 3