Microsoft Exam 77-427 Topic 7 Question 43 Discussion

Actual exam question for Microsoft's exam

Question #: 43
Topic #: 7

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You want to summarize a large amount of data 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.

AClick OK.

BChoose Select a table or range under Choose the data that you want to analyze.

CSelect the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.

DClick PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.

EClick a cell in the cell range that contains data for using worksheet data as the data source.

Show Suggested Answer

Suggested Answer: A, B, D, E

by Deeanna at Jun 25, 2022, 07:06 AM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!