Discuss why a dataset must be sorted by a category before using the Subtotal feature.
What will be an ideal response?
If the data are not sorted by a major category, the subtotaled results will not be correct. The Subtotals dialog box uses the At a change in setting to indicate how the data are sorted. Excel identifies changes between rows to “know” when to insert a subtotal row.
You might also like to view...
The range of valid index values for an array name runs from 0...name.length.
Answer the following statement true (T) or false (F)
Big data analytics is usually associated with ________ services
A) data warehouse B) management information C) decision support D) office support
Companies are classified into economic sectors according to the types of goods and services they provide.
Answer the following statement true (T) or false (F)
The books and manuals in a troubleshooter's personal or professional library are part of the troubleshooter's knowledge base.
Answer the following statement true (T) or false (F)