Term
|
Definition
|
|
Term
|
Definition
| first spreadsheet program for microcomputers |
|
|
Term
|
Definition
| bricklin and frankston in 78-79 |
|
|
Term
| problems suitable for spreadsheets |
|
Definition
moderate amt of data that will be reused
need for formatting, graphing, analysis |
|
|
Term
| what are spreadsheets used for? |
|
Definition
what if analysis
accounting |
|
|
Term
|
Definition
a document containing values and other data organized into rows and columns
created using spreadsheet software |
|
|
Term
| what applications or software is used to create spreadsheets? |
|
Definition
excel
lotus 123
corel quattro pro |
|
|
Term
|
Definition
worksheet is a single spreadsheet
workbook is a group of worksheets saved in a single file |
|
|
Term
| What are cells identified by? |
|
Definition
Their cell address
rows=numbers
columns=letters |
|
|
Term
| what is a range in reference to spreadsheets? |
|
Definition
| rectangular group of cells in a worksheet |
|
|
Term
|
Definition
| Tells the computer to do some calculations |
|
|
Term
| What do formulas use to tell the computer what to do? |
|
Definition
| cell reference. tells the computer what cells to use for calculations. |
|
|
Term
|
Definition
descriptive text
name
id
section |
|
|
Term
| constant value on spreadsheet |
|
Definition
|
|
Term
|
Definition
| derived value calculated by the machine |
|
|
Term
|
Definition
|
|
Term
|
Definition
| places current date in selected cell |
|
|
Term
|
Definition
reptitively copy contents of one cell
completes a sequence
days, months, etc |
|
|
Term
|
Definition
| changes relative to the direction in which the formula is copied |
|
|
Term
|
Definition
DO NOT CHANGE when a formula is copied
place $ in front of column letter and row number
ex. when using sales tax |
|
|
