BUSI 520 Final Exam Exam comprehensive questions | FREQUENTLY
MOST TESTED QUESTIONS AND VERIFIED SOLUTIONS @ 2026-2027
d
In Excel, after having copied something, what keystroke combination quickly
performs a Paste Special operation?
a.Ctrl+Shift
+p
b.Ctrl+Shift
+v c.Ctrl+v
d.Ctrl+Alt+
v
a
The error message ###### means that there is(are)
a.insufficient width in cell to display data, or negative
date/time. b.an invalid cell reference.
c.invalid numeric values in a formula or
function. d.no valid answer.
False
You should always adjust column widths first, before attempting to Wrap Text
for the column headings.
,a
In Excel, what keystroke combination shows the format cells dialog
window? a.Ctrl+1 (Ctrl and 1)
b.Ctrl+Shift+! (Ctrl, Shift and exclamation
mark) c.Ctrl+` (Ctrl and left quote (grave
accent)) d.Ctrl+Shift+~ (Ctrl, Shift and tilde)
c
In Excel, what keystroke combination inserts
cells? a.Ctrl+insert
b.Ctrl+Shift+ins
ert
c.Ctrl+Shift+pl
us d.Ctrl+i
false
Pressing Ctrl+Shift+# applies the number format.
False
The Accounting Format inserts a dollar sign directly in front of (and flush
against) the leftmost number in the cell, like this: $1.00
,b
In Excel, what keystroke combination switches (the active worksheet) to the
next worksheet (to the right)?
a. Alt+Pg dn
b. Ctrl+Pg
dn
c.Ctrl+tab
d.Shift+ta
b
, d
The wrong argument type or operand is
shown by a.#NUM!
b.#NAME?
c.#REF!
d.#VALUE!
b
In Excel, what keystroke combination quickly applies a border around the
selected cell or range?
a.Ctrl+Shift+_ (Ctrl, Shift and
underscore) b.Ctrl+Shift+& (Ctrl,
Shift and ampersand) c.Ctrl+- (Ctrl
and minus)
d.Ctrl+Shift+= (Ctrl, Shift and equal sign
b
In Excel, what keystroke combination quickly removes a border from the
selected cell or range?
a. Ctrl+- (Ctrl and minus)
b. Ctrl+Shift+_ (Ctrl, Shift and
underscore) c.Ctrl+= (Ctrl and
equal sign) d.Ctrl+Shift+& (Ctrl,
Shift and ampersand)
true
A quick way to apply the currency format is to press Ctrl+Shift+$.
MOST TESTED QUESTIONS AND VERIFIED SOLUTIONS @ 2026-2027
d
In Excel, after having copied something, what keystroke combination quickly
performs a Paste Special operation?
a.Ctrl+Shift
+p
b.Ctrl+Shift
+v c.Ctrl+v
d.Ctrl+Alt+
v
a
The error message ###### means that there is(are)
a.insufficient width in cell to display data, or negative
date/time. b.an invalid cell reference.
c.invalid numeric values in a formula or
function. d.no valid answer.
False
You should always adjust column widths first, before attempting to Wrap Text
for the column headings.
,a
In Excel, what keystroke combination shows the format cells dialog
window? a.Ctrl+1 (Ctrl and 1)
b.Ctrl+Shift+! (Ctrl, Shift and exclamation
mark) c.Ctrl+` (Ctrl and left quote (grave
accent)) d.Ctrl+Shift+~ (Ctrl, Shift and tilde)
c
In Excel, what keystroke combination inserts
cells? a.Ctrl+insert
b.Ctrl+Shift+ins
ert
c.Ctrl+Shift+pl
us d.Ctrl+i
false
Pressing Ctrl+Shift+# applies the number format.
False
The Accounting Format inserts a dollar sign directly in front of (and flush
against) the leftmost number in the cell, like this: $1.00
,b
In Excel, what keystroke combination switches (the active worksheet) to the
next worksheet (to the right)?
a. Alt+Pg dn
b. Ctrl+Pg
dn
c.Ctrl+tab
d.Shift+ta
b
, d
The wrong argument type or operand is
shown by a.#NUM!
b.#NAME?
c.#REF!
d.#VALUE!
b
In Excel, what keystroke combination quickly applies a border around the
selected cell or range?
a.Ctrl+Shift+_ (Ctrl, Shift and
underscore) b.Ctrl+Shift+& (Ctrl,
Shift and ampersand) c.Ctrl+- (Ctrl
and minus)
d.Ctrl+Shift+= (Ctrl, Shift and equal sign
b
In Excel, what keystroke combination quickly removes a border from the
selected cell or range?
a. Ctrl+- (Ctrl and minus)
b. Ctrl+Shift+_ (Ctrl, Shift and
underscore) c.Ctrl+= (Ctrl and
equal sign) d.Ctrl+Shift+& (Ctrl,
Shift and ampersand)
true
A quick way to apply the currency format is to press Ctrl+Shift+$.
