Winter CS W7 – More Excel

In Excel, demonstrate conditional formatting, the countif function, and 1 other function of your own choosing. You will need to find or create your own data for this!

TUTORIAL (Conditional Formatting)
TUTORIAL (Countif Function)

Upload your file as a response to this post.

 

For this challenge I submitted the following file:

Done. I used INDEX(MATCH()) to find the date of the highest Rental Cost.

Leave a Reply

Your email address will not be published. Required fields are marked *