Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
13 Cards in this Set
- Front
- Back
What is a spreadsheet? |
A software tool for entering, calculating, manipulating sets of numbers. (used for banking, taxes, payroll) |
|
Column |
Vertical cells identified by letters. |
|
Row |
Horizontal cells identified by numbers. |
|
Label |
Any text entered into a cell, usually left aligned. (An apostrophe in front of a number, tells Excel to treat it like text) |
|
Value |
Any number stored in a cell, usually right aligned. (other characters that can be entered with a value are a decimal, positive negative) |
|
Formula |
An automated calculation that can be performed. Must begin with an equal sign. (eg. =B4+B6) |
|
Functions |
Built in formulas. Can be created by yourself or use the "insert function" icon. |
|
Cell Address |
Must contain a number and a letter. |
|
Formula Bar |
Shows formula when typed into a cell. |
|
Relative Value. |
Formulas being copied automatically change the cell address to suit the new location. |
|
Cell |
Single working unit of a spreadsheet |
|
Absolute Value |
Absolute values stay the same when you copy and fill them to another cell. (Ex. D15 will become $D$15) |
|
Whats the difference between absolute and relative value? |
Relative value will change when you copy the formula from one cell to another. Absolute references will not. |