BUSI 520 FINAL EXAM QUESTIONS AND ANSWERS

BUSI 520 FINAL EXAM QUESTIONS AND ANSWERS


True - Answers - A workbook's documentation sheet should always be showing when
saving the file a final time (right before submitting the file), so that when someone opens
your file, the documentation sheet will be the first sheet seen.

True - Answers - A quick way to apply the percent format is to press Ctrl+Shift+%

e - Answers - In Excel, what keystroke combination changes the cell reference type (to
absolute, mixed, mixed, relative) while entering/editing a formula?
a. none of the answers listed
b. ctrl+shift+f4
c.ctrl+`
d.ctrl+f4
e. f4

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

unrecognized text in a formula - Answers - The error message #NAME? means that
there is(are)

a - Answers - In Excel, what keystroke combination moves one screen to the right within
the current worksheet?
a. alt+pg dn
b. shift+pg dn
c. ctrl+pg dn
d. ctrl+tab

False - Answers - In order to maintain consistency within your workbooks, it is important
to format cells with formulas (outputs) using the same colors as cells containing
assumptions and/or values (inputs)

False - Answers - #REF! means invalid numerical values in a formula or function.

ctrl+shift+right arrow - Answers - In Excel, what keystroke combination selects right, to
the end of the current row of contiguous (adjacent) cells?

ctrl+shift+! - Answers - In Excel, what keystroke combination quickly applies the number
format to two decimal places?

,mixed - Answers - $B1 is an example of a(n) _____ reference.

false - Answers - The best way to center titles is to use the Merge & Center
toolbar/ribbon button.

ctrl+w and ctrl+f4 - Answers - In Excel, what keystroke combination closes the current
workbook?

relative - Answers - B1 is an example of a(n) _____ cell reference.

ctrl+tab - Answers - What keystroke combination switches between currently open
workbooks?

ctrl+z - Answers - In Excel, what keystroke combination performs an "undo" of the last
action?

true - Answers - Using cell references is preferable to directly inputting values into a
formula.

ctrl+d - Answers - If multiple cells 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+minus - Answers - In Excel, after selecting a range of cells, what keystroke
combination deletes those cells? (not just deletes the contents of cells, but deletes the
actual cells, so that other cells adjust to replace the deleted cells)

shift+space - Answers - In Excel, what keystroke combination selects the current row?

d - Answers - In Excel, what keystroke combination quickly applies the General format?
a.Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)
b.Ctrl+Shift+# (Ctrl, Shift and number sign)
c.Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
Correct!
d.Ctrl+Shift+~ (Ctrl, Shift and tilde)

ctrl+right arrow - Answers - In Excel, what keystroke combination moves (the active cell)
right, to the end of the current row of contiguous (adjacent) cells with values?

c - Answers - In Excel, what keystroke combination selects the current column?
a.Alt+space
b.Alt+enter
c.Ctrl+space

false - Answers - The COUNTA function ignores cells with text

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

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

false - Answers - Pressing Ctrl+Shift+# applies the number format.

False - Answers - 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 - Answers - 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 - Answers - The wrong argument type or operand is shown by
a.#NUM!
b.#NAME?
c.#REF!
d.#VALUE!