BUSI 520 UPDATED EXAM 2 CERTIFICATION ASSESSMENT 2026 VERIFIED ANSWERS GRADED A+

BUSI 520 UPDATED EXAM 2 CERTIFICATION
ASSESSMENT 2026 VERIFIED ANSWERS
GRADED A+

◉ a.
Answer: 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.
Answer: You should always adjust column widths first, before
attempting to Wrap Text for the column headings.


◉ a.
Answer: 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.
Answer: In Excel, what keystroke combination inserts cells?
a.Ctrl+insert
b.Ctrl+Shift+insert
c.Ctrl+Shift+plus
d.Ctrl+i


◉ false.
Answer: Pressing Ctrl+Shift+# applies the number format.


◉ False.
Answer: 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.
Answer: 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+tab

,◉ d.
Answer: The wrong argument type or operand is shown by
a.#NUM!
b.#NAME?
c.#REF!
d.#VALUE!


◉ b.
Answer: 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.
Answer: 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.
Answer: A quick way to apply the currency format is to press
Ctrl+Shift+$.


◉ False.
Answer: COUNT(number1, number 2, ...) determines the sum of a list
of values.


◉ a.
Answer: In Excel, what keystroke combination quickly inserts the
current time?
a.Ctrl+Shift+: (Ctrl, Shift and colon)
b.Ctrl+Shift+# (Ctrl, Shift and number sign)
c.Ctrl+; (Ctrl and semi-colon)
d.Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)


◉ a.
Answer: If multiple horizontal cells 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?