BUSI 520 End Term Business Final Exam Question Bank with Verified Answers 2026

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