BUSI 520 UPDATED EXAM 2 PRACTICE TEST
2026 FULL SOLUTIONS REVIEW PACK
◉ True.
Answer: A quick way to apply the percent format is to press
Ctrl+Shift+%
◉ e.
Answer: In Excel, what keystroke combination changes the cell
reference type (to absolute, mixed, mixed, relative) while
entering/editing a formula?
a. none of the answers listed
b. ctrl+shift+f4
c.ctrl+`
d.ctrl+f4
e. f4
◉ b.
Answer: In Excel, what keystroke combination quickly inserts the
current date?
a. Ctrl+Shift+: (Ctrl, Shift and colon)
b. Ctrl+; (Ctrl and semi-colon)
,c. Ctrl+Shift+# (Ctrl, Shift and number sign)
d. Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)
◉ unrecognized text in a formula.
Answer: The error message #NAME? means that there is(are)
◉ a.
Answer: In Excel, what keystroke combination moves one screen to
the right within the current worksheet?
a. alt+pg dn
b. shift+pg dn
c. ctrl+pg dn
d. ctrl+tab
◉ False.
Answer: 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.
Answer: #REF! means invalid numerical values in a formula or
function.
,◉ ctrl+shift+right arrow.
Answer: In Excel, what keystroke combination selects right, to the
end of the current row of contiguous (adjacent) cells?
◉ ctrl+shift+!.
Answer: In Excel, what keystroke combination quickly applies the
number format to two decimal places?
◉ mixed.
Answer: $B1 is an example of a(n) _____ reference.
◉ false.
Answer: The best way to center titles is to use the Merge & Center
toolbar/ribbon button.
◉ ctrl+w and ctrl+f4.
Answer: In Excel, what keystroke combination closes the current
workbook?
◉ relative.
Answer: B1 is an example of a(n) _____ cell reference.
◉ ctrl+tab.
, Answer: What keystroke combination switches between currently
open workbooks?
◉ ctrl+z.
Answer: In Excel, what keystroke combination performs an "undo"
of the last action?
◉ true.
Answer: Using cell references is preferable to directly inputting
values into a formula.
◉ ctrl+d.
Answer: 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+minus.
Answer: 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)
◉ shift+space.
2026 FULL SOLUTIONS REVIEW PACK
◉ True.
Answer: A quick way to apply the percent format is to press
Ctrl+Shift+%
◉ e.
Answer: In Excel, what keystroke combination changes the cell
reference type (to absolute, mixed, mixed, relative) while
entering/editing a formula?
a. none of the answers listed
b. ctrl+shift+f4
c.ctrl+`
d.ctrl+f4
e. f4
◉ b.
Answer: In Excel, what keystroke combination quickly inserts the
current date?
a. Ctrl+Shift+: (Ctrl, Shift and colon)
b. Ctrl+; (Ctrl and semi-colon)
,c. Ctrl+Shift+# (Ctrl, Shift and number sign)
d. Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)
◉ unrecognized text in a formula.
Answer: The error message #NAME? means that there is(are)
◉ a.
Answer: In Excel, what keystroke combination moves one screen to
the right within the current worksheet?
a. alt+pg dn
b. shift+pg dn
c. ctrl+pg dn
d. ctrl+tab
◉ False.
Answer: 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.
Answer: #REF! means invalid numerical values in a formula or
function.
,◉ ctrl+shift+right arrow.
Answer: In Excel, what keystroke combination selects right, to the
end of the current row of contiguous (adjacent) cells?
◉ ctrl+shift+!.
Answer: In Excel, what keystroke combination quickly applies the
number format to two decimal places?
◉ mixed.
Answer: $B1 is an example of a(n) _____ reference.
◉ false.
Answer: The best way to center titles is to use the Merge & Center
toolbar/ribbon button.
◉ ctrl+w and ctrl+f4.
Answer: In Excel, what keystroke combination closes the current
workbook?
◉ relative.
Answer: B1 is an example of a(n) _____ cell reference.
◉ ctrl+tab.
, Answer: What keystroke combination switches between currently
open workbooks?
◉ ctrl+z.
Answer: In Excel, what keystroke combination performs an "undo"
of the last action?
◉ true.
Answer: Using cell references is preferable to directly inputting
values into a formula.
◉ ctrl+d.
Answer: 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+minus.
Answer: 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)
◉ shift+space.
