Step 1: Use the Vlook-up function and the part number given, to link to the selling price in the Inventory Master File to the Daily Sales worksheet. Using the SumIf function to total the units and the dollar sales for each type of computer. Display the results at the bottom of the spreadsheet. If you are not sure about sumif function, please visit the link "how to use sumif function".
Step 2: To double check your answers from step one, create a pivot table using the same daily sales file to show by computer the total units sold and the total dollar sales for each of the two products in the same worksheet. For reference on how to build a pivot table, please follow the link: Learn Pivot Table in 6 minutes from Microsoft Excel The pivot table should appear on the Daily Sales Worksheet below the SumIf calculations.
Best Computer Company Daily Sales Selling Unit of Measure Price/Unit not used Dollar Sales Units Sold 122 66 81 ea 44 ea 15 ea 23 143 95 ea 32 21 ea 89 59 ea 21 14 ea 55 ea 83 24 16 ea 147 98 ea 15 10 ea 45 ea 68 81 54 ea 32 21 ea 61 ea 92 78 52 ea 71 47 ea 95 ea 143 135 56 90 ea 37 ea 94 ea 141 69 144 101 46 ea 96 ea 67 ea 55 ea 83 Part Date Number Inventory Category 2/1/20 60200 Computer, Complete 2/1/20 60210 Computer, Complete 2/3/20 50200 Computer, Complete 2/3/20 50210 Computer, Complete 2/4/20 50200 Computer, Complete 2/4/20 60210 Computer, Complete 2/5/20 50200 Computer, Complete 2/5/20 50210 Computer, Complete 2/6/20 50200 Computer, Complete 2/6/20 50210 Computer, Complete 2/7/20 50200 Computer, Complete 2/7/20 50210 Computer, Complete 2/8/20 50200 Computer, Complete 2/8/20 50210 Computer, Complete 2/9/20 50200 Computer, Complete 2/9/20 60210 Computer, Complete 2/10/20 60200 Computer, Complete 2/10/20 50210 Computer, Complete 2/11/20 50200 Computer, Complete 2/11/20 60210 Computer, Complete 2/12/20 50200 Computer, Complete 2/12/20 60210 Computer, Complete 2/13/20 50200 Computer, Complete 2/13/20 60210 Computer, Complete 2/14/20 50200 Computer, Complete 2/14/20 50210 Computer, Complete 2/15/20 50200 Computer, Complete 2/15/20 60210 Computer, Complete 2/17/20 50200 Computer, Complete 2/17/20 60210 Computer, Complete 2/18/20 50200 Computer, Complete 2/18/20 60210 Computer, Complete 2/19/20 50200 Computer, Complete 2/19/20 50210 Computer, Complete 2/20/20 50200 Computer, Complete 2/20/20 60210 Computer, Complete 2/21/20 50200 Computer, Complete 2/21/20 60210 Computer, Complete 2/22/20 50200 Computer, Complete 2/22/20 60210 Computer, Complete 2/24/20 50200 Computer, Complete 2/24/20 50210 Computer, Complete 2/25/20 50200 Computer, Complete 2/25/20 50210 Computer, Complete 2/26/20 60200 Computer, Complete 2/26/20 50210 Computer, Complete 2/27/20 50200 Computer, Complete 2/27/20 50210 Computer, Complete 2/28/20 60200 Computer, Complete 2/28/20 50210 Computer, Complete 2/29/20 50200 Computer, Complete 2/29/20 50210 Computer, Complete Description Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users 35 138 23 ea 92 ea 86 57 ea 86 57 ea 15 ea 95 ea 81 ea 96 ea 23 143 122 144 98 30 120 86 65 ea 20 ea 80 ea 57 ea 129 86 ea 30 ea 45 119 79 ea 18 12 ea 66 ea 99 96 64 ea 77 51 ea 116 77 ea 42 28 ea 93 117 62 ea 78 ea 84 ea 126 128 85 ea 65 ea 98 66 44 ea Total Sales Best Computer Company Daily Sales Selling Unit of Measure Price/Unit not used Dollar Sales Units Sold 122 66 81 ea 44 ea 15 ea 23 143 95 ea 32 21 ea 89 59 ea 21 14 ea 55 ea 83 24 16 ea 147 98 ea 15 10 ea 45 ea 68 81 54 ea 32 21 ea 61 ea 92 78 52 ea 71 47 ea 95 ea 143 135 56 90 ea 37 ea 94 ea 141 69 144 101 46 ea 96 ea 67 ea 55 ea 83 Part Date Number Inventory Category 2/1/20 60200 Computer, Complete 2/1/20 60210 Computer, Complete 2/3/20 50200 Computer, Complete 2/3/20 50210 Computer, Complete 2/4/20 50200 Computer, Complete 2/4/20 60210 Computer, Complete 2/5/20 50200 Computer, Complete 2/5/20 50210 Computer, Complete 2/6/20 50200 Computer, Complete 2/6/20 50210 Computer, Complete 2/7/20 50200 Computer, Complete 2/7/20 50210 Computer, Complete 2/8/20 50200 Computer, Complete 2/8/20 50210 Computer, Complete 2/9/20 50200 Computer, Complete 2/9/20 60210 Computer, Complete 2/10/20 60200 Computer, Complete 2/10/20 50210 Computer, Complete 2/11/20 50200 Computer, Complete 2/11/20 60210 Computer, Complete 2/12/20 50200 Computer, Complete 2/12/20 60210 Computer, Complete 2/13/20 50200 Computer, Complete 2/13/20 60210 Computer, Complete 2/14/20 50200 Computer, Complete 2/14/20 50210 Computer, Complete 2/15/20 50200 Computer, Complete 2/15/20 60210 Computer, Complete 2/17/20 50200 Computer, Complete 2/17/20 60210 Computer, Complete 2/18/20 50200 Computer, Complete 2/18/20 60210 Computer, Complete 2/19/20 50200 Computer, Complete 2/19/20 50210 Computer, Complete 2/20/20 50200 Computer, Complete 2/20/20 60210 Computer, Complete 2/21/20 50200 Computer, Complete 2/21/20 60210 Computer, Complete 2/22/20 50200 Computer, Complete 2/22/20 60210 Computer, Complete 2/24/20 50200 Computer, Complete 2/24/20 50210 Computer, Complete 2/25/20 50200 Computer, Complete 2/25/20 50210 Computer, Complete 2/26/20 60200 Computer, Complete 2/26/20 50210 Computer, Complete 2/27/20 50200 Computer, Complete 2/27/20 50210 Computer, Complete 2/28/20 60200 Computer, Complete 2/28/20 50210 Computer, Complete 2/29/20 50200 Computer, Complete 2/29/20 50210 Computer, Complete Description Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer-Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users Premium Desktop Gaming Computer Premium Descktop Computer- Power Users 35 138 23 ea 92 ea 86 57 ea 86 57 ea 15 ea 95 ea 81 ea 96 ea 23 143 122 144 98 30 120 86 65 ea 20 ea 80 ea 57 ea 129 86 ea 30 ea 45 119 79 ea 18 12 ea 66 ea 99 96 64 ea 77 51 ea 116 77 ea 42 28 ea 93 117 62 ea 78 ea 84 ea 126 128 85 ea 65 ea 98 66 44 ea Total Sales
