USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
For the Subtotal feature to work, all records containing values that contribute to that subtotal must be ____ together.
|
|
SORTED
|
|
|
NOW
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The Subtotal feature requires that your values be grouped. This means that you must sort your data by the group values before you implement the Subtotal feature.
Detailed explanation-2: -The SUBTOTAL function ignores any rows that are not included in the result of a filter, no matter which function num value you use. The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges.
There is 1 question to complete.