Date: data of transactions.

Channel: The storeoronline channel the merchandise sold. North, South, East, and West stores. Company Website, link followed from an email, or link from a banner advertising.

Customer: New, purchasing the first time or Member, have past transactions

Category: Appliance, Camera, Computer, Phone, Toys, and TV.

Brand: Manufacturer brand

Type: Merchandise information

Sale: Sale price

COGS: Cost of merchandise for store

a) Weekdays

• List weekdays (Monday-Sunday) in range "K2:K8". These weekdays are row headers for a table of calculations. Start from cell K2 to leave a few rows on top for referenced values.
• Use a formula in cell L2 to calculate total sales for Monday. Reference cells and ranges appropriately and copy this formula down through cell L8. Each cell should calculate total sales of the weekday listed in column K in the same row.

As a good practice you will use only cell references in your formulas. Refrain from manually typing out criteria in your formulas.

b) Use a formula in cell M2 to calculate total sales of 60 TVs on each respective day of the week. 60 TVs are identified in "Type" column by number "60".

c) Reference column M TV sales numbers in column N so that all sales in column "N" equal those from column "M" and use conditional formatting to create data bars in this column. These data bars should show bars only, not numbers.

d) In rows 2-8, columns O through U calculate total sales for each weekday via each respective channel. List channels in this order in row 1 and reference them: Website, banner, email, North, South, East, and West. Your formulas must copy down the columns to calculate sales for all weekdays. Use the following conditional formatting rules to format these columns:

1. 1. Website: 5 arrows directional
   2. Banner: 5 rating bars
   3. Email: data bars (with numbers)
   4. North: color scale
   5. South: above average
   6. East: 3 symbol indicators
   7. West: Greater than 5,000