Select the Summary sheet. Sort the data by Apartment Complex in alphabetical order and further sort it by # Bed (the number of bedrooms from smallest to largest. You want to use the Subtotal feature to display the average total depos by number of bedrooms for each apartment complex. Use the Subtotal feature to insert subtotal rows by Apartment Complex calculate the average Total Deposit. Add a second subtotal (without removing the first subtotal) by # Bed to calculate the average Total Deposit by the number of bedrooms. Use the outline symbols to display only the subtotal rows. Create an automatic outline and collapse the outline above Total Deposit