Sign up
Please tick the below box to proceed
I agree (or if I am under 13 my parent or guardian agrees on my behalf) to the terms and conditions of use and that:
- My test statistics may be published on the site leaderboard against my username
- My teacher(s) can review my test scores
- I can receive feedback on my tests from my teacher(s)
Please tick this box to proceed
Already have an account? Sign in
Preview lessons, content and tests
Computer Science & Programming solved. All in one platform.
1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.2. Searching for something specific? See our text overview of all tests. Scroll right for levels, and lists. 3. Student and Teacher User Guides | Schemes of Work | Real Teacher use Videos |
Join 36000+ teachers and students using TTIO.
Formatting
Spreadsheets are often seen as boring and pure tools of utility. It's true that they're useful, but that doesn't mean that we can't bring some style and formatting to our spreadsheets. Good formatting helps your user find meaning in the spreadsheet without going through each and every individual cell. Cells with formatting will draw the viewer's attention to the important cells.
Video on Formatting Cells
VIdeo on Conditional Formatting
Conditional formatting is an incredibly useful tool that allows you to format cells, based on a certain condition. For instance, suppose you were creating a spreadsheet with a list of students and their scores. You could use conditional formatting to turn all the students that have scores above 90% GREEN and all the rest RED!
Additional Resources
Please click here for a link that takes you to a full set of tutorials and reference points provided by Microsoft.