Week Ending 17/11/06

During this week, in class and at home i have learnt bits a pieces about spreadsheets. I have learnt about Conditional Formatting which format cells depending on their contents or those of another cell. I have also learnt about how to set up a system within the spreadsheets, i can now password protect certain cells that i don't want other people to edit e.g. cells with formulas etc. During task 2, i also not only learnt about passwording cells but about passwording the entire spreadsheets, upon making a system i can use the Validation function which means i can set rules which will determine whether data entered into a cell is valid for your application. I have a number of options which can be set:

• Data type (whole number, decimal, date, time)
• Text length
• Range check
• List check

During task three, i am beging to learn about the IF function and various other Conditional Functions, i am already kind of familar with the IF function as i use it in PHP when coding websites but the IF function in excel i slightly different which i am now currently learning.