A quick way to apply the currency format is to press Ctrl+Shift+$.
What is True
100
#NAME?
Unrecognized text in a formula.
100
Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
Applies the number format to two decimal places.
100
#DIV/0!
Division by zero
100
F4
In Excel, what keystroke combination changes the cell reference type (to absolute, mixed, mixed, relative) while entering/editing a formula?
200
Pressing Ctrl+Shift+# applies the number format.
What is False
200
#N/A
Error Message. No answer.
200
In Excel, what keystroke combination quickly applies the General format?
Ctrl+Shift+~ (Ctrl, Shift and tilde)
200
B1 is an example of a(n) _____ cell reference.
Relative
200
Ctrl+Alt+v
In Excel, after having copied something, what keystroke combination quickly performs a Paste Special operation?
300
The Accounting Format inserts a dollar sign directly in front of (and flush against) the leftmost number in the cell, like this: $1.00
What is False
300
#REF!
Invalid cell reference
300
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
300
The error message #NAME? means that there is(are)
unrecognized text in a formula
300
Ctrl+; (Ctrl and semi-colon)
In Excel, what keystroke combination quickly inserts the current date?
400
Using cell references is preferable to directly inputting values into a formula.
What is True.
400
#VALUE?
Wrong argument type or operand.
400
Ctrl+Shift+plus
In Excel, what keystroke combination inserts cells?
400
#VALUE!
The wrong argument type or operand is shown by
400
Ctrl+Shift+_ (Ctrl, Shift and underscore)
In Excel, what keystroke combination quickly removes a border from the selected cell or range?
500
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.
What is False.
500
#NUM!
Invalid numeric values in a formula or function?
500
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
500
$B1 is an example of a(n) _____ reference.
Mixed
500
Ctrl+d
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?