Excel Test
relative cell reference
address of a cell based on the relative position of the cell that contains the formula and the cell referred to
AVERAGE function
adds group of values, then divides the result by the number of values in the group
formula
an equation that performs mathematical calculations on values in a worksheet
cell address
another name for cell reference
value
another name for constant value
logical test
any value or expression that can be evaluated as being true or false
cell content
anything typed into a cell
number value
constant value consisting of only numbers
general fund
describe money set aside for the normal operating activities of a government entity such as a city
workbook
excel file that contains one or more worksheets
statistical functions
excel functions such as average, that are useful to analzye a group of measurements
IF function
function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false
logical functions
group of functions that tests for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false
row
horizontal group of cells in a worksheet
constant value
information such as numbers, texts, dates, or times of day that you type into a cell
cell
intersection of a column and a row
sheet tabs
labels along the lower border of the excel window that identify each worksheet
max function
largest value in a range
SUM function
predefined formula that adds all the numbers in a selected range
function
predefined formula that performs calculations by suing specific values in a particular order or structure
what-if analysis
process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet
NOW function
retrieves and then displays the date and time from your computer
order of operations
rules for performing multiple calculations within formula
bevel
shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled
pie chart
shows relationship of each part of a whole
fill handle
small black square in the lower right corner of a selected cell
Min function
smallest value in a range
comparison operators
symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<) or in between a range of values as specified by the criteria
data
text or numbers in a cell that are not a formula
sparklines
tiny charts embedded in a cell that give a visual trend summary alongside your data
column
vertical group of cells in a worksheet
chart sheet
workbook sheet that contains only a chart
COUNTIF function
a statistical function that counts the number of cells within a range that meet the given condition and which has two arguments - range of cells to check and the criteria
spreadsheet
another name for a worksheet
conditional format
format that changes the appearance of a cell based on a condition
MEDIAN function
function that finds the middle value that has as many values above it in the group as are below it
chart
graphic representation of data in a worksheet
absolute reference cell
refers to cells by their fixed position in a worksheet