BITM 215 exam #1 Question and
answers rated A+ 2025/2026
3D cell reference - correct answer ✔To reference cells in another worksheet, but in the same workbook
in which the current formula resides, use a:
absolute cell reference - correct answer ✔A cell reference with dollar signs such as $B$2
Active Cell - correct answer ✔a selected worksheet cell that is ready for data entry
Alignment - correct answer ✔the position of data within a cell
argument - correct answer ✔cell reference, value or other element required for a function
AutoCalculate - correct answer ✔status bar area that displays calculations for selected cells
border - correct answer ✔outline of a cell range
cell - correct answer ✔The intersection of a column and a row in a worksheet.
cell reference - correct answer ✔The column letter and the row number. Example: B12
chart - correct answer ✔A graphical representation of data
chart layout - correct answer ✔a set of elements and the location of those elements
, Chart object - correct answer ✔an item or element in a worksheet
chart sheet - correct answer ✔A separate sheet in a workbook that stores a chart.
Chart style - correct answer ✔a predefined set of chart colors and fills that you can apply to any chart
circular reference - correct answer ✔An error that occurs when a formula references the cell it is
stored in.
fill handle - correct answer ✔The small black square in the lower right corner of a selected cell
Format Painter - correct answer ✔A tool that enables you to copy formatting from a cell and apply it to
another cell or range.
formula - correct answer ✔A calculation entered by the user for the data in the spreadsheet. e.g.
=(A6+A7)-A5
Formula AutoComplete - correct answer ✔A feature that speeds up the manual entry of functions.
function - correct answer ✔built in formula
function - correct answer ✔built in formula
Gradient - correct answer ✔a blend of two or more colors used as fill
header row - correct answer ✔The first row of the table that is formatted differently and should be
repeated for tables that continue beyond one page.
answers rated A+ 2025/2026
3D cell reference - correct answer ✔To reference cells in another worksheet, but in the same workbook
in which the current formula resides, use a:
absolute cell reference - correct answer ✔A cell reference with dollar signs such as $B$2
Active Cell - correct answer ✔a selected worksheet cell that is ready for data entry
Alignment - correct answer ✔the position of data within a cell
argument - correct answer ✔cell reference, value or other element required for a function
AutoCalculate - correct answer ✔status bar area that displays calculations for selected cells
border - correct answer ✔outline of a cell range
cell - correct answer ✔The intersection of a column and a row in a worksheet.
cell reference - correct answer ✔The column letter and the row number. Example: B12
chart - correct answer ✔A graphical representation of data
chart layout - correct answer ✔a set of elements and the location of those elements
, Chart object - correct answer ✔an item or element in a worksheet
chart sheet - correct answer ✔A separate sheet in a workbook that stores a chart.
Chart style - correct answer ✔a predefined set of chart colors and fills that you can apply to any chart
circular reference - correct answer ✔An error that occurs when a formula references the cell it is
stored in.
fill handle - correct answer ✔The small black square in the lower right corner of a selected cell
Format Painter - correct answer ✔A tool that enables you to copy formatting from a cell and apply it to
another cell or range.
formula - correct answer ✔A calculation entered by the user for the data in the spreadsheet. e.g.
=(A6+A7)-A5
Formula AutoComplete - correct answer ✔A feature that speeds up the manual entry of functions.
function - correct answer ✔built in formula
function - correct answer ✔built in formula
Gradient - correct answer ✔a blend of two or more colors used as fill
header row - correct answer ✔The first row of the table that is formatted differently and should be
repeated for tables that continue beyond one page.
