70-779 Exam Dumps | You have a table named Sales that has three columns named Region, Country, and SalesAmount. You create

<< Prev Question Next Question >>

Question 22/30

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.

A. Move Country from the Rows area to the Values area.

B. On the Design tab, click Report Layout and then click Show in Tabular Form.

C. Move Country from the Rows area to the Columns area.

D. On the Design tab, click Report Layout and then click Show in Compact Form.

Question 22/30

LEAVE A REPLY

Download PDF File