HOTSPOT 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 choices, but the text of the…

You have the following tables in a data model. You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table. You need to ensure that the data appears in chronological order.…

You have a PivotChart template named Template1. You add a PivotChart to a worksheet. You need to apply the template to the PivotChart. What should you do? A. On the Format tab, click Format Selection B. Right-click the chart, and…

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 choices, but the text of the scenario…

You have an Excel workbook that displays two PivotCharts. One chart displays sales by month. The order chart displays sales by year. You add a slicer for month. You discover that when you select a month in the slicer, the…

You have the following table. You need to create a PivotTable as shown in the following exhibit. What should you do? A. Add LineTotal to the Rows area. Add Product to the Values area twice. B. Add LineTotal to the…

You have the PivotTable shown in the following exhibit. You need to display only rows in the PivotTable in which the sum of LineTotal is greater than 100. What should you do? A. Add a slicer for LineTotal and select…

Your company has a data analyst who uses Microsoft Power BI Desktop to create a data model and several reports. The data analyst publishes the reports to the Power BI service. You need to create a PivotTable in Excel that…