BUSI 520 COMPREHENSIVE EXAM 2026 QUESTIONS AND
ANSWERS RATED A+
✔✔#VALUE - ✔✔wrong argument type or operand is shown by
✔✔B1 is an example of a(n) _____ cell reference. - ✔✔relative
✔✔Currency format - ✔✔Ctrl + shift + $
✔✔select current column - ✔✔ctrl + space
✔✔Paste Special operation - ✔✔ctrl + alt + v
✔✔=$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula -
✔✔=$B$4-SUM(C2:C6)
✔✔selects left, to the beginning of the current row of contiguous (adjacent) cells -
✔✔ctrl + shift + left arrow
✔✔selects left, to the beginning of the current row of contiguous (adjacent) cells -
✔✔FALSE
✔✔The option of _____ displays a dialog box that provides all the different paste
options. - ✔✔paste special
✔✔The formula =TRUNC(4.6) results in the integer value of 5 - ✔✔False
✔✔The formula _____ counts all product codes in the range H4:H25 with only a single
character followed by QXZ. - ✔✔=COUNTIF(H4:H25,"?QXZ")
✔✔To find the 10th largest value from a list of values in cells A1:A100, use _____. -
✔✔=LARGE(A1:A100,10)
✔✔The formula =ROUND(10.59%,2) results in the value 0.11 (or 11%, if formatted as a
%). - ✔✔TRUE
✔✔The equation (New_Value - Old_Value)/Old_Value can be used to calculate the
percent difference. - ✔✔True
✔✔To count how many "A" grades there in the range C3:C100, use the formula _____.
- ✔✔=COUNTIF(C3:C100,"A")
,✔✔When numbers containing zeros are entered in a cell, if 0 is used as one of the
digits in the cell's custom formatting code, that digit displays _____. - ✔✔B. any digit,
regardless of whether it affects the value of the number
✔✔C. Standard deviation - ✔✔a measure of how widely the data values are dispersed
from the arithmetic mean.
✔✔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 _____. - ✔✔E. =COUNTIF(E4:E20,"*d??")
✔✔To change the rows of the original cell range to become the columns in the pasted
cell range, use the Paste (or Paste Special) Option of _____. - ✔✔transpose
✔✔To find the relative position of values within a data set, use the _____ function. -
✔✔RANK.EQ/ RANK
✔✔To fix the rows so that a number of rows are displayed in the top pane (and cannot
be scrolled) while the bottom pane can be scrolled, ____ - ✔✔freeze panes
✔✔A _____ exhibits an equal number of occurrences of data values both above and
below the arithmetic mean. - ✔✔normal distribution
✔✔The correct formula for counting values in the range D5:D25 that are greater than 90
is _____. - ✔✔B. =COUNTIF(D5:D25,">90")
✔✔A professor is interested in comparing the grades for several pairs of students, so he
wants to view their grades side-by-side, to see if the grades are similar. What Excel
feature is best to use? (You should be able to scroll in both the top window and the
bottom window, in order to easily view different pairs of students.) - ✔✔split window
✔✔Locking cells or hiding formulas has no effect unless the worksheet is protected. -
✔✔true
✔✔The Error Alert Style of _____ indicates the entry does not conform to the data
validation rules, and is accepted or canceled. - ✔✔information
✔✔Use the _____ button on the Formula Auditing toolbar to display tracer arrows that
indicate which cells the formula references. - ✔✔trace precedents
✔✔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(n) _____ cell contains a value that is used in a formula. - ✔✔precedent
✔✔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
✔✔The Error Alert Style of _____ indicates the entry does not conform to the data
validation rules, and can be canceled, corrected, or accepted. - ✔✔warning
✔✔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
✔✔The data validation default (list box) option is _____. - ✔✔any value
✔✔A macro can be tested one step at a time by clicking the _____ button in the Macro
dialog box. - ✔✔step into
✔✔Data validation rules can contain formulas. - ✔✔true
✔✔By changing the Error Checking Rules, you can specify that Excel will alert you
about the following: _____. - ✔✔A. Cells containing years represented as 2 digits
C. Formulas which omit cells in a region
D. Unlocked cells containing formulas
✔✔A validation rule can specify _____. - ✔✔dates, values such as between 1 and 100,
decimal number
✔✔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
✔✔_____ prevents inserting, deleting, or renaming worksheets. - ✔✔workbook
protection
✔✔A _____ specifies the type of data that is appropriate/allowed as content in a cell
(...for example, whole numbers, decimal numbers, dates, time, or text). - ✔✔validation
rule
✔✔_____ are items that are, in fact, incorrect, but are not flagged as such. - ✔✔false
negatives
ANSWERS RATED A+
✔✔#VALUE - ✔✔wrong argument type or operand is shown by
✔✔B1 is an example of a(n) _____ cell reference. - ✔✔relative
✔✔Currency format - ✔✔Ctrl + shift + $
✔✔select current column - ✔✔ctrl + space
✔✔Paste Special operation - ✔✔ctrl + alt + v
✔✔=$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula -
✔✔=$B$4-SUM(C2:C6)
✔✔selects left, to the beginning of the current row of contiguous (adjacent) cells -
✔✔ctrl + shift + left arrow
✔✔selects left, to the beginning of the current row of contiguous (adjacent) cells -
✔✔FALSE
✔✔The option of _____ displays a dialog box that provides all the different paste
options. - ✔✔paste special
✔✔The formula =TRUNC(4.6) results in the integer value of 5 - ✔✔False
✔✔The formula _____ counts all product codes in the range H4:H25 with only a single
character followed by QXZ. - ✔✔=COUNTIF(H4:H25,"?QXZ")
✔✔To find the 10th largest value from a list of values in cells A1:A100, use _____. -
✔✔=LARGE(A1:A100,10)
✔✔The formula =ROUND(10.59%,2) results in the value 0.11 (or 11%, if formatted as a
%). - ✔✔TRUE
✔✔The equation (New_Value - Old_Value)/Old_Value can be used to calculate the
percent difference. - ✔✔True
✔✔To count how many "A" grades there in the range C3:C100, use the formula _____.
- ✔✔=COUNTIF(C3:C100,"A")
,✔✔When numbers containing zeros are entered in a cell, if 0 is used as one of the
digits in the cell's custom formatting code, that digit displays _____. - ✔✔B. any digit,
regardless of whether it affects the value of the number
✔✔C. Standard deviation - ✔✔a measure of how widely the data values are dispersed
from the arithmetic mean.
✔✔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 _____. - ✔✔E. =COUNTIF(E4:E20,"*d??")
✔✔To change the rows of the original cell range to become the columns in the pasted
cell range, use the Paste (or Paste Special) Option of _____. - ✔✔transpose
✔✔To find the relative position of values within a data set, use the _____ function. -
✔✔RANK.EQ/ RANK
✔✔To fix the rows so that a number of rows are displayed in the top pane (and cannot
be scrolled) while the bottom pane can be scrolled, ____ - ✔✔freeze panes
✔✔A _____ exhibits an equal number of occurrences of data values both above and
below the arithmetic mean. - ✔✔normal distribution
✔✔The correct formula for counting values in the range D5:D25 that are greater than 90
is _____. - ✔✔B. =COUNTIF(D5:D25,">90")
✔✔A professor is interested in comparing the grades for several pairs of students, so he
wants to view their grades side-by-side, to see if the grades are similar. What Excel
feature is best to use? (You should be able to scroll in both the top window and the
bottom window, in order to easily view different pairs of students.) - ✔✔split window
✔✔Locking cells or hiding formulas has no effect unless the worksheet is protected. -
✔✔true
✔✔The Error Alert Style of _____ indicates the entry does not conform to the data
validation rules, and is accepted or canceled. - ✔✔information
✔✔Use the _____ button on the Formula Auditing toolbar to display tracer arrows that
indicate which cells the formula references. - ✔✔trace precedents
✔✔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(n) _____ cell contains a value that is used in a formula. - ✔✔precedent
✔✔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
✔✔The Error Alert Style of _____ indicates the entry does not conform to the data
validation rules, and can be canceled, corrected, or accepted. - ✔✔warning
✔✔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
✔✔The data validation default (list box) option is _____. - ✔✔any value
✔✔A macro can be tested one step at a time by clicking the _____ button in the Macro
dialog box. - ✔✔step into
✔✔Data validation rules can contain formulas. - ✔✔true
✔✔By changing the Error Checking Rules, you can specify that Excel will alert you
about the following: _____. - ✔✔A. Cells containing years represented as 2 digits
C. Formulas which omit cells in a region
D. Unlocked cells containing formulas
✔✔A validation rule can specify _____. - ✔✔dates, values such as between 1 and 100,
decimal number
✔✔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
✔✔_____ prevents inserting, deleting, or renaming worksheets. - ✔✔workbook
protection
✔✔A _____ specifies the type of data that is appropriate/allowed as content in a cell
(...for example, whole numbers, decimal numbers, dates, time, or text). - ✔✔validation
rule
✔✔_____ are items that are, in fact, incorrect, but are not flagged as such. - ✔✔false
negatives
