Functions Flashcards
Trim
Removes spaces from text
Length
Calculate length of text in cell
CONCATENATE function
Joins several text items into one text item
V lookup
look for a specified value by searching for it vertically across the sheet
column index number
the number of columns Excel must count over to find the matching value
lookup value
a cell from og data that is also on new data
clean
Removes non printable characters
substitute
Substitutes new text for old text in a text string
array
multiple cells
cell
individual box where data goes
function
pre built formulas
formula
starts with = used to get a value from cells
Workbook
Excel spreadsheet file
Worksheet
Individual spreadsheet. Designated by tavs at the bottom
Operator
symbols or signs that indicate which calculation must be made in an expression
