BUSI 520 Final Exam Questions and Answers Latest 2025-2026
rank.eq - Answers 0 - descending order
1 - ascending order
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
What keystroke combination inserts cells? - Answers CTRL+Shift+Plus
What Keystroke combination closes the current workbook? - Answers CTRL+F4 and CTRL+W
$B1 is an example of a(n) ___ reference - Answers Mixed
What keystroke combination quickly removes a border from the selected cell or range? -
Answers CTRL_SHIFT_ (Ctrl, shift and underscore)
rank.eq - Answers 0 - descending order
1 - ascending order
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
What keystroke combination inserts cells? - Answers CTRL+Shift+Plus
What Keystroke combination closes the current workbook? - Answers CTRL+F4 and CTRL+W
$B1 is an example of a(n) ___ reference - Answers Mixed
What keystroke combination quickly removes a border from the selected cell or range? -
Answers CTRL_SHIFT_ (Ctrl, shift and underscore)
