Question: please help. its the same picture just twice because it looked blurry Subtotal Records 1. Open 3-VRSeries-2.xlsx and save it with the name 3-VRSeries-3. 2.


Subtotal Records 1. Open 3-VRSeries-2.xlsx and save it with the name 3-VRSeries-3. 2. Click the Clear Filter button on the Slicer pane and then delete the Slicer pane. 3. Remove the Total row and remove the emphasis from the last column in the table. 4. Convert the table to a normal range. 5. Adjust all the column widths using AutoFit. 6. Sort the list first by genre, then by title, and then by season number. Use the default sort values and sort order for each level. 7. Using the Subtotal button, add subtotals to the Sale Price column to calculate the average sale price and to count the number of TV shows by genre. 8. Display the worksheet at level 3 of the outline. 9. Apply bold formatting to only the labels and count and average totals displaying in the Sale Price column. 10. Show the details for the Comedy and Drama genres. 11. Save, preview, and then close 3-VRSeries-3.xIsx
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
