Question

Which describes the conditions that must be met in order to use Subtotal in a spreadsheet? The data must be in adjacent cells and organized in rows using headings. The data must be in adjacent cells and organized in columns using headings. The data must be distributed in different spreadsheets using the same range of cells. The data must be distributed in different tabs within the same spreadsheet using the same range of cells.

Answer 1

The answer is (B): The data must be in adjacent cells and organized in columns using headings.

You can always add subtotals that contain the same function to several columns at the same time. In most cases, subtotals evaluate values based on categories in another column. For instance, when the value in column A changes, the corresponding value in column B is evaluated.