Spreadsheet packages have a number of common features:
1 of 6
give 3 examples of data types
text/autonumber/currency/date/time/yes-no
2 of 6
list diffent functions
MIN MAX AVERAGE SUM COUNT
3 of 6
what is conditional formatting
Conditional formatting allows you to apply cell shading or font colour to a cell if a specified condition is true, eg if mark is between 90-100 shade cell pale purple and use a bold purple font.
4 of 6
what is data validation
Data validation makes it possible to control the values input into a given cell. For example the number here represents an assignment mark out of 25. In the data validation settings dialogue, you can define the data type (whole number) and range chec
5 of 6
what is the IF f unction
The IF function sets the cell value depending on the result of examining a condition. IF condition is true THEN value 1 ELSE value 2.
Comments
No comments have yet been made