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;
40 Cards in this Set
- Front
- Back
|
In Excel, what keystroke combination moves one screen to the right within the current worksheet? |
alt + pg. dn. |
|
|
If multiple horizontal 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 quickly applies the number format to two decimal places? |
ctrl + shift + ! |
|
|
_____ is(are) last in the order of precedence rules. |
Addition and subtraction from left to right
|
|
|
The error message #NAME? means that there is(are) |
unrecognized text in a formula.
|
|
|
In Excel, what keystroke combination quickly applies the General format? |
Ctrl+Shift+~ (Ctrl, Shift and tilde)
|
|
|
If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is |
0
|
|
|
In Excel, what keystroke combination closes the current workbook? |
ctrl+F4 and ctrl + w |
|
|
#REF! means invalid numerical values in a formula or function. |
False |
|
|
A quick way to apply the percent format is to press Ctrl+Shift+%. |
True |
|
|
The wrong argument type or operand is shown by |
#VALUE! |
|
|
A workbook's documentation sheet should always be showing when saving the file a final time (right before submitting the file), so that when someone opens your file, the documentation sheet will be the first sheet seen. |
TRUE |
|
|
If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula? |
=$B$4-SUM(C2:C6) |
|
|
The Accounting Format inserts a dollar sign directly in front of (and flush against) the leftmost number in the cell, like this: $1.00 |
False |
|
|
In Excel, what keystroke combination selects the current row? |
Shift + Space |
|
|
In Excel, what keystroke combination quickly removes a border from the selected cell or range? |
Ctrl+Shift+_ (Ctrl, Shift and underscore)
|
|
|
In order to maintain consistency within your workbooks, it is important to format cells with formulas (outputs) using the same colors as cells containing assumptions and/or values (inputs). |
False |
|
|
In Excel, what keystroke combination selects the current column? |
Ctrl+space |
|
|
A quick way to apply the currency format is to press Ctrl+Shift+$. |
True |
|
|
If A1=2, the resulting value of =3*A1^3 is |
24 |
|
|
In Excel, what keystroke combination performs an "undo" of the last action? |
Ctrl+z |
|
|
In Excel, what keystroke combination toggles between displaying formulas and displaying values? |
None of the answers listed. |
|
|
In Excel, what keystroke combination shows the format cells dialog window? |
Ctrl+1 (Ctrl and 1)
|
|
|
What keystroke combination switches between currently open workbooks? |
Ctrl+tab
|
|
|
In Excel, what keystroke combination inserts cells? |
Ctrl+Shift+plus
|
|
|
The COUNTA function ignores cells with text |
False. |
|
|
B1 is an example of a(n) _____ cell reference. |
Relative |
|
|
In Excel, what keystroke combination quickly inserts the current time? |
Ctrl+Shift+: (Ctrl, Shift and colon)
|
|
|
In Excel, what keystroke combination quickly inserts the current date? |
Ctrl+; (Ctrl and semi-colon)
|
|
|
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
|
|
|
Pressing Ctrl+Shift+# applies the number format. |
False |
|
|
You should always adjust column widths first, before attempting to Wrap Text for the column headings. |
False |
|
|
In Excel, what keystroke combination changes the cell reference type (to absolute, mixed, mixed, relative) while entering/editing a formula? |
F4 |
|
|
When using Excel to open a file that is in .csv format, formulas and formatting entered in the sheet can be safely saved in either .csv, .xls or .xlsx format. |
False |
|
|
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 a border around the selected cell or range? |
Ctrl+ shift + & |
|
|
In Excel, what keystroke combination switches (the active worksheet) to the next worksheet (to the right)? |
Alt + pg. dn. |
|
|
Using cell references is preferable to directly inputting values into a formula. |
True |
|
|
In Excel, after selecting a range of cells, what keystroke combination deletes those 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 |
|
|
_____ is(are) first in the order of precedence rules. |
Operations in parentheses. |
