Dear Teachers,
These slides have been prepared based on the SCERT syllabus to support you in teaching Plus One and Plus Two Accountancy and Computerised Accounting.
Please review and verify the content before using it in your classrooms. If you find any errors or have feedback, please let me know.
Mujeeb Rahiman C
HSST Commerce
GHSS Pattikkad
Malappuram Dt.
✉️ mujeebchemmala@gmail.com
9995983075 �
LibreOffice Calc
Chapter- 2
Spreadsheet Functions
Spreadsheet Functions
Spreadsheet functions are used for searching certain value from a particular table. It is used when we need to look in a single row or column range and find a value from the same position in another row or column.
Spreadsheet Functions
5. ROWS
6. COLUMNS
Commonly used spreadsheet functions are : -
1. LOOKUP (Vector form)
Syntax
=LOOKUP(SearchCriterion,SearchVector,ResultVector)
Where
SearchCriterion - The value to be searched for. (Number/Text/logical value)
SearchVector – Single row or column to be searched (Sorted in ascending order)
ResultVector – Single row or column from which the result is taken
1. LOOKUP (Vector form)
=LOOKUP(SearchCriterion,SearchVector,ResultVector)
2. LOOKUP (Array form)
Syntax :
=LOOKUP(Lookup_Value,Array)
Where
Lookup_Value - The value to be searched for.
Array – An array is a linked range of cells on a spreadsheet containing values. Where you are looking
2. LOOKUP (Array form)
=LOOKUP(Lookup_Value,Array)
3. VLOOKUP
VLOOKUP stands for Vertical Lookup. It searches the first column of an array and return the value from another column named in the index, in the same row.
Syntax: =VLOOKUP(SearchCriterion,Array,Index,SortOrder)
Where
SearchCriterion -The value to be searched for. (Column data in ascending order)
Array – Where you are looking
Index – The column number in the table
Sort Order – Give ‘0’ for precise value and ‘1’ for approximate value
3. VLOOKUP
=VLOOKUP(SearchCriterion,Array,Index,SortOrder)
Index
1 2 3 4 5
4. HLOOKUP
HLOOKUP stands for Horizondal Lookup. It searches for a value in the first row of an array and returns the corresponding value from another row named in the index, in the same column.
Syntax: =HLOOKUP(SearchCriterion,Array,Index,SortOrder)
Where
SearchCriterion - The value to be searched for. (Row data in ascending order)
Array – Where you are looking
Index – The row number in the table
Sort Order – Give ‘0’ for precise value and ‘1’ for approximate value
4. HLOOKUP
=HLOOKUP(SearchCriterion,Array,Index,SortOrder)
1
2
3
4
5
6
5. ROWS
This gives back the number of rows in a range of cells
Syntax =ROWS(Array)
Where
Array - is the named area whose total number of rows is to be determined
6. COLUMNS
This gives back the number of columns in a range of cells
Syntax =COLUMNS(Array)
Where
Array - is the named area whose total number of columns is to be determined
MUJEEB RAHIMAN C
HSST COMMERCE
GHSS PATTIKKAD
MALAPPURAM DT