Answered step by step
Verified Expert Solution
Link Copied!

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?
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?
image text in transcribed
C (1) aboutblank U7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases On The Web Designing And Programming For Network Access

Authors: Patricia Ju

1st Edition

1558515100, 978-1558515109

More Books

Students also viewed these Databases questions