Microsoft
70-779 · Question #22
You have a table named Sales that has three columns named Region, Country, and SalesAmount. You create a PivotTable as shown in the following exhibit. You need to ensure that the PivotTable appears…
The correct answer is D. On the Design tab, click Report Layout and then click Show in Tabular Form. See the full explanation below for the reasoning.
Question
You have a table named Sales that has three columns named Region, Country, and SalesAmount. You create a PivotTable as shown in the following exhibit. You need to ensure that the PivotTable appears in three columns as shown in the following exhibit.
Exhibits
Options
- AOn the Design tab, click Report Layout and then click Show in Compact Form.
- BMove Country from the Rows area to the Columns area.
- CMove Country from the Rows area to the Values area.
- DOn the Design tab, click Report Layout and then click Show in Tabular Form.
How the community answered
(53 responses)- A13% (7)
- B9% (5)
- C4% (2)
- D74% (39)
Community Discussion
No community discussion yet for this question.