BUSI 520 Comprehensive Final Exam Practice Questions and Answers 2026

BUSI 520
Comprehensive Final
Exam Practice
Questions and Answers
2026

,Current date - correct answer Ctrl+; (Ctrl and semi-colon)
k k k k k k k k




Shows format cells dialog window - correct answer Ctrl+1 (Ctrl and 1)
k k k k k k k k k k k




using cell reference is preferred to directly inputting values into a formula - correct answer true
k k k k k k k k k k k k k k k




inserts cells - correct answer Ctrl+Shift+plus
k k k k k




documentation sheet should be showing when saving a file so its seen first when opening it - correct answer k k k k k k k k k k k k k k k k k k k




True



###### - correct answer cells not wide enough
k k k k k k k




selects current row - correct answer Shift + space
k k k k k k k k




displays formulas - correct answer Ctrl + ` k k k k k k k




percent format - correct answer Ctrl+Shift+%k k k k k




#REF - correct answer invalid cell reference
k k k k k k




removes a border - correct answer Ctrl+Shift+_ (Ctrl, Shift and underscore)
k k k k k k k k k k




wrap text first, then adjust width - correct answer True
k k k k k k k k k




best way to center titles is merge and center - correct answer False
k k k k k k k k k k k k




switch between currently open workbooks - correct answer Ctrl + tab
k k k k k k k k k k

, deletes the actual cell - correct answer Ctrl + - (control plus minus)
k k k k k k k k k k k k




When using Excel to open a file that is in .csv format, formulas and formatting entered in the sheet can be safely
k k k k k k k k k k k k k k k k k k k k k




saved in either .csv, .xls or .xlsx format. - correct answer False
k k k k k k k k k k k k




Current Time - correct answer Ctrl + shift + :
k k k k k k k k k




The COUNTA function ignores cells with text - correct answer False
k k k k k k k k k k




If multiple cells (in more than one column) are selected/highlighted, what keystroke combination copies the
k k k k k k k k k k k k k k k




formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the other cells in the range of k k k k k k k k k k k k k k k k k k k k




selected cells? - correct answer Ctrl+r k k k k k




adds a border - correct answer Ctrl+Shift+& (Ctrl, Shift and ampersand)
k k k k k k k k k k




moves one screen (worth of columns) to the right within the current worksheet? - correct answer Alt+Pg dn
k k k k k k k k k k k k k k k k k




COUNT(number1, number 2, ...) determines the sum of a list of values. - correct answer False k k k k k k k k k k k k k k k




changes the cell reference type (to absolute, then mixed, then mixed, then relative) while entering or editing a
k k k k k k k k k k k k k k k k k k




formula - correct answer F4 k k k k




If multiple cells (in more than one row) are selected/highlighted, what keystroke combination copies the
k 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 - correct answer Ctrl + d k k k k k k k




applies the number format to two decimal places - correct answer Ctrl+Shift+! (Ctrl, Shift and exclamation
k k k k k k k k k k k k k k k k




mark)



date format - correct answer Ctrl+Shift+#
k k k k k