Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network. Rick has to perform the following tasks: - Summarize large amounts of data. - Analyze numeric data…

Question

Options

• AHe will create the accounting template.
• BHe will use stand-alone slicers.
• CHe will create a PivotTable report.
• DHe will configure form controls.

• A
  3% (1)
• B
  15% (5)
• C
  74% (25)
• D
  9% (3)

Explanation

A PivotTable report is used to summarize large amounts of data, to analyze numerical data, and to answer unexpected questions about data. Answer option B 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 D 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 A is incorrect. The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point for other reports that need the use of

No community discussion yet for this question.