BUSI 520 UPDATED EXAM 2 COMPREHENSIVE
STUDY SHEET 2026 SOLVED QUESTIONS
PREMIUM BUNDLE
◉ Pressing Ctrl+Shift+# applies the number format.
Answer: False - CTRL+Shift+! (Ctrl, shift and exclamation mark)
applies the number format
◉ If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell
C10, what is the resulting formula?
Answer: =$B$4-SUM(C2:C6)
◉ In Excel, what keystroke combination shows the format cells
dialog window?
Answer: Ctrl+1 (Ctrl and 1)
◉ In Excel, what keystroke combination quickly inserts the current
time?
Answer: Ctrl+Shift+: (Ctrl, Shift and colon)
◉ The error message #NAME? means that there is(are)
Answer: unrecognized text in a formula.
,◉ In Excel, what keystroke combination closes the current
workbook?
Answer: CTRL + F4 OR CTRL + w
◉ $B1 is an example of a(n) _____ reference.
Answer: Mixed
◉ In Excel, what keystroke combination selects the current column?
Answer: CTRL + Space
◉ _____ is(are) first in the order of precedence rules.
Answer: Operations in parentheses - PEMDAS
◉ COUNT(number1, number 2, ...) determines the sum of a list of
values.
Answer: False
◉ 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.
Answer: True
,◉ What keystroke combination switches between currently open
workbooks?
Answer: CTRL + Tab
◉ 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?
Answer: CTRL + r
◉ #REF! means invalid numerical values in a formula or function.
Answer: False
◉ 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).
Answer: False
◉ It is okay to send your homework file to someone else in order to
help the person understand a particular topic.
Answer: False
◉ If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is
, Answer: 0
◉ In Excel, what keystroke combination selects right, to the end of
the current row of contiguous (adjacent) cells?
Answer: CTRL + Shift + Right Arrow
◉ In Excel, after having copied something, what keystroke
combination performs a Paste operation?
Answer: CTRL + v
◉ In Excel, what keystroke combination quickly inserts the current
date?
Answer: CTRL + ;
◉ In Excel, what keystroke combination quickly applies a border
around the selected cell or range?
Answer: Ctrl+Shift+& (Ctrl, Shift and ampersand)
◉ In Excel, what keystroke combination performs an "undo" of the
last action?
Answer: CTRL + z
◉ A quick way to apply the currency format is to press Ctrl+Shift+$.
STUDY SHEET 2026 SOLVED QUESTIONS
PREMIUM BUNDLE
◉ Pressing Ctrl+Shift+# applies the number format.
Answer: False - CTRL+Shift+! (Ctrl, shift and exclamation mark)
applies the number format
◉ If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell
C10, what is the resulting formula?
Answer: =$B$4-SUM(C2:C6)
◉ In Excel, what keystroke combination shows the format cells
dialog window?
Answer: Ctrl+1 (Ctrl and 1)
◉ In Excel, what keystroke combination quickly inserts the current
time?
Answer: Ctrl+Shift+: (Ctrl, Shift and colon)
◉ The error message #NAME? means that there is(are)
Answer: unrecognized text in a formula.
,◉ In Excel, what keystroke combination closes the current
workbook?
Answer: CTRL + F4 OR CTRL + w
◉ $B1 is an example of a(n) _____ reference.
Answer: Mixed
◉ In Excel, what keystroke combination selects the current column?
Answer: CTRL + Space
◉ _____ is(are) first in the order of precedence rules.
Answer: Operations in parentheses - PEMDAS
◉ COUNT(number1, number 2, ...) determines the sum of a list of
values.
Answer: False
◉ 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.
Answer: True
,◉ What keystroke combination switches between currently open
workbooks?
Answer: CTRL + Tab
◉ 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?
Answer: CTRL + r
◉ #REF! means invalid numerical values in a formula or function.
Answer: False
◉ 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).
Answer: False
◉ It is okay to send your homework file to someone else in order to
help the person understand a particular topic.
Answer: False
◉ If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is
, Answer: 0
◉ In Excel, what keystroke combination selects right, to the end of
the current row of contiguous (adjacent) cells?
Answer: CTRL + Shift + Right Arrow
◉ In Excel, after having copied something, what keystroke
combination performs a Paste operation?
Answer: CTRL + v
◉ In Excel, what keystroke combination quickly inserts the current
date?
Answer: CTRL + ;
◉ In Excel, what keystroke combination quickly applies a border
around the selected cell or range?
Answer: Ctrl+Shift+& (Ctrl, Shift and ampersand)
◉ In Excel, what keystroke combination performs an "undo" of the
last action?
Answer: CTRL + z
◉ A quick way to apply the currency format is to press Ctrl+Shift+$.
