Use Microsoft Excel Spreadsheet Software Analyze Table Data Project Gives Opportunity Lear Q37217843

You will use Microsoft Excel spreadsheet software to analyze atable of data. This project gives you an opportunity to learn howto use Excel’s PivotTable functionality to analyze a database ordata List. Use the data file for Online Management Training Inc.This is a list of the sales transactions at OMT for one day. UsetheOnlineManagementTraining.xls file (attached)and update the spreadsheet to answer the following questions.

1. In what region are the average prices higher?
2. What form of payment is the most common?
3. Are there any times of day when purchases are most common? Dopeople buy products while at work (likely during the day) or athome (likely
   OR

    

   

   OR