Basic Pivot Tables Using the excel spreadsheet provided to you, create a series of Pivot Tables $($or Pivot Charts$)$ to answer the following questions $.1.$ What are the averages for purchases in each region $?2.$ What form of payment is most common $?3.$ Do our customers shop at work $($most likely between $8$:$00$ and $17$:$00)$ or at home $?$ Include a printout of the pivot tables you used to answer each question $.$ You can type your answer and insert pivot tables right after each question $,$ but highlighted it with different fonts or format Note : To answer number $3,$ created a new column in the spreadsheet labeled "Hour of Day $"$ and set it to just the hour instead of hour and minutes $.$ In other words hour G$8).$ The students who are excel power users should use an $"$ if$"$ formula to create a value of either day $($ time between $8$:$00$ and $17$:$00)$ or night $($not between $8$:$00$ and $17$:$00)$