Question: 4. Return to the Orders worksheet. Sandra wants to display the order totals by region. Insert a recommended PivotTable based on the Orders table as

4. Return to the Orders worksheet. Sandra wants to display the order totals by region. Insert a recommended PivotTable based on the Orders table as follows: a. Insert the Sum of Total by Region recommended PivotTable. b. Use Totals by Region Pivot as the name of the new worksheet. c. Change the number format of the Sum of Total field to Accounting with 2 decimal places and the $ symbol. 5. Sandra decides a chart would help to analyze the order data. On the Totals by Region Pivot worksheet, insert a Stacked Column PivotChart. Resize and position the PivotChart so that its upper-left corner is within cell D3 and its lower-right corner is within cell K17. 6. Home Chef sales representatives earn a 10 percent dividend on each order. Add the dividend data to the PivotChart as follows so that Sandra can compare the totals and dividends: a. Add a calculated field to the PivotChart. b. Use Dividends as the name of the calculated field (Hint: The Dividends field will appear as Sum of Dividends). c. The formula should multiply the Total field value by 0.1 to calculate the commission amount

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Slate Blue Technology ANALYZE DATA WITH PIVOTTABLES GETTING STARTED Open the file IL _ EX 1 9 _ EOM 8 - 1 _ FirstLastName _ 1 . xlsx , available for download from the SAM website. Save the file as IL...

In column 6, Benicio wants to indicate whether DIG Technology should send the customer a promotional offer. Customers are eligible for the offer if they purchased a Mini 2 in the U.S. Provide the...

PLEASE HELP! I am lost and do not know what to do! Thank you. 3. Go to the Material worksheet. Lucia wants to display information about products sold according to location and material. She has been...

The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding. Add a column to the ProposedProjects table, and determine which projects meet the criteria as...

please provide the steps for 2,3,4 and 5 2. Sandra wants to create a separate table displaying the products each customer ordered and the total price: To provide this information, create and format a...

3. Go to the Material worksheet. Lucia wants to display information about products sold according to location and material. She has been tracking this data in an Access database. Import the data from...

In the range I 8 :L 1 2 , Dean needs to insert a summary of the city development projects from the previous year. Insert this data as a table as follows: Insert a table in the range I 8 :L 1 2 ,...

Excel SAM Module 6 Pt. 3 12. Dean wants to summarize the number of projects proposed by the project type and calculate their funding amounts and average funding amounts. Calculate this information...

1. Marina Andros works in the Financials Department of Eastern Mobile, a communications company in Alexandria, Virginia. She is using an Excel workbook to analyze the company's recent financial...

Interview some employees of an organization, and ask them about the organizations values and norms, the typical characteristics of employees, and the organizations ethical values and socialization...

To be able to develop an equation relating the linear distance between moving bodies to the angular position and velocity of the first or driving body and to use this relationship to derive the...

under the _ method, the underwriter buys the entire issue and then resell the shares, while under the _ method, the underwriter does not purchase the shares but merely acts as an agent

Can you elucidate the role of molecular chaperones and protein quality control systems in maintaining the integrity and homeostasis of the cytoplasm, particularly under conditions of cellular stress...