Clear all rules (see Question 16 if you have forgotten how to clear all rules). Highlight cells B2:H8. Within the Conditional Formatting menu, find the rule to highlight the Top 10%. How many scenarios are highlighted?

Practice More Questions From: Week 3 Assessment

Q:

Construct the Box and Whisker Plot. How many outliers are there?

Q:

According to the Box and Whisker plot, which of the following statements is true?

Q:

According to the Box and Whisker plot, which of the following statements is true?

Q:

According to the Box and Whisker Plot, what is the inter-quartile range?

Q:

What will the conductor of the survey hope to achieve if they conduct a second round of surveys?

Q:

The conductor of the survey has now conducted a second round of surveys. The results are presented in the sheet, Delphi2, alongside the results of Round 1. How many outliers are there?

Q:

What would the conductor of the survey aim to achieve if they conduct a third round of the survey?

Q:

Even though the Box and Whisker Plots of Round 1 and Round 2 are quite different, they both have a similar:

Q:

It has been noted that our sales depend on two factors: positively on income ($s) and negatively on the interest rate (%). We have calculated that our Sales depends on the equation:Sales (units) = 10000 + (-10000 x Interest Rate) + (2 x Income)(You can use the value of the interest rate and income exactly as they appear in the spreadsheet without altering them).The sheet ScenarioAnalysis depicts different scenarios from low to high interest rates and low to high incomes.What is the value of Sales (units) for a scenario that has low income and a low interest rate, assuming that Income is $50,000 and the Interest Rate is 0.5%?

Q:

What is the value of Sales (units) for a scenario that has high income and a high interest rate, assuming that Income is $80,000 and the Interest Rate is 3.5%?

Q:

What is the ideal scenario for our sales?

Q:

When inputting the Excel formula: Sales (units) = 10000 + (-10000 x Interest Rate) + (2 x Income),into cell B2, so that you can fill down and fill across the entire sheet, what is the correct way to reference cell B1?

Q:

When inputting the Excel formula: Sales (units) = 10000 + (-10000 x Interest Rate) + (2 x Income),into cell B2, so that you can fill down and fill across the entire sheet, what is the correct way to reference cell A2?

Q:

Click on Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet. What happens?

Q:

Highlight cells B2:H8,click on Conditional Formatting > Icon Sets. Select the star icon set under Ratings.How many scenarios have a full Star rating?

Q:

Continue from Question 17. Now add $10,000 to all values of income in Column A.How many scenarios have a full Star rating?

Q:

Adjust the formulas in each of the cells to reflect a new equation for Sales: Sales (units) = 10000 + (-10000 x Interest Rate) + (1.5 x Income)What is the new value of sales for the scenario that has the highest interest rate and the highest income?

Q:

Clear all rules (see Question 16 if you have forgotten how to clear all rules). Highlight cells B2:H8.Within the Conditional Formatting menu, find the rule to highlight the Top 10%.How many scenarios are highlighted?

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments