how do you do these on excel

(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 6am-11am; Lunch is 11am-4pm; Dinner is 4pm-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 Sheet3, 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 takeaway here is that pivot tables are essentially doing SUMIFS or COUNTIFS when they run summary statistics.