80.2K

Verified Solution

Link Copied!

43. Please download the file pretest.xlsx. In the worksheet Bakery, each row gives the following data for a sales transaction: Transaction Number, Salesperson, Date of Sale, Product, Units Sold, Revenue Generated and Location. We have named the data in column B Salesperson, the data in column C Date, and so on. For the data in the worksheet Bakery, what function would compute total revenue generated by cake sales in the Weston location? =SUMIF(Dollars, Location, "Weston". Product,"cake") =SUMIF(Dollars, Location, Weston Product cake) =SUMIFS(Dollars, Location, "Weston". Product "cake") SUMIFS(Location, "Weston". Product,"cake" Dollars) . 70 Number Format as Table Pasto Font Alignment Cells Cell Styles 151 fx 9 0 1 12 33 34 35 36 37 38 A B 437 Zack 438 Tina 439 Mimi 440 Claire 441 Mimi 442 Mimi 443 Abby 444 Bella 445 Tina 446 Heidi 447 Heidi 448 Mimi 449 Abby 450 Tina 451 Bella 452 Zack 453 Bella 454 Jane 455 Abby C D 3/17/06 cookie 10/23/06 bagel 10/23/06 cookie 4/30/06 muffin 3/19/05 tart 1/26/04 bagel 2/17/04 tart 12/10/04 cookie 8/7/06 muffin 6/4/05 cake 1/21/06 bagel 1/15/04 tart 6/6/04 cookie 12/21/04 cookie 2/6/04 cookie 5/4/04 cake 10/3/05 muffin 6/17/04 cake 8/31/05 cake E F G 87 $263.07 Salem 15 $46.30 Weston 27 $83.41 Weston 78 $236.44 Maldem 27 $83.00 Salem 19 $59.62 Eaton 0 $2.37 Weston 30 $91.97 Salem 17 $52.94 Maldem 36 $109.95 Salem -4 ($10.24) Salem 4 $14.17 Eaton 81 $244.97 Eaton 87 $263.83 Salem 13 $40.51 Salem 48 $145.85 Eaton 2 $7.10 Weston 32 $98.37 Eaton $41.17 Weston 39 40 41 142 143 144 145 446 447 448 13

Answer & Explanation Solved by verified expert

See Answer