Multiple Choice
Which of the following statements about filtering is NOT TRUE?
A) Filtering makes it possible to view specific data.
B) The filtering function can be applied to only one data set on a worksheet.
C) Filters can only be established on an Excel table.
D) Filtering enables a user to examine and analyze a subset of records.
Correct Answer:

Verified
Correct Answer:
Verified
Q2: When using the _ Filter feature,filtering criteria
Q3: All of the following statements are TRUE
Q4: Users can change the look of an
Q5: To _ data means to consolidate or
Q6: All of the following statements are TRUE
Q8: A PivotTable can be created on a
Q9: The _ function will run calculations on
Q10: By default,PivotTables show a _ for both
Q11: If the criteria range for the Advanced
Q12: All of the following statements are TRUE