Show:
Charts
Formula Operations
Format
Cell References
Other
100
A chart that uses points connectied by a line to illustrate values in a worksheet.
What is a Line Chart
100
Adds all the numbers in a range of cells.
What is SUM
100
Keeps selected rows or colums visible on the screen as the rest of the worksheet scrolls.
What is Freeze
100
A unique identifier for a cell which is formed by combining the cells column letters and row numbers.
What is a Cell Reference
100
A grid of rows and colums containing numbers, text, and formulas used to perform calculations.
What is a Spreadsheet
200
A chart that uses bars of varying height to illustrate values in a worksheet.
What is a Column Chart
200
Returns the average (arithmetic means) of its argument.
What is AVERAGE
200
A horizontal group of cells in a worksheet identified by numbers.
What is Row
200
A space formed by the insertion of a row and a column; the basic unit of a worksheet.
What is a Cell
200
The workspace made up of colums and rows where data is entered to create electronic spreadsheet.
What is Worksheet
300
A graphic representation of values and their relationships: pie, line, column, bar, scattered.
What is a Chart/Graph
300
Returns the number of cells in a range that contains numbers.
What is COUNT
300
A position of data within a cell.
What is Alignment
300
A selective worksheet cell that is ready for data entry.
What is Active Cell
300
Sort order arranging text or numbers form A to Z, from smallest to largest, or from earliest to latest.
What is Ascending
400
A chart that shows the relationship fo apart to a whole.
What is a Pie Chart
400
Returns the largest value in a set of values.
What is MAX
400
A verical group of cells in a worksheet identified by letters.
What is a Column
400
Cell reference that adjusts to a new location when copied or moved.
What is Relative Cell Reference
400
Sort order arranging text or numbers from Z to A, largest to smallest, or from latest to earliest
What is Descending
500
Process of changing balues in cells to see how those changes affect the outcome of formulas in the worksheet.
What is a What-if analysis
500
Returns the smalles value in a set of values.
What is MIN
500
An equation that calculates a new value using values currently on a worksheet.
What is a Formula
500
Cell reference that does not adjusts to the new cell location when copied or moved.
What is Absolute Cell Reference
500
Who was the 16th president?
What is Abraham Lincoln