BUSI 520 End Term
Business Final Exam
Question Bank with
Verified Answers 2026
,True - correct answer A workbook's documentation sheet should always be showing when saving the file a
k k k k k k k k k k k k k k k k k
final time (right before submitting the file), so that when someone opens your file, the documentation sheet
k k k k k k k k k k k k k k k k k
will be the first sheet seen.k k k k k
True - correct answer A quick way to apply the percent format is to press Ctrl+Shift+%
k k k k k k k k k k k k k k k
e - correct answer In Excel, what keystroke combination changes the cell reference type (to absolute, mixed,
k k k k k k k k k k k k k k k k k
mixed, relative) while entering/editing a formula?
k k k k k
a. none of the answers listed
k k k k k
b. ctrl+shift+f4 k
c.ctrl+`
d.ctrl+f4
e. f4 k
b - correct answer In Excel, what keystroke combination quickly inserts the current date?
k k k k k k k k k k k k k
a. Ctrl+Shift+: (Ctrl, Shift and colon)
k k k k k k
b. Ctrl+; (Ctrl and semi-colon)
k k k k k
c. Ctrl+Shift+# (Ctrl, Shift and number sign)
k k k k k k k
d. Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)
k k k k k k
unrecognized text in a formula - correct answer The error message #NAME? means that there is(are) k k k k k k k k k k k k k k k
a - correct answer In Excel, what keystroke combination moves one screen to the right within the current
k k k k k k k k k k k k k k k k k k
worksheet?
a. alt+pg dn k k
b. shift+pg dn k k
c. ctrl+pg dn
k k
d. ctrl+tab k
,False - correct answer In order to maintain consistency within your workbooks, it is important to format cells
k k k k k k k k k k k k k k k k k k
with formulas (outputs) using the same colors as cells containing assumptions and/or values (inputs)
k k k k k k k k k k k k k
False - correct answer #REF! means invalid numerical values in a formula or function.
k k k k k k k k k k k k k
ctrl+shift+right arrow - correct answer In Excel, what keystroke combination selects right, to the end of the k k k k k k k k k k k k k k k k k
current row of contiguous (adjacent) cells? k k k k k
ctrl+shift+! - correct answer In Excel, what keystroke combination quickly applies the number format to two
k k k k k k k k k k k k k k k k
decimal places? k
mixed - correct answer $B1 is an example of a(n) _____ reference.
k k k k k k k k k k k
false - correct answer The best way to center titles is to use the Merge & Center toolbar/ribbon button.
k k k k k k k k k k k k k k k k k k
ctrl+w and ctrl+f4 - correct answer In Excel, what keystroke combination closes the current workbook?
k k k k k k k k k k k k k k
relative - correct answer B1 is an example of a(n) _____ cell reference.
k k k k k k k k k k k k
ctrl+tab - correct answer What keystroke combination switches between currently open workbooks?
k k k k k k k k k k k
ctrl+z - correct answer In Excel, what keystroke combination performs an "undo" of the last action?
k k k k k k k k k k k k k k k
true - correct answer Using cell references is preferable to directly inputting values into a formula.
k k k k k k k k k k k k k k k
ctrl+d - correct answer If multiple cells are selected/highlighted, what keystroke combination copies the
k k k k k k k k k k k k k k
formula(s)/value(s) in the topmost cell(s) of the selected range down to the other cell(s) in the range of k k k k k k k k k k k k k k k k k k
selected cells? k
, ctrl+minus - correct answer In Excel, after selecting a range of cells, what keystroke combination deletes those
k k k k k k k k k k k k k k k k k
cells? (not just deletes the contents of cells, but deletes the actual cells, so that other cells adjust to replace the
k k k k k k k k k k k k k k k k k k k k k
deleted cells) k
shift+space - correct answer In Excel, what keystroke combination selects the current row?
k k k k k k k k k k k k
d - correct answer In Excel, what keystroke combination quickly applies the General format?
k k k k k k k k k k k k k
a.Ctrl+Shift+@ (Ctrl, Shift and "at" symbol) k k k k k k
b.Ctrl+Shift+# (Ctrl, Shift and number sign) k k k k k k
c.Ctrl+Shift+! (Ctrl, Shift and exclamation mark) k k k k k k
Correct!
d.Ctrl+Shift+~ (Ctrl, Shift and tilde) k k k k
ctrl+right arrow - correct answer In Excel, what keystroke combination moves (the active cell) right, to the end
k k k k k k k k k k k k k k k k k k
of the current row of contiguous (adjacent) cells with values?
k k k k k k k k k
c - correct answer In Excel, what keystroke combination selects the current column?
k k k k k k k k k k k k
a.Alt+space k
b.Alt+enter k
c.Ctrl+space
false - correct answer The COUNTA function ignores cells with text
k k k k k k k k k k
d - correct answer In Excel, after having copied something, what keystroke combination quickly performs a
k k k k k k k k k k k k k k k k
Paste Special operation?
k k
a.Ctrl+Shift+p k
b.Ctrl+Shift+v k
c.Ctrl+v k
d.Ctrl+Alt+v
Business Final Exam
Question Bank with
Verified Answers 2026
,True - correct answer A workbook's documentation sheet should always be showing when saving the file a
k k k k k k k k k k k k k k k k k
final time (right before submitting the file), so that when someone opens your file, the documentation sheet
k k k k k k k k k k k k k k k k k
will be the first sheet seen.k k k k k
True - correct answer A quick way to apply the percent format is to press Ctrl+Shift+%
k k k k k k k k k k k k k k k
e - correct answer In Excel, what keystroke combination changes the cell reference type (to absolute, mixed,
k k k k k k k k k k k k k k k k k
mixed, relative) while entering/editing a formula?
k k k k k
a. none of the answers listed
k k k k k
b. ctrl+shift+f4 k
c.ctrl+`
d.ctrl+f4
e. f4 k
b - correct answer In Excel, what keystroke combination quickly inserts the current date?
k k k k k k k k k k k k k
a. Ctrl+Shift+: (Ctrl, Shift and colon)
k k k k k k
b. Ctrl+; (Ctrl and semi-colon)
k k k k k
c. Ctrl+Shift+# (Ctrl, Shift and number sign)
k k k k k k k
d. Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)
k k k k k k
unrecognized text in a formula - correct answer The error message #NAME? means that there is(are) k k k k k k k k k k k k k k k
a - correct answer In Excel, what keystroke combination moves one screen to the right within the current
k k k k k k k k k k k k k k k k k k
worksheet?
a. alt+pg dn k k
b. shift+pg dn k k
c. ctrl+pg dn
k k
d. ctrl+tab k
,False - correct answer In order to maintain consistency within your workbooks, it is important to format cells
k k k k k k k k k k k k k k k k k k
with formulas (outputs) using the same colors as cells containing assumptions and/or values (inputs)
k k k k k k k k k k k k k
False - correct answer #REF! means invalid numerical values in a formula or function.
k k k k k k k k k k k k k
ctrl+shift+right arrow - correct answer In Excel, what keystroke combination selects right, to the end of the k k k k k k k k k k k k k k k k k
current row of contiguous (adjacent) cells? k k k k k
ctrl+shift+! - correct answer In Excel, what keystroke combination quickly applies the number format to two
k k k k k k k k k k k k k k k k
decimal places? k
mixed - correct answer $B1 is an example of a(n) _____ reference.
k k k k k k k k k k k
false - correct answer The best way to center titles is to use the Merge & Center toolbar/ribbon button.
k k k k k k k k k k k k k k k k k k
ctrl+w and ctrl+f4 - correct answer In Excel, what keystroke combination closes the current workbook?
k k k k k k k k k k k k k k
relative - correct answer B1 is an example of a(n) _____ cell reference.
k k k k k k k k k k k k
ctrl+tab - correct answer What keystroke combination switches between currently open workbooks?
k k k k k k k k k k k
ctrl+z - correct answer In Excel, what keystroke combination performs an "undo" of the last action?
k k k k k k k k k k k k k k k
true - correct answer Using cell references is preferable to directly inputting values into a formula.
k k k k k k k k k k k k k k k
ctrl+d - correct answer If multiple cells are selected/highlighted, what keystroke combination copies the
k k k k k k k k k k k k k k
formula(s)/value(s) in the topmost cell(s) of the selected range down to the other cell(s) in the range of k k k k k k k k k k k k k k k k k k
selected cells? k
, ctrl+minus - correct answer In Excel, after selecting a range of cells, what keystroke combination deletes those
k k k k k k k k k k k k k k k k k
cells? (not just deletes the contents of cells, but deletes the actual cells, so that other cells adjust to replace the
k k k k k k k k k k k k k k k k k k k k k
deleted cells) k
shift+space - correct answer In Excel, what keystroke combination selects the current row?
k k k k k k k k k k k k
d - correct answer In Excel, what keystroke combination quickly applies the General format?
k k k k k k k k k k k k k
a.Ctrl+Shift+@ (Ctrl, Shift and "at" symbol) k k k k k k
b.Ctrl+Shift+# (Ctrl, Shift and number sign) k k k k k k
c.Ctrl+Shift+! (Ctrl, Shift and exclamation mark) k k k k k k
Correct!
d.Ctrl+Shift+~ (Ctrl, Shift and tilde) k k k k
ctrl+right arrow - correct answer In Excel, what keystroke combination moves (the active cell) right, to the end
k k k k k k k k k k k k k k k k k k
of the current row of contiguous (adjacent) cells with values?
k k k k k k k k k
c - correct answer In Excel, what keystroke combination selects the current column?
k k k k k k k k k k k k
a.Alt+space k
b.Alt+enter k
c.Ctrl+space
false - correct answer The COUNTA function ignores cells with text
k k k k k k k k k k
d - correct answer In Excel, after having copied something, what keystroke combination quickly performs a
k k k k k k k k k k k k k k k k
Paste Special operation?
k k
a.Ctrl+Shift+p k
b.Ctrl+Shift+v k
c.Ctrl+v k
d.Ctrl+Alt+v
