Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10. Go to the Sales by Service worksheet, which contains a PivotTable named ServicePivot that compares the Quarter 1, Quarter 4, and Annual sales

image text in transcribedimage text in transcribedimage text in transcribed

10. Go to the Sales by Service worksheet, which contains a PivotTable named ServicePivot that compares the Quarter 1, Quarter 4, and Annual sales for each service provided in 2021. Nadia wants to know the difference and the percentage of difference between the Quarter 4 and Quarter 1 sales and display the average total sales for each service. Insert a calculated field named Difference that subtracts the Qtr1 field amount from the Qtr4 field amount. In cell E2, use +/- Q4 to Q1 as the column label. 11. Insert another calculated field named % Difference that subtracts the Qtr 1 field amounts from the Qtr 4 field amounts, and then divides the result by the Qtr 1 field amount. In cell F2, use % Q4 to Q1 as the column label. Change the number format of the % Q4 to Q1 amounts to Percentage with 2 decimal points.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Recommended Textbook for

Accounting concepts and applications

Authors: Albrecht Stice, Stice Swain

11th Edition

978-0538745482

Students also viewed these Accounting questions

Question

How does demand for business products differ from consumer demand?

Answered: 1 week ago

Question

ANSWER =

Answered: 1 week ago