Vocab
Functions
Formulas
Random
Charts
100
a grid of rows and columns containing numbers, text, and formulas used to preform calculations.
What is spreadsheet?
100
a function that automatically adds the values in the cells directly above or to the left of the active cell.
What is auto sum?
100
a number or cell reference used in a formula.
What is operand?
100
a collection of related worksheets.
What is workbook?
100
a graphic representation of values and their relationships: pie, line, column, bar,scattered.
What is chart/graph?
200
a selected worksheet cell that is ready for data entry.
What is active cell?
200
adds all the numbers in a range of cells.
What is sum?
200
alphanumeric text that will not be used in calculations.
What is label?
200
the workspace made up of columns and rows where data is entered to create an electronic spreadsheet.
What is worksheet?
300
the position of data within a cell.
What is alignment?
300
returns the average of its arguments.
What is average?
300
numeric characters that can be used in calculation.
What is value?
300
a vertical group of cells in a worksheet identified by letters.
What is column?
400
to copy a cell's contents and/or formatting into an adjacent cell or range.
What is fill?
400
returns the largest value in a set of values.
What is Max?
400
value, cell reference, range, or text that acts as an operand in a function formula.
What is argument?
400
a horizontal group of calls in a worksheet identified by numbers.
What is row?
500
returns the number of cells in a range that contains numbers.
What is count?
500
returns the smallest value in a set of values.
What is Min?
500
the mathematical rules used for calculating the value of a formula.
What is order of operations?
500
keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls.
What is freeze?
M
e
n
u