(Solved): A very useful tool in Conditional Formatting is finding duplicate values. Use Conditional Formatting ...
A very useful tool in Conditional Formatting is finding duplicate values. Use Conditional Formatting to find the value that is duplicated in Column K so your end user can find it easily. What is that value?
fill in the blank 5
Top 10%
Conditional Formatting can be used to find a 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?
fill in the blank 6
What is the larger of the values?
fill in the blank 7
What is the smaller of the values?
fill in the blank 8
Gradient Fill
Apply Data Bars -> Gradient Fill to the data in Column O. Then, making sure to select that same data again, sort the data in the Data tab using Sort Ascending (or Descending). What is the largest (maximum) and smallest (minimum) value?
| Maximum: | fill in the blank 9 |
| Minimum: | fill in the blank 10 |
Color Scale
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?
fill in the blank 11