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;
29 Cards in this Set
- Front
- Back
|
In Excel, what keystroke combination moves one screen to the right within the current worksheet?
|
Alt + Pg dn
|
|
|
In Excel, what keystroke combination toggles between displaying formulas and displaying values?
|
Ctrl + `(grave accent)
|
|
|
In Excel, what keystroke combination selects the current column?
|
Ctrl + Space
|
|
|
In Excel, what keystroke combination deletes cells? (not just deletes the contents of cells, but deletes the actual cells, so that other cells adjust to replace the deleted cells)
|
Ctrl + minus
|
|
|
In Excel, what keystroke combination changes the cell reference type (to absolute, mixed, mixed, relative) while entering/editing a formula?
|
F4
|
|
|
In Excel, what keystroke combination selects the current row?
Question 14 answers |
Shift + Space
|
|
|
In Excel 2007, after having copied something, what keystroke combination quickly performs a Paste Special operation?
|
Ctrl + Alt + v
|
|
|
In Excel, what keystroke combination quickly applies the General format?
|
Ctrl+Shift+~(tilde)
|
|
|
In Excel, what keystroke combination quickly removes a border from the selected cell or range?
|
Ctrl+Shift+_
|
|
|
In Excel, what keystroke combination switches (the active worksheet) to the next worksheet (to the right)?
|
Ctrl+Pg dn
|
|
|
In Excel, what keystroke combination inserts cells?
|
Ctrl+Shift+plus
|
|
|
In Excel, what keystroke combination quickly applies a border around the selected cell or range?
|
Ctrl+Shift+& (ampersand)
|
|
|
If multiple cells are selected/highlighted, what keystroke combination copies the formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the other cells in the range of selected cells?
|
Ctrl+r
|
|
|
In Excel, what keystroke combination selects right, to the end of the current row of contiguous cells?
|
Ctrl+Shift+right arrow
|
|
|
In Excel, what keystroke combination quickly inserts the current time?
|
Ctrl+Shift+: (colon)
|
|
|
What keystroke wil apply the percent format?
|
Ctrl+Shift+% (percent)
|
|
|
In Excel, what keystroke combination shows the format cells dialog window?
|
Ctrl+1
|
|
|
In Excel, what keystroke combination quickly inserts the current date?
|
Ctrl+; (semi-colon)
|
|
|
In Excel, what keystroke combination selects the current cell along with the cell to the right? (Multiple presses would select multiple cells to the right.)
|
Shift+right arrow
|
|
|
In Excel, what keystroke combination moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values?
|
Ctrl+right arrow
|
|
|
In Excel, what keystroke combination quickly applies the number format to two decimal places?
|
Ctrl+Shift+! (exclamation)
|
|
|
What keystroke combination switches to the next open workbook
|
Ctrl + tab
|
|
|
In Excel, what keystroke combination closes the current workbook? (two)
|
Ctrl+F4 and Ctrl+w
|
|
|
If multiple cells are selected/highlighted, what keystroke combination copies the formula(s)/value(s) in the topmost cell(s) of the selected range down to the other cell(s) in the range of selected cells?
|
ctrl+d
|
|
|
In Excel, what keystroke combination performs an "undo" of the last action?
|
Ctrl+z
|
|
|
what keyboard stroke does currency format
|
Ctrl+Shift+$
|
|
|
What does #NAME? mean?
|
there is unrecognized text in a formula
|
|
|
When will you see #VALUE!
|
the wrong argument type is shown
|
|
|
When will you see #REF!
|
When a column/row is referenced that isn't there
|
