Show:
Functions
Charts
Miscellaneous
All about cells
General
100
adds all the numbers in a range of cells
What is SUM
100
a graphic representation of values and their relationships : pie, line, column, bar, scattered
What is Chart or Graph
100
a number or cell reference used in a formula
What is Operand
100
cell reference that does not adjust to the new cell location when copied or moved
What is Absolute Cell Reference
100
a grid of rows and columns containing numbers, text, and formulas used to perform calculations
What is Spreadsheet
200
returns the average (arithmetic means) of its arguments
What is AVERAGE
200
a chart that uses points connected by a line to illustrate values in a worksheet
What is a Line Chart
200
a symbol that indicates what mathematical operation to perform on the operadns: plus(+), minus(-), multiply (*), divide(/)
What is Operator
200
a cell reference that contains both relative and absolute references
What is Mixed Cell References
200
a collection of related worksheets
What is Workbook
300
returns the number of cells in a rage that contains numbers
What is COUNT
300
a chart that shows the relationship of a part to a whole
What is a Pie Chart
300
alphanumeric text that will not be used in calculations
What is Label
300
cell reference that adjusts to a new location when copied or moved
What is Relative Cell Reference
300
the position of data within a cell
What is Alignment
400
returns the smallest value in a set of values
What is MIN
400
a chart that uses bars of varying height to illustrate values in a worksheet
What is a Column Chart
400
sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest
What is Ascending
400
a selected worksheet cell that is ready for data entry
What is Active Cell
400
to copy a cell's contents and/or formatting into an adjacent cell or range
What is Fill
500
returns the largest value in a set of values
What is MAX
500
sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest
What is Descending
500
keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
What is Freeze
500
the space formed by the intersection of a row and a column; the basic unit of a worksheet
What is Cell
500
process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet
What is What-if-Analysis