Look over the data on this worksheet and consider the following situation: Step 2: Use Conditional Formatting Reid Furnture offered a 20\%, promotion on at purchases made during the first week of March, Add Conditional Formatting for any of the data in columns JO that wil aid in your analysis You are 10 analyze the resuls of this promotion to determine whether the promiotion was: of the benefits of this promotenal sale: Explain why you chose to apply the rule you did. mocesstul and whe ther it should be offered again. Frst. you noed to make a few additional calculations, then you wll analyze the data to determine the success of this promotion. Step 1: Complete the following: Apply Freeze Panes so that the header row and the frst column of the data set ave feed. 5iep 3: Afier applying conditional formating. what conclusions can you make about the promotionsil sales data? Reid Fumiture Store Look over the data on this worksheet and consider the following situation: Step 2: Use Conditional Formatting Reid Furnture offered a 20\%, promotion on at purchases made during the first week of March, Add Conditional Formatting for any of the data in columns JO that wil aid in your analysis You are 10 analyze the resuls of this promotion to determine whether the promiotion was: of the benefits of this promotenal sale: Explain why you chose to apply the rule you did. mocesstul and whe ther it should be offered again. Frst. you noed to make a few additional calculations, then you wll analyze the data to determine the success of this promotion. Step 1: Complete the following: Apply Freeze Panes so that the header row and the frst column of the data set ave feed. 5iep 3: Afier applying conditional formating. what conclusions can you make about the promotionsil sales data? Reid Fumiture Store