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
Error Messages:
1. ##### 2. #NAME? 3. #N/A 4. #REF! 5. #VALUE! 6. #NUM! 7. #DIV/0! |
1. Insufficient windth in cell
2. Unrecognized text in formula (ie =AVG(A1:A5) - not a function) 3. Value not avaliable / no answer (Try to look up in function) 4. Invalid Cell Reference (deleting a row) 5. Wrong argument type or operand (ie. ="dog"/2) 6. Invalid numeric values in formula (ie =IRR(A1:A2) - these cells are blank) 7. Division by 0 |
|
Navigation shortcuts
Ctrl+Page Up? Ctrl+Page Down? Alt+Page Up? Alt+Page Down? Ctrl+Tab? Ctrl+arrow key? Ctrl+Home? Ctrl+End |
One worksheet to the left
One worksheet to the right One screen to the left One screen to the right Navigates to next open Excel file Navigates to the end/beginning of a list Navigates to upper left corner of worksheet Navigates to bottom right corner of worksheet |
|
Shortcuts
1. F2? 2. Shift+F10? 3. Alt+Shift+F10? 4. Ctrl+Shift+arrow key 5. Ctrl+1 6. Alt+Left/Right arrow ket 7. Ctrl+` |
1. Edit Cell
2. Right click menu 3. Smart tag menu (error alert, paste options) 4. Highlight row / column 5. Cell Format dialog box 6. Back or Forward from hyperlinks (Excel and Web) 7. Toggle Formula / Value view |
|
More shortcuts
1. Ctrl+d? 2. Ctrl+r? 3. Ctrl+Alt+v? 4. Shift+Space bar 5. Ctrl+Space bar 6. Ctrl+Shift+Space bar 7. Alt+down arrow key 8. Ctrl+; 9. Ctrl+Shift+: 10. Ctrl+Shift+_ 11. Ctrl+- 12. Ctrl+Shift+"+" 13. Ctrl+2-5 14. Ctrl+Shift+~-5 15. Ctrl+Shift+7 16. Ctrl+F4 and Ctrl+w |
1. Copy down (highlighted cells)
2. Copy right (highlighted cells) 3. Paste Special 4. Select row 5. Select column 6. Select all 7. Drop Down List 8. Insert Date 9. Insert Time 10. Quickly remove border 11. Delete row/column 12. Insert row/column 13. Toggle bold, italics, underline and strike through 14. Toggle General Format, Number format (2 dec. places), Time Format, Date Format, Currency Format, Percent Format 15. Toggle Border 16. Close workbook |
|
The number 1 displayed as a date = what?
A function is a predefined ______ that accepts one or more _______ as input. Each function has its own ______ which specifies the function's ____ and order of ________. A function always follows the same rules, known as a function's ________. AutoSum features: what 5 basic functions? These functions ignore ____ and _____ COUNTA? 3 types of references? Shortcut key for references? To reference another worksheet - 'Sheet1' - A1? To copy same cell to cells below/ to the right press what when dragging the fill handle? |
1/1/1900
formula; arguments; syntax; name; arguments; algorithm SUM, AVERAGE, MIN, MAX, COUNT text and blank cells Ignores blank cells, BUT not text Absolute ($A$1), Mixed ($A1) and relative (A1); F4 =Sheet1!A1 Ctrl |