spreadsheet
an electronic file that contains a grid of columns and rows containing related data
worksheet
s spreadsheet that contains formulas,
... [Show More] functions, values, texts, and visual aids
workbook
a file containing related worksheets
input area
a range of cells containing values for vairables used in formulas
output
a range of cells containing results based on manipulating the variables
name box
identifies the address of the current cell
formula bar
displays the content (text, value, date, or formula) in the active cell
sheet tab
diplays the name of a worksheet within a work-book
cell
the interesection of a column letter and a row number
cell address
identifies a cell by a letter and a ro number
active cell
the current cell, indicated by a dark border
text
includes letters, numbers, symbols, and spaces
value
a number that represents a quantity or an account
formula
a combination of cell refrences, operators, values, and or functions used to perfom a calculation
range
a rectangular group of cells
nonadjacent range
contains multiple ranges of cells
semi-selection
the process of using the mouse pointer to select cells while building a formula
relative cell reference
indicates a cell's relative location from the cell containing the formula, the cell reference changes when the formula is copied
absolute cell reference
indicates a cell's specific location; the cell reference does not change when you copy the formula
mixed cell reference
contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula
circular reference
occurs when a formula directly or indirectly refers to itself
syntax
a set of rules that govern the structure and components for properly entering a function
arguement
an input, such as a cell reference or value, needed to complete a function
function screentip
a small pop-up description that displays the arguements for a function as you enter it
counta function
tallies the number of cells in a range that are not empty
now function
displays current date and time
if function
evaluates a condition and returns one value if the condition is true and a different value if the conditon is false
logical test
an expression that evaluates to true or false
nested function
a function that contains another function embedded inside one or more of its arguements
vlookup function
looks up a value in a vertical lookup table and returns a related result from the lookup table
table array
a range containing a lookup value
pmt function
calculates the periodic payment for a loan with a fixed interest rate and fixed term
rate
the periodic interest rate, such as a monthly interest rate
nper
the number of total payment periods
pv
the present value of the loan
range name
a word or string of characters that represents one or more cells
column chart
displays data comparisons vertically in columns
chart area
contains the entire chart and all of its elements
plot area
contains a graphical representation of values in a data series
value axis
displays incremental values to identify the values of the data series
legend
a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart
stacked column chart
places stacks of data in segments on top of each other in on column, with each category in the data series represented by a different color
bar chart
compares values across categories using horizontal bars [Show Less]