Assignment: Open Assignment data file . Sales transactions for the first 3 months of the year are in this file. This includes: Date: data of transactions. Channel: The store or online 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 Create a table to calculate and format total daily sales, and total sales for each channel, each weekday. As a good practice you will not type any numbers or text strings as a criterion in your formulas. Calculate total daily sales for each day in the first column and total sales for each day through each channel in the first row of the table. Your formulas must copy down the columns to calculate sales for all weekdays. Use the following conditional formatting rules to format these columns: Website: 3 symbol indicators Banner: data bars. Show only the bars, not numbers Email: above average North: color scale South: 5 rating bars East: 5 arrows directional West: top 50% Use conditional formatting to apply a light green background color to the entire rows in data range, where sales value of the item is less than $1000.