On the Bonnet worksheet, in cell A1, apply the Heading 1 cell style. Group the four faculty worksheets, fill the contents of cell B3 from the Bonnet worksheet to the other three faculty worksheets. Use the option that fills all. Ungroup the worksheets and change the values in cell B3 in these sheets: Hoffman $200, Myeong $350, Stathopoulos $400. When the error message displays, click No, type 350, and press ENTER.


Group the four faculty worksheets. Select the range A1:A6 in the Bonnet worksheet and fill across the other grouped worksheets.


With the sheets grouped, change the width of column A to 26.


With the sheets grouped, enter the SUM function in cell B6 of the Bonnet worksheet to total her expenses.


With the sheets grouped, format cells B3 and B6 with Accounting Number Format with zero decimal places. Format the range B4:B5 with Comma Style with zero decimal places.


With the sheets grouped, apply Underline to cell B5 and Double Underline to cell B6. Ungroup the worksheets.


Note, use the Format Cells dialog box to ensure that the Underline styles Single and Double are applied, rather than Single Accounting or Double Accounting