Show:
Basic Term
Returns
References
Function Term
Formulas & Charts
100
a grid of rows and columns containing numbers, text and formulas used to perform calculations.
What is spreadsheet.
100
return the average of its arguments
What is average.
100
cell reference that adjust to a new location when copied or moved
What is relative cell reference.
100
alphanumebic text that will not be used in calculations
What is label
100
A chart that uses bars of varying height to illustrate values in a worksheet.
What is Column Chart
200
the workspace made up of columns and rows where data is entered to create and electronic spreadsheet.
What is worksheet.
200
return the number of cells in a range that contains numbers.
What is count
200
cell reference that does not adjust to the new cell location when copied and moved.
What is absolute cell references
200
numbic characters tha tcan be used in calculation
What is value
200
a chart that uses points connected by a line to illustrate values in a worksheet.
What is line chart
300
a collection of related worksheets
What is workbook
300
returns the largest value in a set of values
What is max
300
cell reference that contains both relative and absolute references
What is mix cell reference.
300
the mathematical rules used for calculations the value of a formula.
What is Order of Operations
300
a prewritten formula that makes it easy to perform common calculation.
What is function
400
the space that formed of a row and column; the basic unit of a worksheet.
What is cell
400
returns the smallest value in a set of values
What is min
400
a number or cell reference used in a formula.
What is operand
400
a function that automaticallly adds the values in the cells directly above or to the left of the active cell.
What is autosum
400
a chart that shows the relationship of a part to a whole.
What is pie chart
500
A unique identifier for a cell which is formed by combining the cells column letter and row numba
What is cell reference
500
adds all the numbers in a range of cells
What is sum
500
value, cell reference, range, or text that acts as an operand in a fuction formula.
What is argument.
500
a symbol tha tindicates what mathematical operation to perform on the operands; plus (+) minus (-) multiply (*) divide (/)
What is operaters
500
process of chaning values in cells to see how those changes affect the outcome of formulas in the worksheet.
What is What-If analysis