Excel and Data Terminology

Front

CONCAT

Back

An Excel function that allows for data from multiple cells to be combined.

Front

CSV

Back

A file containing data that is separated by commas.

Front

Delimiter

Back

A character used to separate individual pieces of data.

Front

Hyperlink

Back

A feature that takes the user to another location either within the document, an external file, or a website.

Front

LOWER

Back

An Excel function that converts every letter to lowercase.

Front

PROPER

Back

An Excel function that allows the first letter of every word to be capitalized.

Front

String

Back

A collection of characters upon which no mathematical calculations are to be performed (such as letters, Zip Codes, and telephone numbers, for example).

Front

Text

Back

A collection of letters that have meaning.

Front

TEXTJOIN

Back

An Excel function that combines data from multiple cells into a list separated by a delimiter.

Front

TXT

Back

A file that contains data that is commonly separated by tabs.