BITM 215 - EXAM 1 (CHAPTERS 1-4) STUDY GUIDE
Worksheet - Answer -A spreadsheet that contains formulas, functions, values, text &
visual aids
Workbook - Answer -A file containing related worksheets
Name Box - Answer -Identifies the address of the current cell
Formula Bar - Answer -Displays the contents stored in the active cell
Sheet Tab - Answer -Displays the name of a worksheet within a workbook
Cell - Answer -The intersection of a column and a row
Output Area - Answer -A range of cells containing values for variables used in a
formula
Text - Answer -Includes letters, numbers, symbols, and spaces
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
Fill Handle - Answer -A small green square at the bottom-right corner of a cell
Value - Answer -A number that represents a quantity or amount
Formula - Answer -A combination of cell references, operators, values, and functions
Order of Operations - Answer -Rules that control sequence in which excel performs
arithmetic operations
Column Width - Answer -The horizontal measure of a column
Row Height - Answer -the vertical measurement of a row
Range - Answer -Rectangular group of cells
Allignment - Answer -The position of data between cell margins
Wrap Text - Answer -Formatting that enables a label to appear on multiple lines within
the current cell
Fill Color - Answer -The background color appearing behind data in a cell
, SYNTAX - Answer -A set of rules that governs the structure and components for
properly entering a function
Today Function - Answer -Displays the current date
Absolute Reference - Answer -Indicates a cells specific location the cell reference does
not change when you copy the formula
Argument - Answer -An input, such as a cell reference or value, needed to complete a
function
Max Function - Answer -A function that returns the largest value in a set of values
Min Function - Answer -A function that determines the minimum value in a range of
cells
Count Function - Answer -Tallies the number of cells in a range that contain values
VLOOKUP - Answer -Looks up a value in a vertical lookup table and returns a related
result from the vertical lookup table
Lookup Table - Answer -A range that contains data for the basis of the lookup and data
to be retrieved
Average Function - Answer -Calculates the arithmetic mean or average values in a
range
Median Function - Answer -identifies the midpoint value in a set of values
Now Function - Answer -displays the current date and time
If Function - Answer -evaluates a condition and returns one value if the condition is true
and a different value if the condition is false
Sum Function - Answer -A built-in calculation used to add a range of values together
PMT function - Answer -calculates the periodic payment for a loan with a fixed interest
rate and fixed term
Relative Reference - Answer -A cell reference that changes when a formula is copied
to a new location
Mixed Reference - Answer -contains both relative and absolute cell references
Logical Test - Answer -an expression that evaluates to true or false
Worksheet - Answer -A spreadsheet that contains formulas, functions, values, text &
visual aids
Workbook - Answer -A file containing related worksheets
Name Box - Answer -Identifies the address of the current cell
Formula Bar - Answer -Displays the contents stored in the active cell
Sheet Tab - Answer -Displays the name of a worksheet within a workbook
Cell - Answer -The intersection of a column and a row
Output Area - Answer -A range of cells containing values for variables used in a
formula
Text - Answer -Includes letters, numbers, symbols, and spaces
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
Fill Handle - Answer -A small green square at the bottom-right corner of a cell
Value - Answer -A number that represents a quantity or amount
Formula - Answer -A combination of cell references, operators, values, and functions
Order of Operations - Answer -Rules that control sequence in which excel performs
arithmetic operations
Column Width - Answer -The horizontal measure of a column
Row Height - Answer -the vertical measurement of a row
Range - Answer -Rectangular group of cells
Allignment - Answer -The position of data between cell margins
Wrap Text - Answer -Formatting that enables a label to appear on multiple lines within
the current cell
Fill Color - Answer -The background color appearing behind data in a cell
, SYNTAX - Answer -A set of rules that governs the structure and components for
properly entering a function
Today Function - Answer -Displays the current date
Absolute Reference - Answer -Indicates a cells specific location the cell reference does
not change when you copy the formula
Argument - Answer -An input, such as a cell reference or value, needed to complete a
function
Max Function - Answer -A function that returns the largest value in a set of values
Min Function - Answer -A function that determines the minimum value in a range of
cells
Count Function - Answer -Tallies the number of cells in a range that contain values
VLOOKUP - Answer -Looks up a value in a vertical lookup table and returns a related
result from the vertical lookup table
Lookup Table - Answer -A range that contains data for the basis of the lookup and data
to be retrieved
Average Function - Answer -Calculates the arithmetic mean or average values in a
range
Median Function - Answer -identifies the midpoint value in a set of values
Now Function - Answer -displays the current date and time
If Function - Answer -evaluates a condition and returns one value if the condition is true
and a different value if the condition is false
Sum Function - Answer -A built-in calculation used to add a range of values together
PMT function - Answer -calculates the periodic payment for a loan with a fixed interest
rate and fixed term
Relative Reference - Answer -A cell reference that changes when a formula is copied
to a new location
Mixed Reference - Answer -contains both relative and absolute cell references
Logical Test - Answer -an expression that evaluates to true or false
