BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Alignment
The position of data between the cell margins
Auto Fill
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
The intersection of a column and row
Column Width
The horizontal measurement of a column
Fill Color
The background color appearing behind data in a cell
Fill Handle
A small green square at the bottom-right corner of a cell
Formula
A combination of cell references, operators, values, and/or functions used to perform a
calculation
Formula Bar
Displays the content (text, value, date, or formula) in the active cell
Input Area
A range of cells containing values for variables used in formulas
Name Box
Identifies the address of the current cell
Order of Precedence
Rules that control the sequence in which Excel performs arithmetic operations
Output Area
A range of cells containing results based on manipulating the variables
Range
A rectangular group of cells
Row Height
The vertical measurement of a row
Sheet Tab
Displays the name of a worksheet within a workbook
Text
Includes letters, numbers, symbols, and spaces
Value
A number that represents a quantity or an amount
Workbook
A file containing related worksheets
Worksheet
A spreadsheet that contains formulas, functions, values, text, and visual aids
Wrap Text
Formatting that enables a label to appear on multiple lines within the current cell
, Absolute cell reference
A designation that provides a permanent reference to a specific cell. When you copy a
formula containing an absolute reference, the cell reference in the copied formula does
not change, regardless of where you copy the formula. An absolute cell reference
appears with a dollar sign before both the column letter and the row number, such as
$B$4.
Argument
A variable or constant input, such as cell reference or value, needed to complete a
function. The entire group of arguments for a function is enclosed in parentheses.
AVERAGE function
A statistical function that calculates the arithmetic mean, or average, of values in range.
Circular reference
A situation that occurs when a formula contains a direct or an indirect reference to the
cell containing the formula.
COUNT function
A statistical function that tallies the number of cells in a range that contain values you
can use in calculators, such as the numerical and date data, but excludes blank cells or
text entries from the tally.
IF function
A logical function that evaluates condition and returns one value if the condition is true
and different condition if the value is false.
Logical test
An expression that evaluates to true or false; the first argument in an IF function.
Lookup table
A range that contains data for the basis of the lookup and data to be retrieved. In
vertical lookup table, the first column contains a list of values to compare the lookup
value. In a horizontal lookup table, the first row contains a list of values to compare the
lookup value.
MAX function
A statistical function that finds the highest value in range.
MEDIAN function
A statistical function that finds the midpoint value, which is the value that one half of the
values in a list are above or below.
MIN function
A statistical function that finds the lowest value in range.
Mixed cell reference
A designation that combines an absolute reference with a relative cell reference, such
as $B4 or B$4.
NOW function
A date & time function that uses the computer's clock to display the current date and
time in a cell.
PMT function
A financial function in Excel that calculates the periodic loan payment.
Range name
GRADED
Alignment
The position of data between the cell margins
Auto Fill
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
The intersection of a column and row
Column Width
The horizontal measurement of a column
Fill Color
The background color appearing behind data in a cell
Fill Handle
A small green square at the bottom-right corner of a cell
Formula
A combination of cell references, operators, values, and/or functions used to perform a
calculation
Formula Bar
Displays the content (text, value, date, or formula) in the active cell
Input Area
A range of cells containing values for variables used in formulas
Name Box
Identifies the address of the current cell
Order of Precedence
Rules that control the sequence in which Excel performs arithmetic operations
Output Area
A range of cells containing results based on manipulating the variables
Range
A rectangular group of cells
Row Height
The vertical measurement of a row
Sheet Tab
Displays the name of a worksheet within a workbook
Text
Includes letters, numbers, symbols, and spaces
Value
A number that represents a quantity or an amount
Workbook
A file containing related worksheets
Worksheet
A spreadsheet that contains formulas, functions, values, text, and visual aids
Wrap Text
Formatting that enables a label to appear on multiple lines within the current cell
, Absolute cell reference
A designation that provides a permanent reference to a specific cell. When you copy a
formula containing an absolute reference, the cell reference in the copied formula does
not change, regardless of where you copy the formula. An absolute cell reference
appears with a dollar sign before both the column letter and the row number, such as
$B$4.
Argument
A variable or constant input, such as cell reference or value, needed to complete a
function. The entire group of arguments for a function is enclosed in parentheses.
AVERAGE function
A statistical function that calculates the arithmetic mean, or average, of values in range.
Circular reference
A situation that occurs when a formula contains a direct or an indirect reference to the
cell containing the formula.
COUNT function
A statistical function that tallies the number of cells in a range that contain values you
can use in calculators, such as the numerical and date data, but excludes blank cells or
text entries from the tally.
IF function
A logical function that evaluates condition and returns one value if the condition is true
and different condition if the value is false.
Logical test
An expression that evaluates to true or false; the first argument in an IF function.
Lookup table
A range that contains data for the basis of the lookup and data to be retrieved. In
vertical lookup table, the first column contains a list of values to compare the lookup
value. In a horizontal lookup table, the first row contains a list of values to compare the
lookup value.
MAX function
A statistical function that finds the highest value in range.
MEDIAN function
A statistical function that finds the midpoint value, which is the value that one half of the
values in a list are above or below.
MIN function
A statistical function that finds the lowest value in range.
Mixed cell reference
A designation that combines an absolute reference with a relative cell reference, such
as $B4 or B$4.
NOW function
A date & time function that uses the computer's clock to display the current date and
time in a cell.
PMT function
A financial function in Excel that calculates the periodic loan payment.
Range name
