Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer chokes, but the text of the scenario is the same in each question in this series.

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer chokes, but the text of the scenario is the same in each question in this series. Start of repeated scenario You...

You have a pie chart.

You have a pie chart. You need the wedges of the pie chart to be separated as shown in the following exhibit. A . Change the chart type to Pie of Pie.B . Right-click the pie chart, click Expand/Collapse, and then click Expand.C . Right-click the pie chart, click Expand/Collapse, and Then click Expand...

What should you use?

You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount. You need to create the PivotTable as shown in the following table. What should you use?A . KPIsB . sparklinesC . conditional formattingD . banded rows View Answer Answer: A...

What should you do?

Your network contains a folder that has data files m various formats. You need to identify how many files of each extension type are in the folder by using Query Editor. What should you do?A . Create a query that uses a file source, and then use the Count Values command on the Transform...

What should you do?

You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1. You need to modify Goal to multiply the sales from the previous year by 1.15. What should you do?A . From Power Pivot, modify the measure.B . From the properties of the KPI, modify...