USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You CAN use the Subtotal feature with an Excel table.
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -This can be done as shown below: Select the Data tab, and click on SUBTOTAL. Now, click the drop-down arrow for the “At each change in: field.” We can now select the column we wish to subtotal.
There is 1 question to complete.