Excel 365/2019 Capstone - Level 3 Working with Sales Data Alternate with VLOOKUP

profilefmgully
OldTownSales.xlsx
Home>Computer Science homework help>Excel 365/2019 Capstone - Level 3 Working with Sales Data Alternate with VLOOKUP

OldTownStore

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold)
1-Aug 140 49 110 299
2-Aug 141 100 133 375
3-Aug 32 68 35 135
4-Aug 130 35 34 199
5-Aug 104 124 93 321
6-Aug 43 135 117 295
7-Aug 61 9 62 132
8-Aug 16 68 93 177
9-Aug 8 70 19 97
10-Aug 145 9 114 275
11-Aug 94 14 148 256
12-Aug 50 59 87 196
13-Aug 92 110 65 267
14-Aug 64 140 63 267
15-Aug 40 46 12 98
16-Aug 136 50 128 314
17-Aug 21 34 55 110
18-Aug 32 122 133 287
19-Aug 57 144 12 213
20-Aug 36 98 107 241
21-Aug 122 140 44 306
22-Aug 53 76 97 226
23-Aug 96 122 48 266
24-Aug 96 100 43 239
25-Aug 118 106 30 251
26-Aug 115 61 47 223
27-Aug 29 53 133 215
28-Aug 20 124 10 154
29-Aug 66 73 130 269
30-Aug 73 78 124 275
31-Aug 93 42 76 205

Daily Total (# sold) 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 299 375 135 199 321 295 132 177 97 275 256 196 267 267 98 314 110 287 213 241 306 226 266 239 251 223 215 154 269 275 205 Old Bay 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 140 141 32 130 104 43 61 16 8 145 94 50 92 64 40 136 21 32 57 36 122 53 96 96 118 115 29 20 66 73 93 Black Truffle 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 49 100 68 35 124 135 9 68 70 9 14 59 110 140 46 50 34 122 144 98 140 76 122 100 106 61 53 124 73 78 42 Sea Salt and Caramel 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 110 133 35 34 93 117 62 93 19 114 148 87 65 63 12 128 55 133 12 107 44 97 48 43 30 47 133 10 130 124 76