Multiple Choice
All of the following statements are TRUE regarding PivotTables EXCEPT:
A) Multiple PivotTables are allowed on one worksheet for comparison and analysis purposes.
B) Prior to creating a PivotTable, any desired calculated fields should be added.
C) PivotTables can be created on a new worksheet or an existing worksheet.
D) PivotTables automatically expand and contract on a worksheet as variables are added, removed, or rearranged.
Correct Answer:
Verified
Correct Answer:
Verified
Q90: A(n)_ is an object that sits or
Q91: Which of the following is NOT a
Q92: Pressing _ allows you to select multiple
Q93: It is better to use PivotTables for
Q94: It is NOT recommended to use the
Q95: Standard functions can be applied to filtered
Q96: When filtering data,records that are on hidden
Q97: If a set of data is not
Q99: The PivotTable _ tab focuses on formatting
Q100: The context-sensitive tabs available to aid in