Table $5-8$ Middle School Classroom Capacity Figures

On the two school worksheets, calculate Average Students per Room in column $D$ and totals in row $9.$

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 average students per room for the district for each grade level,

and for the district as a whole.

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$]$#$,$###;;$"-".$

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.

Use the Cell Styles button $($Home tab I 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.

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

to the cell.