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;
17 Cards in this Set
- Front
- Back
|
Hardcoding |
H |
|
|
Relative cell addressingr |
R |
|
|
Absolute addressing |
$$ |
|
|
Range names |
Naming cell which links to the information it contains |
|
|
Three types of cell entries |
- Label - Value - Formula |
|
|
Label |
Text or alpha numeric cell entry |
|
|
Value |
Fixed numeric value cell entry with varying appearance at currency, date, decimal, percentage |
|
|
Formula |
Calculations based on numeric inputs. Can be user defined or inbuilt. All formulae must start with = typed into the active cell. |
|
|
=sum() |
Add contents of range |
|
|
=average() |
Average the range |
|
|
=count() |
Count non zero values |
|
|
=max() |
Display the Largest value |
|
|
=min() |
Display the smallest value |
|
|
=IF |
=IF(cond,true,false) |
|
|
Simplified desk check |
Visual check does your spreadsheet look right? |
|
|
Multiple argument functions |
Multiple argument functions require more than one input |
|
|
ZERO argument function |
ZERO argument functions have empty brackets |
