VIEW HULU Developer Help Recent Sources [ Existing Connections Queries & Connections La From Text/CSV Pe From Web Get Data From Table/Range Share Properties Refresh All 2. AR Y Clear Sort NU Edit Links Stocks Geography Te Reapply Filter Get & Transform Data Queries & Connections Group Ungroup Subtotal Text to Columns EN Advanced What-If Forecast Analysis Sheet Forecast Data Types G102 3 Sort & Filter fo 378 Data Tools Outline M N P Q R A B D E F 1 G G H 1 K L 2 Excel Functions 3 4 Instructions 5 1. Answer using this worksheet 6 2. Read the instructions carefully, please take note that some of the questions are referring to a different table number 7 3. Don't just show the value in your answer but also the formula, we need to make sure that you used the right formula as instructed. 8 4.This test normally will take about 20 minutes. 9 5. Don't add or delete any rows or columns 10 6. After you finished save this file with using your LAST NAME 11 12 13 Open Inventory 14 On Hand Rail Yard On Boat In Quality Mfg Qty 15 G3572 2 12 18 28 38 16 D5904 9 19 29 39 49 17 D1476 18 28 38 48 58 18 D0557 41 51 61 71 81 19 C9208 82 92 102 112 122 20 C1319 169 179 189 199 209 21 W0933 338 348 358 368 378 22 W6415 169 179 189 199 209 23 W1051 338 348 358 368 378 24 W1117 169 179 189 199 209 25 26 Sheet1 Ready Type here to search o 6:22 PM 4/1/2021 PI Les Dile AJ Get & Transform Data Advanced Textt. Colum Queries & Connections Data Types Sort & Filter G102 Da 378 B C D F G 1 J K L M N 4. From the Open Inventory table above, find how many parts are scheduled to be produced using Vlookup for the following Rows below: A 64 65 66 67 Table 5 68 69 70 71 72 73 Mfg Qty W0933 D5904 W1117 C9208 W6415 D0557 75