Dirty data is ___

Which of the following statements is TRUE about data types and delimiters?

A) Date fields are enclosed in quotation marks. B) Different data types require different delimiters. C) Numeric fields require quotation marks as delimiters. D) All data types use the same delimiters.

All of the following statements are TRUE regarding PivotTable and PivotChart best practices EXCEPT:

A) Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate. B) Once you have selected your data, ensure the source data are arranged in an area with column headings representing each field and the rows representing each record. C) Distinguish fields as either grouping variables or slicer variables. D) Know who your audience is prior to developing your PivotTable or PivotChart. It could make a difference in how much detail you display.