BUSI 520 FINAL QUESTIONS AND ANSWERS
The error message ###### means that there is (are) - Answers - Column width of a cell
is too narrow to display numeric data, or a formula in a cell results in a negative date, a
date prior to 1/1/1900
The error message #NAME? means that there is (are) - Answers - Unrecognized text in
a formula
#N/A - Answers - No answer can be found
#REF! - Answers - Invalid cell reference
#VALUE! - Answers - Wrong argument type or operand
#NUM! - Answers - Invalid numeric values in a formula or function
#DIV/0! - Answers - Division by zero
COUNT(number1, [number2],..) - Answers - Determines the number of values in a list,
but it ignores blank cells and cells with text
COUNTA(number1,[number2]...) - Answers - Determines the number of values in a list
but does not ignore text cells
Absolute cell referencing - Answers - Indicates that a cell reference should remain
unchanged when copying. Ex: $A$19
Mixed Cell Reference - Answers - A cell reference that has only one $
Common when you need to copy a formula both down a column and across a row at the
same ti
What keystroke combination shows the format cells dialog window? - Answers -
CTRL+1 (CTRL and 1)
___ is(are) first in the order of precedence rules - Answers - Operations in parentheses
What Keystroke combination selects right, to the end of the current row of contiguous
(adjacent) cells? - Answers - CTRL+Shift+right arrow
What keystroke combination toggles between displaying formulas and displaying
values? - Answers - CTRL+`
,You should always adjust column width first before attempting to wrap text for the
column headings. - Answers - False; you should always wrap text for column headings
first before adjusting any column widths
What keystroke combination selects the current row? - Answers - Shift+space
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) - Answers - CTRL+Minus
A quick way to apply the percent format is to press Ctrl+shift+% - Answers - True
What keystroke combination quickly applies the general format - Answers -
CTRL+Shift+~ (Ctrl, Shift and tilde)
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) - Answers - False; Format cells with formulas differently from cells with
inputs, so that it's easy for users to determine where values can be entered or edited.
B1 is an example of a(n) ___ cell reference - Answers - Relative
After having copied something, what keystroke combination quickly performs a Paste
Special operation? - Answers - CTRL+ALT+v
If A1=2, then the resulting value of =3+5*A1 is - Answers - 13
The COUNTA function ignores cells with text - Answers - False ; Determines the
number of values in a list but does not ignore text cells
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 - Answers - False
COUNT(number1, number2,..) determines the sum of a list of values. - Answers - False;
COUNT(number1, number2,..) Determines the number of values in a list, but it ignores
blank cells and cells with text
If multiple horizontal cells are selected/highlighted, what keystorke combination copies
the formmula(s)/value(s) in the leftmost cell(s) of the selected. Uses the Fill Right
command to copy the contents and format of the leftmost cell of a selected range into
the cells to the right. - Answers - CTRL+R
What keystroke combination quickly applies the number format to two decimal places? -
Answers - CTRL+Shift+! (Ctrl, shift and exclamation mark)
, What keystroke combination quickly applies a border around the selected cell or range?
- Answers - CTRL+Shift+& (Ctrl, shift, and ampersand)
Pressing CTRL+Shift+# applies the number format - Answers - False, CTRL+Shift+!
(Ctrl, shift and exclamation mark) applies the number format
#REF! means invalid numerical values in a formula or function - Answers - False; #REF!
means invalid cell reference
The wrong argument type or operand is show by - Answers - #VALUE!
Using cell reference is preferable to directly inputting values into a formula - Answers -
Truee
The best way to center title is to use the merge & Center toolbar/ribbon button -
Answers - False; use Merge Center, use Center Across Selection
What Keystroke combination selects the current column? - Answers - CTRL+space
What Keystroke combination quickly inserts the current time? - Answers - CTRL+Shift+:
(CTRL, SHIFT and colon)
What keystroke Combination switches between currently open workbooks? - Answers -
CTRL+tab
What keystroke combination quickly inserts the current date - Answers - CTRL+; (CTRL
and semi-colon)
The Accounting format inserts a dollar sign directly in front of (and flush against) the
leftmost number in the cell, like this: $1.00 - Answers - False
What keystroke combination moves one screen to the right within the current worksheet
- Answers - ALT + PG DN
What keystroke combination changes the cell reference type (to absolute, mixed, mixed,
relative) while entering/editing a formula? - Answers - F4
____ is (are) last in order of precedence rules - Answers - Addition and subtraction from
left to right
After having copied something, what keystroke combination performs a past operation -
Answers - CTRL+V
What keystroke combination switches (The active worksheet) to the next worksheet (to
the right) ? - Answers - CTRL + PG DN
The error message ###### means that there is (are) - Answers - Column width of a cell
is too narrow to display numeric data, or a formula in a cell results in a negative date, a
date prior to 1/1/1900
The error message #NAME? means that there is (are) - Answers - Unrecognized text in
a formula
#N/A - Answers - No answer can be found
#REF! - Answers - Invalid cell reference
#VALUE! - Answers - Wrong argument type or operand
#NUM! - Answers - Invalid numeric values in a formula or function
#DIV/0! - Answers - Division by zero
COUNT(number1, [number2],..) - Answers - Determines the number of values in a list,
but it ignores blank cells and cells with text
COUNTA(number1,[number2]...) - Answers - Determines the number of values in a list
but does not ignore text cells
Absolute cell referencing - Answers - Indicates that a cell reference should remain
unchanged when copying. Ex: $A$19
Mixed Cell Reference - Answers - A cell reference that has only one $
Common when you need to copy a formula both down a column and across a row at the
same ti
What keystroke combination shows the format cells dialog window? - Answers -
CTRL+1 (CTRL and 1)
___ is(are) first in the order of precedence rules - Answers - Operations in parentheses
What Keystroke combination selects right, to the end of the current row of contiguous
(adjacent) cells? - Answers - CTRL+Shift+right arrow
What keystroke combination toggles between displaying formulas and displaying
values? - Answers - CTRL+`
,You should always adjust column width first before attempting to wrap text for the
column headings. - Answers - False; you should always wrap text for column headings
first before adjusting any column widths
What keystroke combination selects the current row? - Answers - Shift+space
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) - Answers - CTRL+Minus
A quick way to apply the percent format is to press Ctrl+shift+% - Answers - True
What keystroke combination quickly applies the general format - Answers -
CTRL+Shift+~ (Ctrl, Shift and tilde)
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) - Answers - False; Format cells with formulas differently from cells with
inputs, so that it's easy for users to determine where values can be entered or edited.
B1 is an example of a(n) ___ cell reference - Answers - Relative
After having copied something, what keystroke combination quickly performs a Paste
Special operation? - Answers - CTRL+ALT+v
If A1=2, then the resulting value of =3+5*A1 is - Answers - 13
The COUNTA function ignores cells with text - Answers - False ; Determines the
number of values in a list but does not ignore text cells
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 - Answers - False
COUNT(number1, number2,..) determines the sum of a list of values. - Answers - False;
COUNT(number1, number2,..) Determines the number of values in a list, but it ignores
blank cells and cells with text
If multiple horizontal cells are selected/highlighted, what keystorke combination copies
the formmula(s)/value(s) in the leftmost cell(s) of the selected. Uses the Fill Right
command to copy the contents and format of the leftmost cell of a selected range into
the cells to the right. - Answers - CTRL+R
What keystroke combination quickly applies the number format to two decimal places? -
Answers - CTRL+Shift+! (Ctrl, shift and exclamation mark)
, What keystroke combination quickly applies a border around the selected cell or range?
- Answers - CTRL+Shift+& (Ctrl, shift, and ampersand)
Pressing CTRL+Shift+# applies the number format - Answers - False, CTRL+Shift+!
(Ctrl, shift and exclamation mark) applies the number format
#REF! means invalid numerical values in a formula or function - Answers - False; #REF!
means invalid cell reference
The wrong argument type or operand is show by - Answers - #VALUE!
Using cell reference is preferable to directly inputting values into a formula - Answers -
Truee
The best way to center title is to use the merge & Center toolbar/ribbon button -
Answers - False; use Merge Center, use Center Across Selection
What Keystroke combination selects the current column? - Answers - CTRL+space
What Keystroke combination quickly inserts the current time? - Answers - CTRL+Shift+:
(CTRL, SHIFT and colon)
What keystroke Combination switches between currently open workbooks? - Answers -
CTRL+tab
What keystroke combination quickly inserts the current date - Answers - CTRL+; (CTRL
and semi-colon)
The Accounting format inserts a dollar sign directly in front of (and flush against) the
leftmost number in the cell, like this: $1.00 - Answers - False
What keystroke combination moves one screen to the right within the current worksheet
- Answers - ALT + PG DN
What keystroke combination changes the cell reference type (to absolute, mixed, mixed,
relative) while entering/editing a formula? - Answers - F4
____ is (are) last in order of precedence rules - Answers - Addition and subtraction from
left to right
After having copied something, what keystroke combination performs a past operation -
Answers - CTRL+V
What keystroke combination switches (The active worksheet) to the next worksheet (to
the right) ? - Answers - CTRL + PG DN
