Level 26 Level 28
Level 27

Lookup and reference functions


13 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
ADDRESS
Returns a reference as text to a single cell in a worksheet
AREAS
Returns the number of areas in a reference
COLUMN
Returns the column number of a reference
COLUMNS
Returns the number of columns in a reference
GETPIVOTDATA
Returns data stored in a PivotTable report
HYPERLINK
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
INDIRECT
Returns a reference indicated by a text value
LOOKUP
Looks up values in a vector or 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
Retrieves real-time data from a program that supports COM automation
TRANSPOSE
Returns the transpose of an array