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.