BUSI 520 STUDY GUIDE 2026 QUESTIONS AND ANSWERS
RATED A+
✔✔If A1=2, B2=3, and C3=10, then what is =A1-B2+C3/10 - ✔✔0
✔✔To quickly toggle Wrap Text use what keystroke combination? - ✔✔Alt h, w
✔✔When renaming a module, a module cannot use the same name as a macro. -
✔✔False
✔✔A(n) _____ cell contains a value that is used in a formula. - ✔✔Precedent
✔✔In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - ✔✔F4 (or Fn+F4)
✔✔The data validation default "Allow" option is _____. - ✔✔any value
✔✔The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - ✔✔False
✔✔To display tracer arrows that indicate which formulas use the value in the active cell,
use the _____ button on the Formula Auditing toolbar. - ✔✔Trace Dependents
✔✔_____ prevents changing, moving, or deleting data. - ✔✔Worksheet protection
✔✔When a worksheet is protected, by default, all cells in the worksheet are unlocked. -
✔✔False
✔✔By choosing Protect Sheet, you can prevent a worksheet from being deleted from a
workbook. - ✔✔False
✔✔A validation rule can specify _____. - ✔✔All of the answers listed.
✔✔A(n) _____ cell uses the value in the active cell in its formula. - ✔✔dependent
✔✔In Excel, what keystroke combination quickly applies the General format? -
✔✔Ctrl+Shift+~ (Ctrl, Shift and tilde)
✔✔A macro can be tested one step at a time by clicking the _____ button in the Macro
dialog box. - ✔✔Step Into
,✔✔Use the _____ button on the Formula Auditing toolbar to keep track of cell
properties such as name, value, and formula, even if the cell is out of view. - ✔✔Watch
Window
✔✔A _____ specifies the type of data that is appropriate/allowed as content in a cell. -
✔✔validation rule
✔✔The data validation tool restricts data being entered and the data already stored in
the worksheet. - ✔✔False
✔✔The Circle Invalid Data button circles cells that _____. - ✔✔don't meet their data
validation criteria
✔✔By changing the Error Checking Rules, you can specify that Excel will alert you
about the following: _____. - ✔✔All of the answers listed.
✔✔The new, Excel 365 threaded comments can contain formatted text and images. -
✔✔True
✔✔To automate repetitive or difficult tasks, use a _____, which is a series of commands
that you store and then run when you need to perform a task. - ✔✔Macro
✔✔Pressing Ctrl+Shift+# applies the number format. - ✔✔True
✔✔To display the formulas on the worksheet, press_____. - ✔✔Ctrl + ` (Ctrl + Left
quote)
✔✔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+d
✔✔Macro viruses are viruses that are written and stored as macros attached to
documents created in Office programs such as Excel, and run when you open the
infected document. - ✔✔True
✔✔The data validation tool restricts the _____. - ✔✔data being entered
✔✔Use the _____ button on the Formula Auditing toolbar to display tracer arrows that
indicate which cells the formula references. - ✔✔Trace Precedents
✔✔You can try to prevent an inexperienced Excel user from "messing up" a workbook
by _____. - ✔✔All of the answers listed.
, ✔✔Locking cells or hiding formulas has no effect unless the worksheet is protected. -
✔✔True
✔✔To unlock cells in a protected workbook, click the Locked box to remove the check
mark on the Protection tab of the __________. - ✔✔Format Cells menu/window
✔✔In Excel, what keystroke combination quickly applies a border around the selected
cell or range? - ✔✔Ctrl+Shift+& (Ctrl, Shift and ampersand)
✔✔_____ prevents inserting, deleting, or renaming worksheets. - ✔✔Workbook
protection
✔✔To round the number 4.43 to next highest even integer, use the formula
=EVEN(4.43). - ✔✔True
✔✔The formula =ROUND(2.49,0) results in _____. - ✔✔2
✔✔The median is the arithmetic average of a set of numbers. - ✔✔False
✔✔What Excel keystroke combination would you use to quickly format cells BELOW a
top row cell formatted with the accounting format? - ✔✔Alt 4 (or Alt+4 or Alt, 4)
✔✔The formula _____ counts all product codes in the range H4:H25 with only a single
character followed by 715. - ✔✔=COUNTIFS(H4:H25,"?715")
✔✔_____ is the average of a set of numbers. - ✔✔Mean
✔✔To quickly show/hide the Home Ribbon use what keystroke combination? -
✔✔Ctrl+F1 (or Ctrl+Fn+F1)
✔✔_____ is the formula that returns the arithmetic mean for the range F4:F20. -
✔✔=AVERAGE(F4:F20)
✔✔The correct formula to count all items in the range E4:E20 that end with a "d" in the
third to last position in the text value is _____. - ✔✔=COUNTIFS(E4:E20,"*d??")
✔✔A professor is interested in comparing the grades for several pairs of students, so he
wants to view their grades side-by-side... What Excel feature is best to use? - ✔✔Split
window
✔✔To count how many "A" grades there in the range C3:C100, use the formula _____.
- ✔✔=COUNTIFS(C3:C100,"A")
RATED A+
✔✔If A1=2, B2=3, and C3=10, then what is =A1-B2+C3/10 - ✔✔0
✔✔To quickly toggle Wrap Text use what keystroke combination? - ✔✔Alt h, w
✔✔When renaming a module, a module cannot use the same name as a macro. -
✔✔False
✔✔A(n) _____ cell contains a value that is used in a formula. - ✔✔Precedent
✔✔In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - ✔✔F4 (or Fn+F4)
✔✔The data validation default "Allow" option is _____. - ✔✔any value
✔✔The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - ✔✔False
✔✔To display tracer arrows that indicate which formulas use the value in the active cell,
use the _____ button on the Formula Auditing toolbar. - ✔✔Trace Dependents
✔✔_____ prevents changing, moving, or deleting data. - ✔✔Worksheet protection
✔✔When a worksheet is protected, by default, all cells in the worksheet are unlocked. -
✔✔False
✔✔By choosing Protect Sheet, you can prevent a worksheet from being deleted from a
workbook. - ✔✔False
✔✔A validation rule can specify _____. - ✔✔All of the answers listed.
✔✔A(n) _____ cell uses the value in the active cell in its formula. - ✔✔dependent
✔✔In Excel, what keystroke combination quickly applies the General format? -
✔✔Ctrl+Shift+~ (Ctrl, Shift and tilde)
✔✔A macro can be tested one step at a time by clicking the _____ button in the Macro
dialog box. - ✔✔Step Into
,✔✔Use the _____ button on the Formula Auditing toolbar to keep track of cell
properties such as name, value, and formula, even if the cell is out of view. - ✔✔Watch
Window
✔✔A _____ specifies the type of data that is appropriate/allowed as content in a cell. -
✔✔validation rule
✔✔The data validation tool restricts data being entered and the data already stored in
the worksheet. - ✔✔False
✔✔The Circle Invalid Data button circles cells that _____. - ✔✔don't meet their data
validation criteria
✔✔By changing the Error Checking Rules, you can specify that Excel will alert you
about the following: _____. - ✔✔All of the answers listed.
✔✔The new, Excel 365 threaded comments can contain formatted text and images. -
✔✔True
✔✔To automate repetitive or difficult tasks, use a _____, which is a series of commands
that you store and then run when you need to perform a task. - ✔✔Macro
✔✔Pressing Ctrl+Shift+# applies the number format. - ✔✔True
✔✔To display the formulas on the worksheet, press_____. - ✔✔Ctrl + ` (Ctrl + Left
quote)
✔✔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+d
✔✔Macro viruses are viruses that are written and stored as macros attached to
documents created in Office programs such as Excel, and run when you open the
infected document. - ✔✔True
✔✔The data validation tool restricts the _____. - ✔✔data being entered
✔✔Use the _____ button on the Formula Auditing toolbar to display tracer arrows that
indicate which cells the formula references. - ✔✔Trace Precedents
✔✔You can try to prevent an inexperienced Excel user from "messing up" a workbook
by _____. - ✔✔All of the answers listed.
, ✔✔Locking cells or hiding formulas has no effect unless the worksheet is protected. -
✔✔True
✔✔To unlock cells in a protected workbook, click the Locked box to remove the check
mark on the Protection tab of the __________. - ✔✔Format Cells menu/window
✔✔In Excel, what keystroke combination quickly applies a border around the selected
cell or range? - ✔✔Ctrl+Shift+& (Ctrl, Shift and ampersand)
✔✔_____ prevents inserting, deleting, or renaming worksheets. - ✔✔Workbook
protection
✔✔To round the number 4.43 to next highest even integer, use the formula
=EVEN(4.43). - ✔✔True
✔✔The formula =ROUND(2.49,0) results in _____. - ✔✔2
✔✔The median is the arithmetic average of a set of numbers. - ✔✔False
✔✔What Excel keystroke combination would you use to quickly format cells BELOW a
top row cell formatted with the accounting format? - ✔✔Alt 4 (or Alt+4 or Alt, 4)
✔✔The formula _____ counts all product codes in the range H4:H25 with only a single
character followed by 715. - ✔✔=COUNTIFS(H4:H25,"?715")
✔✔_____ is the average of a set of numbers. - ✔✔Mean
✔✔To quickly show/hide the Home Ribbon use what keystroke combination? -
✔✔Ctrl+F1 (or Ctrl+Fn+F1)
✔✔_____ is the formula that returns the arithmetic mean for the range F4:F20. -
✔✔=AVERAGE(F4:F20)
✔✔The correct formula to count all items in the range E4:E20 that end with a "d" in the
third to last position in the text value is _____. - ✔✔=COUNTIFS(E4:E20,"*d??")
✔✔A professor is interested in comparing the grades for several pairs of students, so he
wants to view their grades side-by-side... What Excel feature is best to use? - ✔✔Split
window
✔✔To count how many "A" grades there in the range C3:C100, use the formula _____.
- ✔✔=COUNTIFS(C3:C100,"A")
