Question 18: What type of conditional formatting is this? A 1 8 2 14 3 3 7 9 4 5 6 22 3 3 Answer: A. O Icon Set B. O Color Scale C. Data Bars D. Highlight Cell Rules Question 19: Which statement is incorrect regarding PivotCharts? Answer: A. When you change a PivotChart, the associated PivotTable updates automatically. B. PivotCharts are created only after a Pivot Table has been established. C. O A PivotChart can be filtered using the AutoFilter buttons on the associated Pivot Table. D PivotCharts can display a legend beside the charted data. Question 23: Which statement is correct regarding conditional formatting? Answer: A. The order in which a rule is applied depends on the type of conditional formatting. B. Only one conditional formatting rule can be applied to a cell. C. Use Stop It True to prevent formatting from being applied after a criterion is evaluated as true. D. You can't customize conditional formatting rules, but you can reset them. Question 24: What is a disadvantage of importing external data? Answer: A. O It doesn't work with PDF files. B. The imported data remains tied to its original location, which can skew data in the destination file. C. It can result in a loss of formatting. D. There are restrictions on how much data can be imported