Spreadsheet Vocabulary
- Cell--the intersection of a row and a column on a
spreadsheet in which data can be entered.
- Cell Address--the location of a cell on a
spreadsheet, (identified by the column letter, followed by the row number,
example: A1, B4)
- Column--the vertical divisions of a spreadsheet. Columns are labeled
alphabetically.
- Data Entry Bar--the bar at the top of the
spreadsheet used to enter data into the cell that you have chosen
- Enter--to type in or record data in a spreadsheet
- Formula--a type of information that can be entered
into a spreadsheet cell. It is a mathematical statement, which begins with
an equal sign (=) that tells the computer to perform a calculation.
- Function--a shortcut for the most common
mathematical calculations used in a spreadsheet. (Ex: SUM will add all
numbers in a range, AVG will average all numbers in a range.)
- Graphs--Charts that represent data (Ex: Pie, Bar, Line)
- Graphing--feature in a software program that allows
numerical data to be interpreted as a graph or chart.
- Grid--a blank set-up of rows and columns in a
spreadsheet for data to be entered on
- Label--text, symbol, date or number NOT used in
calculations in a spreadsheet. Often it will label a column or row.
- Range--a block of cells on a spreadsheet
- Row--the horizontal divisions of a
spreadsheet. Rows are labeled with numbers.
- Spreadsheet--an application program that
arranges data into columns and rows. It is usually used to work with numbers
for calculating, forecasting, evaluating, or presenting information. One of the main
uses of spreadsheets is to answer WHAT IF... questions (forecast or
predict). Three types of data that can be entered into a spreadsheet
are values, labels, and formulas.
- Value--a number that is entered into a spreadsheet
and used for calculations
|