excel problem 6

Y/N I can use conditional cell formatting to visually represent data.

Y/N I can create a dashboard using Conditional Formatting.

Y/N I can create a checklist dashboard.

Y/N I can use spark lines to show a trend

Y/N I can create a dashboard using Pivot Table Slicers.

Quiz

  1. T or F You can add more than one set of conditional formatting to the same range of cells. ___________
  2. T or F You can hide gridlines in a worksheet ___________
  3. T or F Once you have set up a conditional formatting rule, you can’t alter it. To make a change you have to delete the rule and create a new one. ____________
  4. What are sparklines used for? ______________

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

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