Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 5 . Eva wants to display the payments customers made in each of five regions where Porter 3 6 0 does business. Insert a

15. Eva wants to display the payments customers made in each of five regions where Porter 360 does business.
Insert a recommended PivotTable based on the Orders table as follows:
a. Insert the Sum of Payment by Region recommended PivotTable.
b. Use May Sales by Region as the name of the new worksheet.
c. Apply the Sky Blue, Pivot Style Medium 13 style to the PivotTable.
d. Add a second copy of the Payment field to the Values area of the Field List, and then change its summary function to Average so that Eva can compare the average payments to the totals.
e. Change the number format of the two value fields to Currency with 2 decimal places and the $ symbol.
f. Use Total Sales as the column heading in cell B3, and use Average Sales as the column heading in cell C3.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

How can an organization implement the marketing concept?

Answered: 1 week ago