BUSI 520 FINAL EXAM | COMPLETE QUESTIONS AND ANSWERS | 2026 LATEST
UPDATED| 100% RATED CORRECT | GET A+!!
Current date - (Answer)Ctrl+; (Ctrl and semi-colon)
Shows format cells dialog window - (Answer)Ctrl+1 (Ctrl and 1)
using cell reference is preferred to directly inputting values into a formula - (Answer)true
inserts cells - (Answer)Ctrl+Shift+plus
documentation sheet should be showing when saving a file so its seen first when opening it -
(Answer)True
###### - (Answer)cells not wide enough
selects current row - (Answer)Shift + space
,displays formulas - (Answer)Ctrl + `
percent format - (Answer)Ctrl+Shift+%
#REF - (Answer)invalid cell reference
removes a border - (Answer)Ctrl+Shift+_ (Ctrl, Shift and underscore)
wrap text first, then adjust width - (Answer)True
best way to center titles is merge and center - (Answer)False
switch between currently open workbooks - (Answer)Ctrl + tab
deletes the actual cell - (Answer)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. - (Answer)False
Current Time - (Answer)Ctrl + shift + :
The COUNTA function ignores cells with text - (Answer)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? - (Answer)Ctrl+r
adds a border - (Answer)Ctrl+Shift+& (Ctrl, Shift and ampersand)
moves one screen (worth of columns) to the right within the current worksheet? - (Answer)Alt+Pg
dn
COUNT(number1, number 2, ...) determines the sum of a list of values. - (Answer)False
, changes the cell reference type (to absolute, then mixed, then mixed, then relative) while entering
or editing a formula - (Answer)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 - (Answer)Ctrl + d
applies the number format to two decimal places - (Answer)Ctrl+Shift+! (Ctrl, Shift and
exclamation mark)
date format - (Answer)Ctrl+Shift+#
closes the current workbook - (Answer)Ctrl + F4
Ctrl + w
moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values
- (Answer)Ctrl+right arrow
UPDATED| 100% RATED CORRECT | GET A+!!
Current date - (Answer)Ctrl+; (Ctrl and semi-colon)
Shows format cells dialog window - (Answer)Ctrl+1 (Ctrl and 1)
using cell reference is preferred to directly inputting values into a formula - (Answer)true
inserts cells - (Answer)Ctrl+Shift+plus
documentation sheet should be showing when saving a file so its seen first when opening it -
(Answer)True
###### - (Answer)cells not wide enough
selects current row - (Answer)Shift + space
,displays formulas - (Answer)Ctrl + `
percent format - (Answer)Ctrl+Shift+%
#REF - (Answer)invalid cell reference
removes a border - (Answer)Ctrl+Shift+_ (Ctrl, Shift and underscore)
wrap text first, then adjust width - (Answer)True
best way to center titles is merge and center - (Answer)False
switch between currently open workbooks - (Answer)Ctrl + tab
deletes the actual cell - (Answer)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. - (Answer)False
Current Time - (Answer)Ctrl + shift + :
The COUNTA function ignores cells with text - (Answer)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? - (Answer)Ctrl+r
adds a border - (Answer)Ctrl+Shift+& (Ctrl, Shift and ampersand)
moves one screen (worth of columns) to the right within the current worksheet? - (Answer)Alt+Pg
dn
COUNT(number1, number 2, ...) determines the sum of a list of values. - (Answer)False
, changes the cell reference type (to absolute, then mixed, then mixed, then relative) while entering
or editing a formula - (Answer)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 - (Answer)Ctrl + d
applies the number format to two decimal places - (Answer)Ctrl+Shift+! (Ctrl, Shift and
exclamation mark)
date format - (Answer)Ctrl+Shift+#
closes the current workbook - (Answer)Ctrl + F4
Ctrl + w
moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values
- (Answer)Ctrl+right arrow
