This is to be done in excel.This is for the accounting information system class.

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.

Excel File Edit View Insert Format Tools Data Window Help $ % 6% | Thu 4:13 AM Thu 4:13 AM a 5 NP EX19 EOM11-1 RochiBorbon 2 Q- Search Sheet Home Formulas Data Review View 9+ Share 1 11 A- A Wrap Text General , X AutoSum Fill - 4 Insert Page Layout X Cut Calibri Light... Copy BIU Format A X fx H Paste 7 Merge & Center $ - % % ) . .00 .00 0 Insert Delete Conditional Format Formatting as Table Cell Styles Format Clear Sort & Filter G1 A B D E F G H 1 j K L M N 0 P R S T U V w Y Z QUALEY CONSULTING SALES BY SERVICE 1 2 Row Labels 01 04 Annual 3 Brand positioning $15,810 $15,740 $52,310 4 Brand research $10,985 $10,890 $36,045 $ 5 Digital marketing $15,890 $15,180 $61,905 6 Market assessment $11,845 $21,975 $61,600 7 Marketing plan $22,740 $20,715 $74,495 8 Target marketing $10,790 $22,425 $64,090 9 Grand Total $88,060 $106,925 $350,445 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Documentation Sales Report Sales by Category Sales by Client Sales by Service + Ready u + 100%