ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 77-888 All Questions

View all questions & answers for the 77-888 exam
Go to Exam

Exam 77-888 topic 1 question 2 discussion

Actual exam question from Microsoft's 77-888
Question #: 2
Topic #: 1
[All 77-888 Questions]

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick wants to display data series, categories, data markers, and axes in the report. Which of the following actions will Rick take to accomplish the task?

  • A. He will use stand-alone slicers.
  • B. He will create a PivotTable report.
  • C. He will configure form controls.
  • D. He will create a PivotChart report.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
The PivotChart report is used to provide a graphical representation of data in a PivotTable report in an interactive way. Whenever a user creates the PivotChart report, PivotChart report filters are displayed in the chart area. These are used for sorting and filtering the underlying data of the PivotChart report. Changes made to the layout and data in the associated PivotTable report are immediately reflected in the layout and data in the PivotChart report. The PivotChart report shows data series, categories, data markers, and axes in the same way as the standard charts do. It is possible to change the chart type and other options such as titles, legend placement, data labels, and chart location.
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 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 B is incorrect. A PivotTable report is used to summarize large amounts of data, to analyze numerical data, and to answer unexpected questions about data.
by Shahid_416 at Nov. 22, 2023, 11:32 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Shahid_416
1 year, 7 months ago
Option D : he will create pivot chart
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel