Sort the cell range A$3$ through E$33$ alphabetically by the type of room.

$10.$ Using the Subtotal feature, apply a subtotal to the cell range A$2$ through E$33,$ such that it groups by

room type, includes a Sum for only the Qty and Total columns, applies a page break between

groups, and sets the total summary so that it displays above the data.

$11.$ Adjust the outline level so that only the room totals and grand total are displayed.