Page 208 - CA 165 ver 1.0 Class 9
P. 208
COMMON ERRORS
Sometimes when we use wrong type of data, operand or operator in a formula, then error message gets
displayed. Given below is the list of errors which commonly occur in ‘Calc’.
Errors Reasons
Occurs when the cell contains a number, data or time that is wider than the cell
#### width or when the cell contains a date and/or time formula that produces a
negative result.
#VALUE Occurs when a wrong type of argument or operand is used.
#NAME Occurs when ‘Calc’ does not recognize text in a formula.
#NUM Occurs when there is a problem with a number in a formula or function.
#REF! Occurs when a cell reference is not valid.
#DIV/0! Occurs when a formula is divided by zero.
SORTING
Sorting refers to the process of arranging data in ascending or descending order based on a certain criteria.
To Sort data:
Step 1: Select the column/row whose data is to be sorted.
Step 2: Click on ‘Sort’ option from ‘Data’ menu.
2
1
Step 3: ‘Sort’ dialog box appears on the 4 5
screen.
Step 4: Select the column to be sorted.
Step 5: Click on Ascending/Descending check
boxes.
Step 6: Click on ‘OK’ button. The table will be
sorted based on the specified field.
206 Touchpad Computer Applications-IX

