Which describes the conditions that must be met in order to use Subtotal in a spreadsheet?

Subtotal works with a single, continuous data list arranged in columns, with a heading at the top of each column. Each row should contain one record, and the headings identify the values that can be grouped and summarized. So the correct choice is “The data must be in adjacent cells and organized in columns using headings.”

AI-written and checked against the verified answer.