nerdexam
Microsoft

70-779 · Question #19

You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount. You need to create the PivotTable as shown in the following table. What should you use?

The correct answer is A. KPIs. See the full explanation below for the reasoning.

Question

You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount. You need to create the PivotTable as shown in the following table. What should you use?

Options

  • AKPIs
  • Bsparklines
  • Cconditional formatting
  • Dbanded rows

How the community answered

(34 responses)
  • A
    74% (25)
  • B
    6% (2)
  • C
    6% (2)
  • D
    15% (5)

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice