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
- T or F You can add more than one set of conditional formatting to the same range of cells. ___________
- T or F You can hide gridlines in a worksheet ___________
- 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. ____________
- What are sparklines used for? ______________