Question: Outline and subtotal data Open the OutlineData workbook in Excel, and then perform the following tasks: Outline the data list in cells A 1 :D

Outline and subtotal data
Open the OutlineData workbook in Excel, and then perform the following tasks:
Outline the data list in cells A1:D25 to find the subtotal for each year.
Hide the details of rows for the year 2020.
Create a new group consisting of the rows showing data for June and July 2019.
Hide the details of the group you just created.
Show the details of all months for the year 2020.
Remove the subtotal outline from the entire data list.
Save and close the file.
Outline and subtotal data Open the OutlineData

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 Programming Questions!