12-10 This project gives you an opportunity to learn how to use Excel’s PivotTable feature to analyze a database or data list. Use the data file for Online Management Training Inc. described earlier in the chapter. This is a list of the sales transactions at OMT for one day. You can find this spreadsheet file at MyLab MIS. Use Excel’s PivotTable to help you answer the following questions:

Where are the average purchases higher? The answer might tell managers where to focus marketing and sales resources, or pitch different messages to different regions. (l. 87)