Multiple Choice
All of the following statements are TRUE regarding the function_num argument of the SUBTOTAL function EXCEPT:
A) This argument informs Excel which function to use on the subset of records.
B) One set of function_num values will include both filtered and hidden data.
C) One set of function_num values will include only filtered data.
D) One set of function_num values will include only hidden data.
Correct Answer:
Verified
Correct Answer:
Verified
Q48: Which of the following statements regarding PivotTables
Q49: _ variables are data that can be
Q50: To change a table back to a
Q51: Format the PivotTable or PivotChart so it
Q52: PivotTable data formatted through the _ dialog
Q54: A filter is a standard part of
Q55: When using the SUBTOTAL function,entering a number
Q56: The _ filter displays the values in
Q57: _ is a process of hiding records
Q58: Any records that should not be used