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;
4 Cards in this Set
- Front
- Back
Absolute cell referencing
|
when a formula is replicated down through other cells. any part of a cell which contains an absolute cell reference will remain static or unmodified when the formula/ functions are copied. |
|
VLOOKUP (lookup) Function |
in spread sheets, it is very common to want to look up one thing against another. E.g you may want to lookup the price of a certain product. |
|
IF statement
|
an IF statement checks to see if a statement is true or false and then does one of the two things depending on the result.
|
|
Conditional Formatting
|
this will alter the appearance of a cell depending on what it contains. E.g. |