Question

______________adds data arranged in an array. It is found in DATA tab *
Scenarios
None of these
Consolidate data
Subtotal​

Answer 1

Explanation:

To change this behavior, enable consolidation subtotals. ... This option adds a subtotal grouped by nothing, effectively calculating a total ... On the Definition tab, click Advanced Options.