Microsoft Office Tutorials and References
In Depth Information
Creates a shortcut that opens a document on your hard drive, a server, or
the Internet.
HYPERLINK
INDEX
Uses an index to choose a value from a reference or array.
INDIRECT
Returns a reference indicated by a text value.
Returns a value from either a one-row or one-column range or from an
array.
LOOKUP
MATCH
Returns the relative position of an item in an array.
OFFSET
Returns a reference offset from a given reference.
ROW
Returns the row number of a reference.
ROWS
Returns the number of rows in a reference.
RTD
Returns real-time data from a program that supports COM automation.
TRANSPOSE
Returns the transpose of an array.
Searches for a value in the leftmost column of a table and then returns a
value in the same row from a column you specify in the table.
VLOOKUP
* Indicates a function introduced in Excel 2013.
Table A-10: Math & Trig Category Functions
Function
What It Does
ABS
Returns the absolute value of a number.
ACOS
Returns the arccosine of a number.
ACOSH
Returns the inverse hyperbolic cosine of a number.
ACOT***
Returns the arccotangent of a number.
ACOTH***
Returns the hyperbolic arccotangent of a number.
AGGREGATE**
Returns an aggregate in a list or database.
ARABIC***
Converts a Roman number to Arabic, as a number.
ASIN
Returns the arcsine of a number.
ASINH
Returns the inverse hyperbolic sine of a number.
Search JabSto ::




Custom Search