A. Explain what a Macro is in Excel? Give an example. 3pts

B. Describe what an interactive dashboard is and how you would go about developing the skills to build one with excel. What would it be useful for in SCM? Give a specific example. 3pts

C. There is an excel table attached here.

Using the excel spreadsheet, create a series of Pivot Tables (or Pivot Charts) to answer the following questions. 9pts You must attach your excel file for these pts.

What are the averages for purchases in each region?

What form of payment is most common?

Do our customers shop at work (most likely between 8:00 and 17:00) or at home?

Turn in a pdf of the pivot tables you used to answer each question. 6pts

Note: To answer number 3, I 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(G8). 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).

The remaining 5 pts for this assignment are for commenting as well as providing links or personal assistance guidance for anyone who needs help. You are done if you've made two helpful posts on the due date. If, on the due date, you have made one helpful post, then comment on one person's response to Question C. Focus should be on what you did wrong or different or what they did wrong or differently and which way you think is better. If you just finished on the due date, you'll need to comment on two classmates' responses to Question C.