Show:
Functions
References
Layout
Parts of Document
Charts
100
Adds all the numbers in a range of cells
What is SUM
100
a function that automatically adds that values in the cells directly above or to the left of the active cell.
What is Autosum
100
alphanumeric text that will not be used in calculations.
What is Label
100
a number or cell reference used in a formula
What is operand
100
a graphic represendation of values and their relationships: pie, line, coulumn, bar, scattered.
What is Chart/graph
200
returns the average (arithmetic means) of its arguments.
What is AVERAGE
200
a prewritten formula that makes it easy to perform common calculations.
What is Function
200
numeric characters that can be used in calculation.
What is Value
200
a grid of rows and columns containing numbers, text, and formulas used to perform calculations.
What is Spreadsheet
200
a chart that uses bars of varying height to illustrate values in a worksheet.
What is Coulumn chart
300
returns the number of cells in a range that contains numbers.
What is COUNT
300
a cell reference that contains both relative and absolute references.
What is Mixed cell reference
300
value, cell reference, range, or text that acts as an operand in a function formula.
What is Argument
300
the workspace made up of columns and rows where data is entered to create an electronic speadsheet.
What is worksheet
300
a chart that uses points connected by a line to illustrate values in a worksheet
What is Line chart
400
returns the smallest value in a set of values
What is MIN
400
cell reference that adjusts to a new location when copied or moved.
What is Relative cell reference
400
the mathematical ruls used for calculating tht value of a formula.
What is Order ofd Operations
400
a space formed by the intersection of a row and a coulmn; the basic unit of a worksheet.
What is cell reference
400
a chart that shows the relationship of a part to a whole
What is pie chart
500
returns the largest value in a set of values.
What is MAX
500
cell reference that does not adjust to the new cell location when copied or moved
What is Absolute cell reference
500
a symbol that indicates what mathematical operation to perform on the operands: plus(+), Minus (-), multiply (*), divide(/).
What is Operator
500
a collection of related worksheet
What is workbook
500
keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls.
What is Freeze