Reading...
Play button
Play button
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;
5 Cards in this Set
- Front
- Back
|
Formula calculation |
Alt+Q → calculation → manual (calculate now)/automatic |
|
|
How to name a Cell or Range |
Alt+Q → Name a range → insert a name (e.g. 'Quantity1') |
|
|
What are the two types of references? |
Absolute and Relative References |
|
|
How to do a sensitive analysis? |
Data table (Data → whayif analysis →Data table) |
|
|
Pivot table & Pivot chart |
Alt+Q → search pivot table or pivot chart |
