Charts
Formula's
Returns
Misc.
Group
100
A chart that uses bars of varying height to illustrates values in a worksheet.
What is a Column Chart?
100
a equation that calculates a new value using values currently on a worksheet
What is formula
100
Adds all the numbers in a range of cells
What is Sum?
100
A number or cell reference used in a formula.
What is Operand.
100
A grid of rows and columns containing numbers, text, and formulas used to perform calculations.
What is Spreadsheets.
200
A chart that uses points connected by a line to illustrate values in a worksheet.
What is a Line Chart?
200
Cell reference that does not adjust to the new cell location when copies or moved.
What is Absolute Cell Reference.
200
Returns the average (arithmetic means) of its arguments.
What is Average?
200
A symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)
What is Operator.
200
the workspace made up of columns and rows where data is entered to create an electronic spreadsheet
What is Worksheets?
300
A chart that shows the relationship of a part to a whole.
What is a Pie Chart?
300
Cell refernce that adjusts to a new location when copied or moved.
What is Relative Cell Reference.
300
Returns the number of cells in a range that contains numbers
What is Count
300
Alphanumeric text that will not be used in a calculations.
What is Label.
300
A collection of related worksheets
What is Workbook.
400
a graphic representation of values and their relationship : pie, line, column, bar, scattered.
What is Chart/Group?
400
A cell reference that contains both relative and absolute references
What is Mixed Cell Reference.
400
Returns the largest values in a set value
What is max
400
NUmeric characteristics that can be used in a calculations
What is Value
400
a vertical group of cells in a worksheet identified by letters.
What is Column
500
A selected worksheet cell that is ready for data entry.
What is a Active Cell?
500
A prewritten formula that makes it easy to perform common calculations.
What is Funtion.
500
Returns the smallest value in a set of values
What is Min.
500
the mathematical rules used for calculating the values of a formula.
What is Order of Operations
500
A horizontal group of cells in a worksheet identified by numbers
What is Row