BUSI 520 UPDATED EXAM 2 FINAL PAPER 2026
COMPLETE QUESTIONS ANSWERS PREMIUM
STUDY GUIDE
◉ switches (the active worksheet) to the next worksheet (to the
right).
Answer: Ctrl+Pg dn
◉ $B1 is an example of a(n) _____ reference.
Answer: mixed
◉ #NAME?.
Answer: unrecognized text in a formula
◉ #VALUE.
Answer: wrong argument type or operand is shown by
◉ B1 is an example of a(n) _____ cell reference..
Answer: relative
◉ Currency format.
,Answer: Ctrl + shift + $
◉ select current column.
Answer: ctrl + space
◉ Paste Special operation.
Answer: ctrl + alt + v
◉ =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the
resulting formula.
Answer: =$B$4-SUM(C2:C6)
◉ selects left, to the beginning of the current row of contiguous
(adjacent) cells.
Answer: ctrl + shift + left arrow
◉ selects left, to the beginning of the current row of contiguous
(adjacent) cells.
Answer: FALSE
◉ The option of _____ displays a dialog box that provides all the
different paste options..
Answer: paste special
,◉ The formula =TRUNC(4.6) results in the integer value of 5.
Answer: False
◉ The formula _____ counts all product codes in the range H4:H25
with only a single character followed by QXZ..
Answer: =COUNTIF(H4:H25,"?QXZ")
◉ To find the 10th largest value from a list of values in cells
A1:A100, use _____..
Answer: =LARGE(A1:A100,10)
◉ The formula =ROUND(10.59%,2) results in the value 0.11 (or
11%, if formatted as a %)..
Answer: TRUE
◉ The equation (New_Value - Old_Value)/Old_Value can be used to
calculate the percent difference..
Answer: True
◉ To count how many "A" grades there in the range C3:C100, use the
formula _____..
Answer: =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 _____..
Answer: B. any digit, regardless of whether it affects the value of the
number
◉ C. Standard deviation.
Answer: 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 _____..
Answer: 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 _____..
Answer: transpose
◉ To find the relative position of values within a data set, use the
_____ function..
Answer: RANK.EQ/ RANK
COMPLETE QUESTIONS ANSWERS PREMIUM
STUDY GUIDE
◉ switches (the active worksheet) to the next worksheet (to the
right).
Answer: Ctrl+Pg dn
◉ $B1 is an example of a(n) _____ reference.
Answer: mixed
◉ #NAME?.
Answer: unrecognized text in a formula
◉ #VALUE.
Answer: wrong argument type or operand is shown by
◉ B1 is an example of a(n) _____ cell reference..
Answer: relative
◉ Currency format.
,Answer: Ctrl + shift + $
◉ select current column.
Answer: ctrl + space
◉ Paste Special operation.
Answer: ctrl + alt + v
◉ =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the
resulting formula.
Answer: =$B$4-SUM(C2:C6)
◉ selects left, to the beginning of the current row of contiguous
(adjacent) cells.
Answer: ctrl + shift + left arrow
◉ selects left, to the beginning of the current row of contiguous
(adjacent) cells.
Answer: FALSE
◉ The option of _____ displays a dialog box that provides all the
different paste options..
Answer: paste special
,◉ The formula =TRUNC(4.6) results in the integer value of 5.
Answer: False
◉ The formula _____ counts all product codes in the range H4:H25
with only a single character followed by QXZ..
Answer: =COUNTIF(H4:H25,"?QXZ")
◉ To find the 10th largest value from a list of values in cells
A1:A100, use _____..
Answer: =LARGE(A1:A100,10)
◉ The formula =ROUND(10.59%,2) results in the value 0.11 (or
11%, if formatted as a %)..
Answer: TRUE
◉ The equation (New_Value - Old_Value)/Old_Value can be used to
calculate the percent difference..
Answer: True
◉ To count how many "A" grades there in the range C3:C100, use the
formula _____..
Answer: =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 _____..
Answer: B. any digit, regardless of whether it affects the value of the
number
◉ C. Standard deviation.
Answer: 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 _____..
Answer: 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 _____..
Answer: transpose
◉ To find the relative position of values within a data set, use the
_____ function..
Answer: RANK.EQ/ RANK
