how do i do this step for step:

For the Module $5$ Lab Assignment, you will create a workbook for the Brentwood School District. HINT: The finished Module $5$ Lab Assignment should include $4$ worksheets.

Problem: You are part of a team reviewing the classroom capacities of three high schools in the Brentwood School District. You have been tasked with creating a master worksheet for the district and separate worksheets for each of the two high schools. The high school worksheets should be based on the district worksheet. Once the worksheets have been created, the high school data can be entered into the appropriate worksheets, and the district worksheet will reflect district$-$wide information.

Perform the following tasks:

$1.$ Download the workbook "Lab $5$ Brentwood Schools" from the Data Files and save the workbook as LastnameFirstnameModule$5$Lab. Open the workbook.

$2.$ Create a new worksheet before Sheet $1$ with your name in cell A$1,$ date in cell A$2,$ course in cell A$3,$ instructor name in cell A$4,$ and assignment name in cell A$5.$ Name this worksheet "Module $5$ Lab Assignment Info".

$3.$ Add two worksheets to the workbook after Sheet$1$ and then copy$/$paste the contents of Sheet$1$ to the two empty worksheets.

$4.$ From left to right, rename the sheet tabs District, Parkway High School, and Calloway High School. Color the tabs each with a different color. On each school worksheet, change the title in cell B$2$ to match the sheet tab name. On each school worksheet, fill the range A$2$:F$3$ to match the color of its sheet tab. Enter the data in the table below into the school worksheets.

High School Classroom Capacity Figures

School Grade # of Students # of Rooms # of Rooms over Capacity # of Rooms under Capacity

Parkway High School $690620$

$7188880$

$8145707$

Calloway High School $6134640$

$7132600$

$8120521$

$5.$ On the two school worksheets, calculate the $"$# of Students per Room" in column D$.$

HINT $1$: You will need to use the data for # of Students and the # of Rooms.

HINT $2$: You will NOT use a function to calculate this.

HINT $3$: The number may NOT always be a whole number.

Now, calculate the totals in row $9.$

$6.$ On the District worksheet, use the SUM function, $3-$D references, and copy$-$and$-$paste capabilities of Excel to populate the ranges B$6$:C$8$ and E$6$:F$8.$ First, compute the sum in cells B$6$:C$6$ and E$6$:F$6,$ and then copy the ranges B$6$:D$6$ and E$6$:F$6$ through ranges B$7$:C$8$ and E$7$:F$8$ respectively. Finally, calculate $"$# of Students per Room" for the district for each grade level, and for the district as a whole.

$7.$ Select the range E$6$:E$9$ on the District worksheet. Select all the worksheets and then use the Format Cells dialog box to apply a custom format of $[$Red$]$#$,$###;;$-.$

$8.$ Select the range F$6$:F$9$ on the District worksheet. Select all the worksheets and then use the Format Cells dialog box to apply a custom format that will format all nonzero numbers similar to the format applied in Step $6$ but with green for nonzero entries.

$9.$ Use the Cell Styles button $($Home tab $|$ Styles group$)$ to create a new cell style named My Title. Use the Format button $($Styles dialog box$)$ to create a format. Use the Font sheet $($Format Cells dialog box$)$ to select the Britannic Bold font, a font size of $22,$ and a white font color. Check only the Alignment and Font check boxes in the Style dialog box.

$10.$ Select cells A$2$:A$3$ on the District worksheet. Select all the worksheets. Apply the My Title style to the cell.

$11.$ Add custom borders to ALL of the worksheets and make them professional. The borders should be the same on all worksheets.

$12.$ Select the District worksheet. Create a $3-$D pie chart using the range A$6$:B$8.$ Add the title of "Brentwood School District Students by Grade". Apply the Chart Style $3$ to the chart.

$13.$ Move the chart to the right of the data. Right$-$click the pie to display the shortcut menu and then click $$Format Data Series$$ to open the Format Data Series task pane. Set the Pie Explosion to $10\%$ to offset all of the slices.

$14.$ Select the chart area and display the Format Chart Area task pane. Set the X rotation to $100\backslash$deg $.$

$15.$ Use the Chart Elements button to display the Data Labels submenu. Click More Options. Select only the Value and $$Show Leader Lines$$ options. Choose the Outside End label position and adjust the labels as necessary to display the leader lines.

$16.$ Create a header. Add your name on the left side and add your instructor's name on the right side.

$17.$ Update the author $($use your name$)$ and title $($use 'Student'$)$ in the document properties.