BUSI 520 FINAL EXAM | QUESTIONS AND
ANSWERS | 2026 UPDATE | WITH
COMPLETE SOLUTIONS.
Current date - ANSWERS-Ctrl+; (Ctrl and semi-colon)
Shows format cells dialog window - ANSWERS-Ctrl+1 (Ctrl and 1)
using cell reference is preferred to directly inputting values into a formula -
ANSWERS-true
inserts cells - ANSWERS-Ctrl+Shift+plus
documentation sheet should be showing when saving a file so its seen first
when opening it - ANSWERS-True
###### - ANSWERS-cells not wide enough
selects current row - ANSWERS-Shift + space
displays formulas - ANSWERS-Ctrl + `
percent format - ANSWERS-Ctrl+Shift+%
#REF - ANSWERS-invalid cell reference
,removes a border - ANSWERS-Ctrl+Shift+_ (Ctrl, Shift and underscore)
wrap text first, then adjust width - ANSWERS-True
best way to center titles is merge and center - ANSWERS-False
switch between currently open workbooks - ANSWERS-Ctrl + tab
deletes the actual cell - ANSWERS-Ctrl + - (control plus minus)
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
Current Time - ANSWERS-Ctrl + shift + :
The COUNTA function ignores cells with text - ANSWERS-False
If multiple cells (in more than one column) are selected/highlighted, what
keystroke combination copies the formula(s)/value(s) in the leftmost cell(s) of
the selected range to the right, to the other cells in the range of selected
cells? - ANSWERS-Ctrl+r
adds a border - ANSWERS-Ctrl+Shift+& (Ctrl, Shift and ampersand)
moves one screen (worth of columns) to the right within the current
worksheet? - ANSWERS-Alt+Pg dn
, COUNT(number1, number 2, ...) determines the sum of a list of values. -
ANSWERS-False
changes the cell reference type (to absolute, then mixed, then mixed, then
relative) while entering or editing a formula - ANSWERS-F4
If multiple cells (in more than one row) 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 -
ANSWERS-Ctrl + d
applies the number format to two decimal places - ANSWERS-Ctrl+Shift+!
(Ctrl, Shift and exclamation mark)
date format - ANSWERS-Ctrl+Shift+#
closes the current workbook - ANSWERS-Ctrl + F4
Ctrl + w
moves (the active cell) right, to the end of the current row of contiguous
(adjacent) cells with values - ANSWERS-Ctrl+right arrow
general number format - ANSWERS-Ctrl + shift + ~
switches (the active worksheet) to the next worksheet (to the right) -
ANSWERS-Ctrl+Pg dn
$B1 is an example of a(n) _____ reference - ANSWERS-mixed
ANSWERS | 2026 UPDATE | WITH
COMPLETE SOLUTIONS.
Current date - ANSWERS-Ctrl+; (Ctrl and semi-colon)
Shows format cells dialog window - ANSWERS-Ctrl+1 (Ctrl and 1)
using cell reference is preferred to directly inputting values into a formula -
ANSWERS-true
inserts cells - ANSWERS-Ctrl+Shift+plus
documentation sheet should be showing when saving a file so its seen first
when opening it - ANSWERS-True
###### - ANSWERS-cells not wide enough
selects current row - ANSWERS-Shift + space
displays formulas - ANSWERS-Ctrl + `
percent format - ANSWERS-Ctrl+Shift+%
#REF - ANSWERS-invalid cell reference
,removes a border - ANSWERS-Ctrl+Shift+_ (Ctrl, Shift and underscore)
wrap text first, then adjust width - ANSWERS-True
best way to center titles is merge and center - ANSWERS-False
switch between currently open workbooks - ANSWERS-Ctrl + tab
deletes the actual cell - ANSWERS-Ctrl + - (control plus minus)
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
Current Time - ANSWERS-Ctrl + shift + :
The COUNTA function ignores cells with text - ANSWERS-False
If multiple cells (in more than one column) are selected/highlighted, what
keystroke combination copies the formula(s)/value(s) in the leftmost cell(s) of
the selected range to the right, to the other cells in the range of selected
cells? - ANSWERS-Ctrl+r
adds a border - ANSWERS-Ctrl+Shift+& (Ctrl, Shift and ampersand)
moves one screen (worth of columns) to the right within the current
worksheet? - ANSWERS-Alt+Pg dn
, COUNT(number1, number 2, ...) determines the sum of a list of values. -
ANSWERS-False
changes the cell reference type (to absolute, then mixed, then mixed, then
relative) while entering or editing a formula - ANSWERS-F4
If multiple cells (in more than one row) 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 -
ANSWERS-Ctrl + d
applies the number format to two decimal places - ANSWERS-Ctrl+Shift+!
(Ctrl, Shift and exclamation mark)
date format - ANSWERS-Ctrl+Shift+#
closes the current workbook - ANSWERS-Ctrl + F4
Ctrl + w
moves (the active cell) right, to the end of the current row of contiguous
(adjacent) cells with values - ANSWERS-Ctrl+right arrow
general number format - ANSWERS-Ctrl + shift + ~
switches (the active worksheet) to the next worksheet (to the right) -
ANSWERS-Ctrl+Pg dn
$B1 is an example of a(n) _____ reference - ANSWERS-mixed
