Question: Create a criteria reference table off to the side of the main data table. This table should include the days of the week listed

Create a criteria reference table off to the side of the main

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

James A. and Ella R. Polk, ages 70 and 65, respectively, are retired physicians who live at 3319 Taylorcrest Street, Houston, Texas 77079. Their three adult children (Benjamin Polk, Michael Polk, and...

Checkout | Hello Bell citations | Cite This F Week 7 Discussions Discussion W 7 - LGS X Learning Activity W7 301 la week 7 - Goog Concagues postings for the week, as mistracted....

Shouldice Hospital in Canada is widely known for one thing hernia repair! In fact, that is the only operation it performs, and it performs a great many of them. Over the past two decades, this small...

To prevent spam from entering your email inbox, you use a filter. You are interested in knowing if the number of spam emails differs by day of the week. The number of spam emails by day of week is...

DAD 2 2 0 Project One Complete the steps below to create three tables named Customers, Orders, and RMA, in the QuantigrationUpdates database. Specifically, you must address the following rubric...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Besides lower expenses, explain another advantage of using electronic payments rather than paper checks.

Write an equation that can take the value of days of 1-41 and calculate the total amount from the followings data of product produced initial amount=2550 production=50 decay= is -1 from production...

Home - koblox ESPN: The Worlawl... Cuncingroll - brows... [ - / 6 Points ] SCALCET 9 3 . 1 0 . 0 4 The edge of a cube was found to be 1 5 cm with a possible error in measu maximum possible error,...

Respond to the following question: The SDLC is composed of a number of phases. In your view, which phase is more important? Identify the phase that you deem to be most important in the sequence, and...

Recent research indicated that about 25% of children in a certain country are deficient in vitamin D. A company that sells vitamin D supplements tests 370 elementary school children in one area of...

Editors preparing a report on the economy are trying to estimate the percentage of businesses that plan to hire additional employees in the next 60 days. They are willing to accept a margin of error...

Identify the three most critical human resource management challenges that multinational companies operating in developing countries face. Explain your answer.

1-How is critical thinking defined? Provide a detailed explanation that demonstrates clear, insightful critical thinking. 2-How can you apply critical thinking in your work? Provide a detailed...

How audit firms can adapt for ESG Reporting for Auditors under Evolving Regulatory Frameworks. 1000 word paragraphs

We can take the approach to selecting a prior distribution for a population proportion p proposed in Exercise 11 one step further. Recall that the variance of a beta random variable, Y, is given by...

Suppose that in our study of schistosomiasis in female mice the p-value was 0.85. Would you be able to conclude that there was no difference between the treatment and control means?

Create a regression model to predict Price from Mileage for the Cavalier data. Calculate the total sum of squares (SST), residual sum of squares (SSE), and regression sum of squares (SSR). Verify...

Suppose you make these monthly RRSP contributions. What amount will you have in the RRSP just after the twelfth contribution?

What will be the nature of the outcome if the rate of return earned by the RRSP is less than the interest rate on the loan?

To what future value will the Question 4 amount grow over the subsequent 19 years?