please include formulas and describe each step

The associated file entitied "Transactions Data Task1" contains hypothetical transactions for a convenience store that is open from 6am to 11pm every day for a yeat Do the following: (a) Make a pivot table of sales by store by month. (b) Make a pivot table of sales by store by day of the week. (c) Make a pivot table of sales by store by meal category (3 meal categories: breakfast, lunch, dinner). (You will need to use an If statement to make the meal category variable for each transaction using the time of day) Breakfast is 6am11 amc Lunch is 11am-4pm; Dinner is 4 pm-11pm (d) In Sheet2, use the SUMifs function to create a table of sales by store by month. (Your numbers should match those from the appropriate pivot table above.) (e) In Sheet 3, use the suMIFS function to create a table of sales by store by day of the week. Your numbers should match those from the appropriate pivot table above.) Note A takeavay here is that pivot tobles are essentially doing SUMiFS or COUNTIFS when they run summary statistics