Show:
vocabulary
Functions
Charts/Graphs
random vocab
Formats
100
Returns the largest value in a set of values
What is Max
100
An equation that calculates a new value using values currently on a worksheet
What is Formula
100
a chart that uses points connected by a line to illustrate values in a worksheet
What is Line Chart
100
the space formed by the intersection of a row and a column; the basic unit of a worksheet
What is Cell
100
Keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
What is Freeze
200
returns the smallest value in a set of values
What is Min
200
A prewritten formula that makes it easy to perform common calculations
What is Function
200
A chart that shows the relationship of a part to a whole
What is Pie chart
200
a selected worksheet cell that is ready for data entry
What is Active Cell
200
arranging the shape,size,type,and general makeup of a cell or group of cells
What is Format
300
a grid of rows and columns containing numbers,text,and formulas used to perform calculations
What is Spreadsheet
300
Adds all the number in a range of cells
What is Sum
300
a graphic representation of values and their relationships: pie, line , column , bar ,scattered
What is Chart/ Graph
300
A unique identifier for a cell which is formed by combining the cells column letter and row number
What is Cell reference
300
To copy a cells contents and/or formatting into an adjacent cell or range
What is Fill
400
the workspace made up of columns and rows where data is entered to create an electronic spreadsheet
What is Worksheet
400
Returns the average (arithmetic means) of its arguments
What is Average
400
A chart that uses bars of varying height to illustrate values in a worksheet
What is column chart
400
Selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon
What is Range
400
Sort order arranging text or numbers from A to Z from smallest to largest, or from earliest to latest
What is Ascending
500
process of changing values in cells to se how those changes affect the outcome of formulas in the worksheet
What is What if analysis
500
Returns the number of cells in a range that contains numbers
What is Count
500
a vertical group of cells in a worksheet identified by letters
What is column
500
The position of data within a cell
What is Alignment
500
Sort order arranging text or numbers from Z to A largest to Smallest or latest to earliest
What is Decending