Conditional Formatting Assessment

This is the file needed to answer this assessment question: Conditional Formatting Question 1

In the file above, everything before the hyphen is a product code and the number after the hyphen is units sold. The letter indicates the product family. In cell B7 I will enter a product family. Determine for each row the product family and units sold. Also highlight all rows of data for the product family selected in cell B7.

This is the file needed to answer this assessment question: Conditional Formatting Question 2

In the file above, you are given the average of world temperatures for years 1880 – 2015. (Data is normalized so 1960 – 1980 is near 0). Create data bars, color scales, and icon sets to summarize this data.

This is the file needed to answer this assessment question: Conditional Formatting Question 3

In the file above create a format which highlights in orange each occurrence of the name entered in cell B4.

This is the file needed to answer this assessment question: Conditional Formatting Question 4

For each day in the file above, columns E:I contain the following:

Opening Price
Did we own stock at beginning of day?
Did we sell the stock that day?
Did we own the stock that day?

Use conditional formatting to highlight the entire row of data for each day the stock was sold. For example, all the date in rows 17 and 19 should be highlighted.