Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
CSA II Spreadsheets
| Term | Definition |
|---|---|
| Spreadsheet | An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form |
| Workbook | A file that contains one or more spreadsheets |
| What-If Analysis | A spreadsheet can be a tool used to play out different situations to determine the outcome; answers the question "what if" |
| Cell | Intersection of a row and column |
| Column | arrangement of vertical information; identified by letters of the alphabetic |
| Row | arrangement of horizontal information; identified by numbers |
| Cell Range | a block or group of cells (Ex: A1:A12) |
| Cell Address/Reference | a specific location; the name of a cell; the column letter and row number (Ex: B3) |
| Active Cell | the cell that is ready to receive data; selected with a dark border |
| Labels | alphabetical text or numbers that will NOT be used in calculations; left aligned |
| Apostrophe | typed before a number to make that entry recognized as a label ( ' ) |
| Value | data that will be used in calculations; right aligned |
| Formula | a statement that instructs the software to perform a calculation; always starts with an equal sign (Ex: =A1+A2+A3) |
| Equal Sign | lets the software know that the data will be used in a calculation (=) |
| Addition Operation | plus sign (+) |
| Subtraction Operation | hyphen (-) |
| Multiplication Operation | asterisk (*) |
| Division Operation | diagonal (/) |
| Order of Operations | Calculations performed in a specific order; Parenthesis, Exponents, Multiplication, Division, Addition, Subtraction |
| Function | A mathematical operation built into a spreadsheet program to perform a shortcut for common calculations (Ex: =SUM(B3:B10) |
| AVERAGE | determines the average of the range of cells |
| MAX | determines the highest number in a range of cells |
| MIN | determines the lowest number in a range of cells |
| SUM | adds the total of range of cells |
| Relative Cell | identifies the location of a cell or group of cells that changes when a formula or function is copied and pasted to reflect the function's new location |
| Absolute Cell | used when you want a cell reference to stay fixed on a specific cell that does NOT change when a formula or function is copied and pasted; consists of the column letter and row number surrounded by dollar signs (Ex: $D$5) |
| Mixed Cell | combination of relative and absolute cell references; dollar sign is used to indicate that a column letter or row number is to remain fixed when a formula or function is copied (Ex: $F4) |
Created by:
mmabe
Popular Business sets