MS Excel Vocab Flashcard

Front

to format your data or document in a way that can be used by another application

Back

export

Front

to add or use data from another application

Back

import

Front

to combine into one, usually used to make two cells into one

Back

merge

Front

a formula or equation used to generate a specific answer

Back

function

Front

to combine or merge strings of text, such as combining a first and last name into the same cell

Back

concatenate

Front

a tool used to fill in a selected field or cells with a copy of existing data, or continue the pattern of existing data

Back

autofill

Front

the vertical sections of a spreadsheet noted by capital letters

Back

column

Front

the horizontal sections of a spreadsheet noted by numbers

Back

row

Front

naming or referring to a cell by their row and column in which it lies; the first cell would have a cell location of A1

Back

cell location

Front

 The part of the spreadsheet you are currently working in, denoted by a tab at the bottom of the window

Back

sheet