Excel Exam
spreadsheet - ANSan electronic file that contains a grid of columns and rows containing related
data
worksheet - ANSs spreadsheet that contains formulas, functions, values, texts, and visual aids
workbook - ANSa file containing related worksheets
input area - ANSa range of cells containing values for vairables used in formulas
output - ANSa range of cells containing results based on manipulating the variables
name box - ANSidentifies the address of the current cell
formula bar - ANSdisplays the content (text, value, date, or formula) in the active cell
sheet tab - ANSdiplays the name of a worksheet within a work-book
cell - ANSthe interesection of a column letter and a row number
cell address - ANSidentifies a cell by a letter and a ro number
active cell - ANSthe current cell, indicated by a dark border
text - ANSincludes letters, numbers, symbols, and spaces
value - ANSa number that represents a quantity or an account
formula - ANSa combination of cell refrences, operators, values, and or functions used to
perfom a calculation
range - ANSa rectangular group of cells
nonadjacent range - ANScontains multiple ranges of cells
semi-selection - ANSthe process of using the mouse pointer to select cells while building a
formula
relative cell reference - ANSindicates a cell's relative location from the cell containing the
formula, the cell reference changes when the formula is copied
spreadsheet - ANSan electronic file that contains a grid of columns and rows containing related
data
worksheet - ANSs spreadsheet that contains formulas, functions, values, texts, and visual aids
workbook - ANSa file containing related worksheets
input area - ANSa range of cells containing values for vairables used in formulas
output - ANSa range of cells containing results based on manipulating the variables
name box - ANSidentifies the address of the current cell
formula bar - ANSdisplays the content (text, value, date, or formula) in the active cell
sheet tab - ANSdiplays the name of a worksheet within a work-book
cell - ANSthe interesection of a column letter and a row number
cell address - ANSidentifies a cell by a letter and a ro number
active cell - ANSthe current cell, indicated by a dark border
text - ANSincludes letters, numbers, symbols, and spaces
value - ANSa number that represents a quantity or an account
formula - ANSa combination of cell refrences, operators, values, and or functions used to
perfom a calculation
range - ANSa rectangular group of cells
nonadjacent range - ANScontains multiple ranges of cells
semi-selection - ANSthe process of using the mouse pointer to select cells while building a
formula
relative cell reference - ANSindicates a cell's relative location from the cell containing the
formula, the cell reference changes when the formula is copied
