Page 268 - open office
P. 268
Errors Reasons
Occurs when the cell contains a number, date 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.
A UE! Occurs when a wrong type of argument or operand is used.
AME Occurs when Calc does not recognize text in a formula.
UM! Occurs when there is a problem with a number in a formula or function.
REF! Occurs when a cell reference is not valid.
DI / ! Occurs when a formula is divided by zero.
Recap Zone
A spreadsheet package is an application software that does analysis, calculations, comparisons and
displays information in the required format and in charts and graphs.
A worksheet consists of rows and columns.
Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position.
Columns are the vertical set of rectangular boxes that are placed adjacent to each other.
A rectangular box formed by the intersection of a row and column is called a cell.
The active cell in a worksheet is known as the Cell Pointer.
umeric data consists of digits ( – ), e (Exponential), decimal (.) and numeric operators like , -, /, ,
, . umeric data or values are aligned towards the right side in a cell.
A formula is an expression that helps to perform arithmetical calculations and also executes
non-arithmetical tasks.
A group of cells is known as a cell range.
Each cell in the worksheet has a unique address that is formed by the intersection of its column and
row say A1 .
Navigation is a feature in Calc by which the cursor can be placed anywhere on a sheet directly.
An operator is a symbol that performs certain mathematical or logical operations.
Functions are in-built formula in ‘Calc’ that can be used to perform arithmetical and non-arithmetical
task.
ame is the name of the function that signifies the nature of operation.
Argument specifies the values or the range of cells on which the specific operation is being applied
and is always enclosed within the opening and closing parenthesis.
26 Touchpad Information Technology-IX

