77-427 Real Exam Prep DEMO

Question 6: Which of the following can be defined as easy-to-use filtering components containing a set of
buttons that enable users to quickly filter data in a PivotTable report, without opening drop-down
lists to find the items to filter?
A. Accounting templates
B. ActiveX controls
C. Form controls
D. Slicers
Correct Answer: D
Explanation:
Slicers are defined as easy-to-use filtering components containing a set of buttons that enable users
to quickly filter data in a PivotTable report, without opening drop-down lists to find the items to
filter. When a user uses a regular PivotTable report filter to filter on multiple items, the filter
indicates only that multiple items are filtered and the user has to open a drop-down list to find the
filtering details. However, a slicer clearly labels the filter that is applied and provides details so that
the data displayed in the filtered PivotTable report can be easily understood. Answer option B is
incorrect. ActiveX controls are used on worksheet forms, with or without the use of VBA code, and on
VBA UserForms. They are used when a user needs more flexible design requirements than those
provided by Form controls. They have extensive properties that can be used to customize their
appearance, behavior, fonts, and other characteristics. The user can control different events that
occur when an ActiveX control is interacted with. He can also write macros that respond to events
associated with the ActiveX controls. When a user interacts with the control, the VBA code runs to
process any events that occur for that control. The ActiveX controls cannot be added to chart sheets
from the user interface or to XLM macro sheets. It is not possible to assign a macro to run directly
from the ActiveX control. Answer option C 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 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 months.