Answered step by step
Verified Expert Solution
Question
1 Approved Answer
apply conditional formatting to the data in Collumn b that is greater than 2850, how many values are greater than 2850? apply conditional formatting to
apply conditional formatting to the data in Collumn b that is greater than 2850, how many values are greater than 2850?
C (1) aboutblank U7 apply conditional formatting to the data in column E that is less than 1750. How many values are less than 1750?
Apply conditional formatting to the data in column each that is between 1800 and 2300, how many values are between 1800 and 2300?
A very useful tool in conditional formatting is finding duplicate values use conditional formatting to find the value that is duplicated in column K and use you can find it easily. What is that value?
conditional formatting can be used to find the percentage of your data such as top 10% bottom 10% etc. use the top/bottom rules menu to format the top 10% of the observations in column M then answer the questions below.
How many values are formatted?
What is the larger of the values?
What is the smaller of the values?
Apply data bars -> gradient fill to the data in column O. Then making sure to select the same date again sort the data in the data tab using sort, ascending or descending.. what is the largest maximum and smallest minimum value?
max:
min:
Apply color scales to the data in column Q. do not sort the data. at what position (1 being the top and 20 being the bottom.) does the minimum data value occur?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started