Where does Quick Analysis insert totals when calculating totals for the selected cells?

Where does Quick Analysis insert totals when calculating totals for the selected cells?

• A. In the same row, next to the selected range.
• B. In the empty row below the cell range.
• C. In a new worksheet.
• D. In the adjacent column to the right.

Answer: (B)

Quick Analysis is designed to summarize a block of data by adding a totals row right beneath the selected cells. This means the totals appear in the row immediately below the last row of your data, showing a sum (or other total) for each numeric column. It isn’t placed in the same row, in a new worksheet, or in the adjacent column—the row below the data must be empty to accommodate the totals.

Quick Analysis is designed to summarize a block of data by adding a totals row right beneath the selected cells. This means the totals appear in the row immediately below the last row of your data, showing a sum (or other total) for each numeric column. It isn’t placed in the same row, in a new worksheet, or in the adjacent column—the row below the data must be empty to accommodate the totals.