Please enable JavaScript.
Coggle requires JavaScript to display documents.
unit 8 spreadsheets (functions (date and time functions (NOW, TIME, SECOND…
unit 8 spreadsheets
functions
-
-
-
lookup functions:
VLOOKUP: =VLOOKUP(Search Value, Lookup Table, Column, Match)
HLOOKUP: =HLOOKUP(Search Value, Lookup Table, Row, Match)
-
The INDEX function
We'll start with an overview of the INDEX function. Simply put, INDEX takes a cell range and returns a cell within that range based on a count provided by the user. The formula looks like this:
=INDEX(range, row_or_column)
-
The MATCH function
The MATCH function returns the position of a cell within an array by matching against a criteria string. The formula looks like this:
=MATCH(lookup_value, lookup_range, match_type)
-
-
protecting cells- format cells, protection..
-
-
-
-
-
-
-
-
-
-
relative cell referencing: it is used when you want the content of a cell to change based on its relation to its row and column position. Often the formulae being used are performing the same calculation and when this happens it is possible to replicate the formula.
absolute referencing is used when you do not want a cell reference to change when other cells are filled in or when replicating formulae.
$ this symbol is used.
named cells are when a name is used instead of the cell reference. Named cells can be used as absolute cell references.
a named range is when a name is used instead of cell references.