A B C TITLE THINK LIKE AN ACCOUNTANT Chapter 12 ANALYSIS The Analysis worksheet contains the ratings for Week 14 including an average of the four question scores, the average scores for the prior week, and the change in the average weekly scores Gerald Murphy has asked you to devise a way to view the performance of his sales representatives without having to use a series of sorts and filters. Use conditional formatting to provide Gerald with the information required to answer the questions STEPS 1 Read all steps before working with this workbook 2 Click the Analysis tab to view the ratings for Week 14 3 Key your name in cell C2 To apply conditional formatting: 5 On the Home tab in the Seed broup( chek Conditional Fermenting G Select Icon Sers