Create a criteria reference table off to the side of the main data table. This table...

Transcribed Image Text:

Create a criteria reference table off to the side of the main data table. This table should include the days of the week listed in order as row labels, with column labels as Total Sales, Disney Video Games, Disney Video Games Bars, and then each Channel: Website, Banner, email, North, South, East West. N Q T V W Monday Tuesday M Wednesday Thursday Friday Saturday Sunday P R Total Sales Disney Video Games Disney Video Games - Bar Only Website Banner Apply the following conditional formatting rules to format the Channel columns: 1. Website: Heat Map/Color Scale 2. Banner: Directional Arrows 3. Email: Data Bars 4. North: 5 ratings 5. South: 3 symbols (uncircled) 6. Fast: Top 50% S email North U South As a good practice you will not type any numbers or text strings as a criterion in your formulas. Create a weekday column using the proper formula to create the weekdays Calculate Total sales for each Weekday in the Total Sales column Calculate the Average sales for each weekday for Disney Video Games in the Disney Video Games column Copy the data over to the next column and use a data bar conditional format, showing bar only Calculate the Total sales for each weekday through each channel in the remaining columns of your table. Your formulas must copy down the columns to calculate sales for all weekdays. East West Create a criteria reference table off to the side of the main data table. This table should include the days of the week listed in order as row labels, with column labels as Total Sales, Disney Video Games, Disney Video Games Bars, and then each Channel: Website, Banner, email, North, South, East West. N Q T V W Monday Tuesday M Wednesday Thursday Friday Saturday Sunday P R Total Sales Disney Video Games Disney Video Games - Bar Only Website Banner Apply the following conditional formatting rules to format the Channel columns: 1. Website: Heat Map/Color Scale 2. Banner: Directional Arrows 3. Email: Data Bars 4. North: 5 ratings 5. South: 3 symbols (uncircled) 6. Fast: Top 50% S email North U South As a good practice you will not type any numbers or text strings as a criterion in your formulas. Create a weekday column using the proper formula to create the weekdays Calculate Total sales for each Weekday in the Total Sales column Calculate the Average sales for each weekday for Disney Video Games in the Disney Video Games column Copy the data over to the next column and use a data bar conditional format, showing bar only Calculate the Total sales for each weekday through each channel in the remaining columns of your table. Your formulas must copy down the columns to calculate sales for all weekdays. East West