Worksheet 3-Rooms Average Pivot Table. The Operations Manager would like to see, on average, how many rooms are being used for the reporting period. 3.1.Your worksheet should have an appropriate heading with the date. The heading should be formatted appropriately. 3.2.From the raw data, create a pivot table which provides the average rooms used per heading (Day-Use, Walk in, In House, Arrive) for the reporting period. Worksheet 4 -Graph The Operations Manager would like to see the occupancy rate visually represented as a graph. 4.1.Your worksheet should have an appropriate heading with the date. The heading should be formatted appropriately. 4.2.Using the data from the "summary" worksheet, insert an appropriate graph to visually represent the hotels occupancy rate by heading. 4.3.The Graph must be formatted in a way that best represents the data