Question

You want to use the Subtotal feature to display the average total deposit by number of bedrooms for each apartment complex. Use the Subtotal feature to insert subtotal rows by Apartment Complex to 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.

Answer 1

To use the Subtotal feature in Microsoft Excel, select the data range and use the 'Data' tab to access the 'Subtotal' button. In the 'Subtotal' dialog box, choose the grouping criteria and the aggregate function. Repeat the process to add another subtotal.

Step-by-step explanation:

To use the Subtotal feature in Microsoft Excel, follow these steps:

• First, make sure your data is properly organized, with each row representing an apartment and each column representing a specific attribute (such as Apartment Complex, # Bed, and Total Deposit).
• Select the entire range of data that you want to subtotal.
• Go to the 'Data' tab in the Excel ribbon and click on the 'Subtotal' button, usually located in the 'Outline' section.
• A 'Subtotal' dialog box will appear. In the 'At each change in' dropdown, select 'Apartment Complex'. Make sure the 'Total Deposit' checkbox is checked.
• Click on the 'Add subtotal to' dropdown and select 'Average'.
• Click on the 'OK' button to apply the subtotals.
• To add a second subtotal by '# Bed', repeat steps 3 to 6, selecting '# Bed' instead of 'Apartment Complex'.

The Subtotal feature will insert subtotal rows for each Apartment Complex and # Bed, calculating the average Total Deposit for each group.

Answer 2

Answer:One of the lesser-known features of Excel is its ability to automatically generate subtotals on multiple levels using the application's Subtotal feature. If you keep sales figures in your worksheet, for example, you can create subtotals for sales in each region, plus nested subtotals broken down by state and even city. To implement multiple-level subtotals, first use Excel's advanced sorting function to rearrange your data into the right grouping levels.

Step-by-step explanation: