Microsoft

70-779 · Question #109

You have the following data sample. You need to create a PivotTable that presents the data as shown in the following table. What should you do?

The correct answer is A. Create a PivotTable. Add UnitPrice to the Rows area and add SalesAmount to the Values area. https://exceljet.net/lessons/how-to-group-a-pivot-table-by-age-range

Visualize data by using Microsoft Excel

Question

You have the following data sample. You need to create a PivotTable that presents the data as shown in the following table. What should you do?

Exhibit

70-779 question #109 exhibit

Options

ACreate a PivotTable. Add UnitPrice to the Rows area and add SalesAmount to the Values area.
BCreate a PivotTable. Add SalesAmount to the Rows area and add UnitPrice to the Values area.
CCreate a PivotTable. Add UnitPrice to the Rows area and add SalesAmount to the Values area.
DCreate a PivotTable. Add SalesAmount to the Rows area and add UnitPrice to the Values area.

How the community answered

(40 responses)

A
85% (34)
B
3% (1)
C
5% (2)
D
8% (3)

Explanation

https://exceljet.net/lessons/how-to-group-a-pivot-table-by-age-range

Topics

#PivotTable#Rows area#Values area#field placement

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 70-779 Practice