Busi 520 Final Exam (2026-2027 Newest
Update) with Most Tested Questions and
Correct Answers Guaranteed / Fully
Solved / Graded A+
Current date
Ctrl+; (Ctrl and semi-colon)
Shows format cells dialog window
Ctrl+1 (Ctrl and 1)
using cell reference is preferred to directly inputting values into a
formula
true
inserts cells
Ctrl+Shift+plus
documentation sheet should be showing when saving a file so its
seen first when opening it
True
######
cells not wide enough
selects current row
Shift + space
displays formulas
Ctrl + `
percent format
Ctrl+Shift+%
,#REF
invalid cell reference
removes a border
Ctrl+Shift+_ (Ctrl, Shift and underscore)
wrap text first, then adjust width
True
best way to center titles is merge and center
False
switch between currently open workbooks
Ctrl + tab
deletes the actual cell
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.
False
Current Time
Ctrl + shift + :
The COUNTA function ignores cells with text
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?
Ctrl+r
adds a border
Ctrl+Shift+& (Ctrl, Shift and ampersand)
moves one screen (worth of columns) to the right within the current
worksheet?
Alt+Pg dn
COUNT(number1, number 2, ...) determines the sum of a list of
values.
, False
changes the cell reference type (to absolute, then mixed, then
mixed, then relative) while entering or editing a formula
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
Ctrl + d
applies the number format to two decimal places
Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
date format
Ctrl+Shift+#
closes the current workbook
Ctrl + F4
Ctrl + w
moves (the active cell) right, to the end of the current row of
contiguous (adjacent) cells with values
Ctrl+right arrow
general number format
Ctrl + shift + ~
switches (the active worksheet) to the next worksheet (to the right)
Ctrl+Pg dn
$B1 is an example of a(n) _____ reference
mixed
#NAME?
unrecognized text in a formula
#VALUE
wrong argument type or operand is shown by
B1 is an example of a(n) _____ cell reference.
relative
Currency format
Update) with Most Tested Questions and
Correct Answers Guaranteed / Fully
Solved / Graded A+
Current date
Ctrl+; (Ctrl and semi-colon)
Shows format cells dialog window
Ctrl+1 (Ctrl and 1)
using cell reference is preferred to directly inputting values into a
formula
true
inserts cells
Ctrl+Shift+plus
documentation sheet should be showing when saving a file so its
seen first when opening it
True
######
cells not wide enough
selects current row
Shift + space
displays formulas
Ctrl + `
percent format
Ctrl+Shift+%
,#REF
invalid cell reference
removes a border
Ctrl+Shift+_ (Ctrl, Shift and underscore)
wrap text first, then adjust width
True
best way to center titles is merge and center
False
switch between currently open workbooks
Ctrl + tab
deletes the actual cell
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.
False
Current Time
Ctrl + shift + :
The COUNTA function ignores cells with text
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?
Ctrl+r
adds a border
Ctrl+Shift+& (Ctrl, Shift and ampersand)
moves one screen (worth of columns) to the right within the current
worksheet?
Alt+Pg dn
COUNT(number1, number 2, ...) determines the sum of a list of
values.
, False
changes the cell reference type (to absolute, then mixed, then
mixed, then relative) while entering or editing a formula
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
Ctrl + d
applies the number format to two decimal places
Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
date format
Ctrl+Shift+#
closes the current workbook
Ctrl + F4
Ctrl + w
moves (the active cell) right, to the end of the current row of
contiguous (adjacent) cells with values
Ctrl+right arrow
general number format
Ctrl + shift + ~
switches (the active worksheet) to the next worksheet (to the right)
Ctrl+Pg dn
$B1 is an example of a(n) _____ reference
mixed
#NAME?
unrecognized text in a formula
#VALUE
wrong argument type or operand is shown by
B1 is an example of a(n) _____ cell reference.
relative
Currency format
