2. 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 of Sale. We have named the data in column B as Salesperson, the data in column C as Date, and so on. For the data in the worksheet Bakery, which function would compute total revenue generated by Jane? = SUM(Salesperson = Jane, Dollars ) =SUM(Salesperson,"Jane",Dollars) = SUMIF(Salesperson = Jane, Dollars) = SUMIF(Salesperson,"Jane",Dollars)