Page 222 - CA_165_V2.0_C9_Flipbook
P. 222
COMMON ERRORS
Sometimes, when we use the wrong type of data, operand, or operator in a formula, an error message
is displayed. Given below is the list of errors which commonly occur in OpenOffice Calc.
Cell error 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.
Occurs when a function name is typed incorrectly, a named range is undefined,
#NAME?
quotation marks for text are misused, or an undefined constant or function is used.
Occurs when there is an invalid numeric operation, such as performing calculations
#NUM! on out-of-range numbers, taking the square root of a negative number, or dividing
by zero. It can also happen if the result is too large or too small.
The formula within the cell uses a reference that does not exist. Either a column
#REF! or row description name could not be resolved, or the column, row, or sheet that
contains a referenced cell is missing.
#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, follow these steps:
Step 1: Select the column or range of data to be sorted.
Step 2: Click the Data menu on the menu bar.
Step 3: Select the Sort option from the drop-down menu. The Sort dialog box will appear.
220 Touchpad Computer Applications (Ver. 2.0)-IX

