Exp22_Excel_Ch05_HOE - Sociology 1.1 | excel Chapter 5 Hands-On Exercise Sociology | excel Ch05 HOE скачать в хорошем качестве

Exp22_Excel_Ch05_HOE - Sociology 1.1 | excel Chapter 5 Hands-On Exercise Sociology | excel Ch05 HOE

Exp22_Excel_Ch05_HOE - Sociology 1.1 | excel Chapter 5 Hands-On Exercise Sociology | excel Ch05 HOE Contact us: WhatsApp : +92 3260782026 WhatsApp Link: https://bit.ly/3pIuXPl Gmail : homework6670@gmail.com We can handle all online courses, Business and Management, Business and Finance, MylTLab all Courses are the vice president of the Sociology Division at Ivory Halls Publishing Company. Textbooks are classified by an overall discipline. Books are further classified by area. You will use these classifications to see which areas and disciplines have the highest and lowest sales. The worksheet contains wholesale and retail data. You want to analyze sales for books published in the Sociology Division Start Excel. Download and open the file named Exp22_Excel_Ch05_HOE_Sociology.xlsx. Grader has automatically added your last name to the beginning of the filename. Your first task is to sort the dataset on the Books Subtotal worksheet. Ensure the Books Subtotal worksheet is active. Sort the data by Discipline in alphabetical order and further sort it by Area in alphabetical order. You want to subtotal the dataset by Discipline and then add a second set of subtotals by Area. Use the Subtotal feature to insert subtotal rows by Discipline to calculate the totals for the Sales Wholesale, Sales Retail, and Total Book Sales columns. Without removing the first subtotals, insert subtotals by Area to calculate totals for the same columns. Next, you want to apply an outline to the columns so that you can collapse or expand the Units Sold and Unit Price columns. Create an automatic outline. Collapse the outline above columns H and K. Next, you want to create a recommended PivotTable and then name it. Display the Books Data worksheet and create a recommended PivotTable using the Sum of Units Sold thumbnail. Change the name of the worksheet to PivotTable. Name the PivotTable Total Book Sales. You want to compare total book sales by discipline and copyright year. Make sure these fields are in the respective areas. Remove extra fields. Place the Discipline field in rows, Total Book Sales field as values, and Copyright field in columns. You will format the values in the PivotTable to look more professional and change the custom names that display as column headings. Click or select cell B5, display the Value Field Settings dialog box, and type Sales by Discipline as the custom name. Apply Accounting Number Format with zero decimal places. You want to replace the generic Row Labels and Column Labels headings with meaningful headings. Type Discipline in cell A4 and Copyright Year in cell B3. Select the range B4:E4 and center the labels horizontally. On the Books Data sheet, you want to insert functions that will display the total sales and the total Introductory discipline sales data from the PivotTable. You will change the retail unit price rate from 30% to 25% and then refresh the PivotTable. Display the Books Data worksheet. In cell B1, enter the GETPIVOTDATA function to get the value from cell F10 in the PivotTable worksheet. In cell B2, enter the GETPIVOTDATA function to get the value from cell F7 in the PivotTable. Change the value in cell J1 to 125 in the Books Data worksheet, and then refresh the PivotTable. You will add a field to the Filters area so that you can filter the list by Edition. Add the Edition field to the Filters area. Because you plan to distribute the workbook to colleagues, you will insert a slicer to help them set filters. Insert a slicer for Discipline. Move the slicer so that the top-left corner is just inside the corner of cell A13. After inserting the slicer, you want to change the dimensions and appearance of it. Change the slicer to display 2 columns. Change the button width to 1.5 inches. Change the slicer height to 2 inches. Apply Light Blue, Slicer Style Dark 1. You want to calculate the amount of the sales returned to the authors as royalties. Create a calculated field with the name Author Royalties. Multiply Total Book Sales by *.1. In cell C5, use the Field Settings to type the custom name Authors’ Royalties. #Exp22_Excel_Ch05_HOE - Sociology 1.1 | excel Chapter 5 Hands-On Exercise Sociology #Exp22_Excel_Ch05_HOE - Sociology 1.1 #Exp22_Excel_Ch05_HOE - Sociology #Exp22_Excel_Ch05_HOE #Exp22_Excel_Ch05 #Exp22_Excel #excel Ch05 HOE Sociology 1.1 #excel Ch05 HOE Sociology #excel Ch05 HOE #excel Ch05 #exp22 excel Ch05 HOE Sociology 1.1 #exp22 excel Ch05 HOE Sociology #exp22 excel Ch05 HOE #exp22 excel