EA3-c1

um n e ls (aside from inventory listings) for which the use of conditional formatting would improve the readability and effectiveness of a work- sheet. Write a paragraph of at least six sentences to discuss the specific data for which condi- tional formatting would be applied and why doing so would provide a benefit to the end user. A4-C2 Discuss PivotTables and PivotCharts in an Accounting Environment Pivot Tables and PivotCharts allow for efficient and flexible analysis of a data set. Although you focused on inventory listings in this chapter, these powerful analysis tools can be applied to many other accounting-related items as well. Businesses that become more adept at using these tools can benefit greatly. Decision-making is enhanced when the proper data is analyzed effectively, and Pivot Tables and PivotCharts allow for this type of analysis. Write a paragraph of at least four sentences in which you identify four data sets (aside from an inventory listing) for which a business might use a PivotTable and PivotChart to complete an analysis. Write a second paragraph of at least six sentences to discuss how a Pivot Table and a PivotChart would enhance the analysis of these data sets. um n e ls (aside from inventory listings) for which the use of conditional formatting would improve the readability and effectiveness of a work- sheet. Write a paragraph of at least six sentences to discuss the specific data for which condi- tional formatting would be applied and why doing so would provide a benefit to the end user. A4-C2 Discuss PivotTables and PivotCharts in an Accounting Environment Pivot Tables and PivotCharts allow for efficient and flexible analysis of a data set. Although you focused on inventory listings in this chapter, these powerful analysis tools can be applied to many other accounting-related items as well. Businesses that become more adept at using these tools can benefit greatly. Decision-making is enhanced when the proper data is analyzed effectively, and Pivot Tables and PivotCharts allow for this type of analysis. Write a paragraph of at least four sentences in which you identify four data sets (aside from an inventory listing) for which a business might use a PivotTable and PivotChart to complete an analysis. Write a second paragraph of at least six sentences to discuss how a Pivot Table and a PivotChart would enhance the analysis of these data sets