BCPT 123 (excel) Exam Questions and
Answers
alignement - Answer-the position the data between the cell margins
auto fill - Answer-enables you to copy the contents of a cell or cell range or to continue a sequence by
dragging the fill handle over an adjacent cell or range of cells
cell - Answer-the intersection of a column or row
column width - Answer-the horizontal measurement of a column
fill color - Answer-the background color appearing behind data in a cell
fill handle - Answer-small green square in the lower-right corner of a selected cell or range of cells
formula - Answer-A combination of numbers and symbols used to express a calculation
formula bar - Answer-displays the content ( text, value, date, or formula) in the active cell
, input area - Answer-the background color appearing behind data in a cell
name box - Answer-identifies the address of the current cell
order of operations - Answer-rules that control the sequence in which Excel performs arithmetic
operations
output area - Answer-a range of cells containing results based on manipulating the variables
range - Answer-a rectangular group of cells
row height - Answer-the vertical measurement of a row
sheet tab - Answer-displays the name of a worksheet within a workbook
text - Answer-includes letters, numbers symbols, and spaces
value - Answer-a number that represents a quantity or an amount
workbook - Answer-a file containing related woeksheets
worksheet - Answer-a spreadsheet that contains formulas, functions, values, text, and visual aids
wrap text - Answer-formatting that enables a label to appear on multiple lines within the current cell
Answers
alignement - Answer-the position the data between the cell margins
auto fill - Answer-enables you to copy the contents of a cell or cell range or to continue a sequence by
dragging the fill handle over an adjacent cell or range of cells
cell - Answer-the intersection of a column or row
column width - Answer-the horizontal measurement of a column
fill color - Answer-the background color appearing behind data in a cell
fill handle - Answer-small green square in the lower-right corner of a selected cell or range of cells
formula - Answer-A combination of numbers and symbols used to express a calculation
formula bar - Answer-displays the content ( text, value, date, or formula) in the active cell
, input area - Answer-the background color appearing behind data in a cell
name box - Answer-identifies the address of the current cell
order of operations - Answer-rules that control the sequence in which Excel performs arithmetic
operations
output area - Answer-a range of cells containing results based on manipulating the variables
range - Answer-a rectangular group of cells
row height - Answer-the vertical measurement of a row
sheet tab - Answer-displays the name of a worksheet within a workbook
text - Answer-includes letters, numbers symbols, and spaces
value - Answer-a number that represents a quantity or an amount
workbook - Answer-a file containing related woeksheets
worksheet - Answer-a spreadsheet that contains formulas, functions, values, text, and visual aids
wrap text - Answer-formatting that enables a label to appear on multiple lines within the current cell