77-427 Question #23: Real Exam Question with Answer & Explanation

Question

Exhibits

Options

• AUse stand-alone slicers.
• BConfigure form controls.
• CCreate sparklines.
• DCreate a PivotTable report.

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 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.

No community discussion yet for this question.