to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. Which of the following steps will you take to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply. A. Click OK. B. Choose Select a table or range under Choose the data that you want to analyze. C. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK. D. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab. E. Click a cell in the cell range that contains data for using worksheet data as the data source. Answer: A, B, D, E QUESTION: 55 You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. You are creating a business report by using. Microsoft Excel 2013. You have arranged sales data as shown below: You want to provide pictorial representation of the trend of the sales data in front of each row. Which of the following actions will you take to accomplish the task with the least amount of administrative burden? 51
D. Create a PivotTable report. Answer: C Explanation: C:\Documents and Settings\Administrator\Desktop\1.JPG In order to accomplish the task with the least amount of administrative burden, use sparklines. Sparklines, introduced in Microsoft Office 2013, are tiny charts that can fit in a cell. The sparklines can be used to show trends in a small amount of space. The sparklines visually summarize trends alongside data. The sparklines can be added through the Insert tab. Answer option A is incorrect. Stand-alone slicers are referenced from Online Analytical Processing (OLAP) Cube functions. These stand-alone slicers can be connected with any PivotTable in future. They can be added by using the slicer button on the Ribbon. They need to be manually linked into grids as required. Answer option B is incorrect. A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web pages. Answer option D is incorrect. A PivotTable report is used to summarize large amounts of data, to analyze numerical data, and to answer unexpected questions about data.