Hello, I need someone to help me instantlyanswer 10-20 multiple choice questions using Microsoft Excel Pivot Tables for analysis.

BusinessObjects Analysis

DATA ANALYSIS CASE 1 APPLYING PIVOT TABLES FOR ANALYSIS Acknowledgment: This exercise is adapted from the work of Nitin Kal (University of Southern California) and Nancy Jones (San Diego State University). I would like to thank Nitin and Nancy for their valuable contribution. OBJECTIVE Use Microsoft Excel Pivot Tables for analysis. ACTIVITIES Create a pivot table Create crosstabs Filter, sort, rank Aggregate data Create charts as needed SOFTWARE PREREQUISITES Microsoft Excel 2010 or higher UCC PRODUCTS REQUIRED None DATA REQUIRED GBI dataset is available in GBI_E5_2.xlsx SCENARIO You are an accountant working for a company called Global Bike Inc. You have been assigned to assist the strategic planning team with profitability analysis in the wholesale division of the company. (The internet sales will be handled by a different team.) Your IT team has pulled transactional data from 2011 through 2014 for you to analyze. The data are stored in an Excel file called GBI_E5_2.xlsx. There are 36,968 lines of data in the spreadsheet. QUESTIONS Use Excel Pivot tables to answer the questions for the case assignment in BBL.