BUSI 520 EVALUATION EXAM 2026 QUESTIONS AND
ANSWERS RATED A+
✔✔_____ are items that are, in fact, incorrect, but are not flagged as such. - ✔✔false
negatives
✔✔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
✔✔The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - ✔✔false
✔✔The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - ✔✔hiding cells so that users cannot see them
specifying which actions users can perform
locking cells so that users cannot change their contents
✔✔A(n) _____ cell uses the value in the active cell in its formula. - ✔✔dependent
✔✔After you create and test a macro, you can attach a _____ to vouch for its
authenticity. - ✔✔D. digital certificat
✔✔the Error Alert Style of _____ indicates the entry is incorrect and must be canceled
or corrected before continuing. - ✔✔stop
✔✔The data validation tool restricts the _____. - ✔✔data being entered
✔✔_____ prevents changing, moving, or deleting data. - ✔✔worksheet protection
✔✔The Circle Invalid Data button circles cells that _____. - ✔✔don't meet their data
validation criteria
✔✔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 comparison phrase of "not between" means to identify values outside of lower
and upper limits. - ✔✔true
✔✔The AND function results in a FALSE value if either Condition #1 or Condition #2 is
___ - ✔✔false
,✔✔It's usually okay to hard-code (enter) text phrases in IF functions and Conditional
formatting rules in order to make the formulas more flexible. - ✔✔false
✔✔Relational operators can be used to evaluate dates. - ✔✔true
✔✔If the values in cells F3, F4, F5, and F6 are all less than 100, the function
=OR(F3>100,F4>100,F5>100,F6>100) returns a value of ______. - ✔✔false
✔✔The result of the formula =SUM(4,7)<>11 is _____. - ✔✔false
✔✔(Ignoring the initial = that precedes a formula,) you cannot use two operators (<=,
>=, =, etc.) within the same logical_test argument of an IF function unless you also use
an additional function such as OR or AND. - ✔✔true
✔✔To apply "Cell Value Is" conditional formatting, first _____. - ✔✔D. select the cells
you want to conditionally format
✔✔The formula =OR(B5:B25) returns a value of _____ if any of the values in B5
through B25 contain the value TRUE. - ✔✔TRUE
✔✔When using a IF function, formulas can be used within a Value_if_true or
Value_if_false argument if the formula is enclosed within quotation marks. - ✔✔false
✔✔=AND(F3,NOT(OR(G3:H3))) is an example of a(n) _____ construct. - ✔✔only
✔✔The logical construct =AND(A3:A30) is used when only one item must be TRUE to
return a TRUE value. - ✔✔false
✔✔Relational operators can only be used to evaluate numbers...not text. - ✔✔false
✔✔TRUE and FALSE are Boolean values. - ✔✔true
✔✔The relational operator for "not equal" is _____. - ✔✔<>
✔✔If a cell contains the formula =Goodbye<Hello the resulting value is _____. (Assume
no range names have been defined.) - ✔✔#NAME?
✔✔To find whether an integer in cell A1 is in the 20's (20, 21....29), you could use the
following formula: =OR(A1>=20,A1<=29). - ✔✔false
✔✔A(n) _____ function returns a value of TRUE if at least one argument is TRUE. -
✔✔OR
, ✔✔to change a TRUE value to FALSE, or a FALSE value to TRUE, use the _____
function. - ✔✔NOT
✔✔To evaluate a logical test and return a TRUE or FALSE value, you need to use an IF
function. - ✔✔false
✔✔When using an OR function, if only one of two arguments equals FALSE (and the
other argument equals TRUE), an OR function results in a value of _____. - ✔✔true
✔✔If the values in cells F3, F4, F5, and F6 are all greater than 100, the formula
=OR(F3:F6>100) will always return a value of TRUE - ✔✔false
✔✔A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE.
- ✔✔or
✔✔The OR function evaluates logical arguments to determine if at least one argument
is TRUE. - ✔✔true
✔✔Relational operators can be used to evaluate _____. - ✔✔dates
numbers
text
✔✔The formula =OR(45<44,MIN(1,10)<2,3<=2+1) returns a value of ______. - ✔✔true
✔✔If the cell M1 contains Monkey1 and cell D1 contains Dog2, the formula =M1<=D1
results in a value of _____. - ✔✔false
✔✔An equivalent formula for =IF(G3=0,C3,C3+G3+25) is _____. -
✔✔=IF(G3<>0,C3+G3+25,C3)
✔✔The comparison phrase of "between" is used to _____. - ✔✔C. set lower and upper
limits inclusive of the specified values
✔✔In Excel, relational operators can be used to determine if an expression is ____ -
✔✔true or false
✔✔If you want apply formatting to G3 based on the value in cell F3, use conditional
formatting's "Format only cells that contain" option. - ✔✔false
✔✔Be sure to always include an = sign in front of any formulas inserted within the
Value_if_true or Value_if_false argument of an IF function. - ✔✔false
ANSWERS RATED A+
✔✔_____ are items that are, in fact, incorrect, but are not flagged as such. - ✔✔false
negatives
✔✔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
✔✔The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - ✔✔false
✔✔The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - ✔✔hiding cells so that users cannot see them
specifying which actions users can perform
locking cells so that users cannot change their contents
✔✔A(n) _____ cell uses the value in the active cell in its formula. - ✔✔dependent
✔✔After you create and test a macro, you can attach a _____ to vouch for its
authenticity. - ✔✔D. digital certificat
✔✔the Error Alert Style of _____ indicates the entry is incorrect and must be canceled
or corrected before continuing. - ✔✔stop
✔✔The data validation tool restricts the _____. - ✔✔data being entered
✔✔_____ prevents changing, moving, or deleting data. - ✔✔worksheet protection
✔✔The Circle Invalid Data button circles cells that _____. - ✔✔don't meet their data
validation criteria
✔✔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 comparison phrase of "not between" means to identify values outside of lower
and upper limits. - ✔✔true
✔✔The AND function results in a FALSE value if either Condition #1 or Condition #2 is
___ - ✔✔false
,✔✔It's usually okay to hard-code (enter) text phrases in IF functions and Conditional
formatting rules in order to make the formulas more flexible. - ✔✔false
✔✔Relational operators can be used to evaluate dates. - ✔✔true
✔✔If the values in cells F3, F4, F5, and F6 are all less than 100, the function
=OR(F3>100,F4>100,F5>100,F6>100) returns a value of ______. - ✔✔false
✔✔The result of the formula =SUM(4,7)<>11 is _____. - ✔✔false
✔✔(Ignoring the initial = that precedes a formula,) you cannot use two operators (<=,
>=, =, etc.) within the same logical_test argument of an IF function unless you also use
an additional function such as OR or AND. - ✔✔true
✔✔To apply "Cell Value Is" conditional formatting, first _____. - ✔✔D. select the cells
you want to conditionally format
✔✔The formula =OR(B5:B25) returns a value of _____ if any of the values in B5
through B25 contain the value TRUE. - ✔✔TRUE
✔✔When using a IF function, formulas can be used within a Value_if_true or
Value_if_false argument if the formula is enclosed within quotation marks. - ✔✔false
✔✔=AND(F3,NOT(OR(G3:H3))) is an example of a(n) _____ construct. - ✔✔only
✔✔The logical construct =AND(A3:A30) is used when only one item must be TRUE to
return a TRUE value. - ✔✔false
✔✔Relational operators can only be used to evaluate numbers...not text. - ✔✔false
✔✔TRUE and FALSE are Boolean values. - ✔✔true
✔✔The relational operator for "not equal" is _____. - ✔✔<>
✔✔If a cell contains the formula =Goodbye<Hello the resulting value is _____. (Assume
no range names have been defined.) - ✔✔#NAME?
✔✔To find whether an integer in cell A1 is in the 20's (20, 21....29), you could use the
following formula: =OR(A1>=20,A1<=29). - ✔✔false
✔✔A(n) _____ function returns a value of TRUE if at least one argument is TRUE. -
✔✔OR
, ✔✔to change a TRUE value to FALSE, or a FALSE value to TRUE, use the _____
function. - ✔✔NOT
✔✔To evaluate a logical test and return a TRUE or FALSE value, you need to use an IF
function. - ✔✔false
✔✔When using an OR function, if only one of two arguments equals FALSE (and the
other argument equals TRUE), an OR function results in a value of _____. - ✔✔true
✔✔If the values in cells F3, F4, F5, and F6 are all greater than 100, the formula
=OR(F3:F6>100) will always return a value of TRUE - ✔✔false
✔✔A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE.
- ✔✔or
✔✔The OR function evaluates logical arguments to determine if at least one argument
is TRUE. - ✔✔true
✔✔Relational operators can be used to evaluate _____. - ✔✔dates
numbers
text
✔✔The formula =OR(45<44,MIN(1,10)<2,3<=2+1) returns a value of ______. - ✔✔true
✔✔If the cell M1 contains Monkey1 and cell D1 contains Dog2, the formula =M1<=D1
results in a value of _____. - ✔✔false
✔✔An equivalent formula for =IF(G3=0,C3,C3+G3+25) is _____. -
✔✔=IF(G3<>0,C3+G3+25,C3)
✔✔The comparison phrase of "between" is used to _____. - ✔✔C. set lower and upper
limits inclusive of the specified values
✔✔In Excel, relational operators can be used to determine if an expression is ____ -
✔✔true or false
✔✔If you want apply formatting to G3 based on the value in cell F3, use conditional
formatting's "Format only cells that contain" option. - ✔✔false
✔✔Be sure to always include an = sign in front of any formulas inserted within the
Value_if_true or Value_if_false argument of an IF function. - ✔✔false
