All of the following statements are TRUE regarding PivotTables EXCEPT:

A) Prior to creating a PivotTable, any desired calculated fields should be added.
B) Multiple PivotTables are allowed on one worksheet for comparison and analysis purposes.
C) PivotTables automatically expand and contract on a worksheet as variables are added, removed, or rearranged.
D) PivotTables can be created on a new worksheet or an existing worksheet.


B

Computer Science & Information Technology

You might also like to view...

The definition of PII:

a. Is name, date of birth, and home address b. Is name, date of birth, home address, and home telephone number c. Is name, date of birth, and social insurance number d. Varies by jurisdiction and regulation

Computer Science & Information Technology

Mark as Final signifies the intent of the author that the document is finalized and makes the document:

A) ready to edit. B) password protected. C) ready to save. D) read only.

Computer Science & Information Technology

Alice allows you to see the effects of your programs and any changes you make to them.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

When looking at a dashboard panel that is based on a report, which of the following is true?

A. You can modify the search string in the panel, and you can change and configure the visualization. B. You can modify the search string in the panel, but you cannot change and configure the visualization. C. You cannot modify the search string in the panel, but you can change and configure the visualization. D. You cannot modify the search string in the panel, and you cannot change and configure the visualization.

Computer Science & Information Technology