nerdexam
Microsoft

70-779 · Question #22

70-779 Question #22: Real Exam Question with Answer & Explanation

Sign in or unlock 70-779 to reveal the answer and full explanation for question #22. The question stem and answer options stay visible for context.

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

70-779 question #22 exhibit 1
70-779 question #22 exhibit 2

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.

Unlock 70-779 to see the answer

You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-779 Practice
You have a table named Sales that has three columns named Region,... | 70-779 Q#22 Answer | NerdExam