BUSI 520 CORE EXAM 2026 TEST QUESTIONS AND
ANSWERS RATED A+
✔✔_____ is the arithmetic value that occurs in the middle of a data set when organized
from lowest to highest. - ✔✔Median
✔✔To fix the rows so that a number of rows are displayed in the top pane while the
bottom pane can be scrolled, _____. - ✔✔use freeze panes
✔✔To find the 10th largest value from a list of values in cells A1:A100, use _____. -
✔✔=LARGE(A1:A100,10)
✔✔The arithmetic value that occurs most frequently in the set is the _____. - ✔✔mode
✔✔The formula =ROUNDDOWN(9.99) results in the value of 10. - ✔✔False
✔✔In the Windows version of Excel, the keyboard shortcut sequence of "Alt h, o, y" will
autofit the column width of the active cell or range of cells. - ✔✔True
✔✔The formula =ROUND(24.449,1) results in _____. - ✔✔24.4
✔✔The formula =ROUNDUP(2.003,2) results in _____. - ✔✔2.01
✔✔The formula =TRUNC(4.6) results in the integer value of 5. - ✔✔False
✔✔For the formula =3+7=10, the resulting value is _____. - ✔✔TRUE
✔✔A(n) _____ function returns a value of TRUE only if all arguments in the function are
TRUE. - ✔✔AND
✔✔In Excel, relational operators can be used to determine if an expression is _____. -
✔✔TRUE or FALSE
✔✔A(n) _____ function returns a value of TRUE if at least one argument is TRUE. -
✔✔OR
✔✔The formula = AND( F3, NOT( OR( G3:H3 ) ) ) is an example of a(n) _____
construct. - ✔✔"Only"
✔✔To find whether the value in cell A1 is in the twenties, what function could you use? -
✔✔AND
, ✔✔In Excel, what keystroke combination moves one screen to the right within the
current worksheet? - ✔✔Alt+Pg dn
✔✔Relational expressions are not case sensitive. - ✔✔True
✔✔The comparison phrase of "not between" means to identify values outside of lower
and upper limits. - ✔✔True
✔✔If the values in F3:F6 are all <100, then =OR(F3>100, F4>100, F5>100, F6>100)
returns - ✔✔FALSE
✔✔It's usually okay to hard-code text phrases in IF functions. - ✔✔False
✔✔To apply "Cell Value Is" conditional formatting, first _____. - ✔✔select the cells you
want to conditionally format
✔✔An equivalent formula for = IF( G3=0, C3, C3+G3+25 ) is _____. - ✔✔=IF(G3<0,
C3+G3+25, C3)
✔✔The formula = AND( FALSE, FALSE, FALSE, FALSE, FALSE, FALSE ) evaluates to
_____. - ✔✔FALSE
✔✔A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE.
- ✔✔OR
✔✔Relational operators can only be used to evaluate numbers...not text. - ✔✔False
✔✔If a cell contains the formula = Goodbye < Hello the resulting value is _____. -
✔✔TRUE
✔✔The comparison phrase of "between" is used to _____. - ✔✔set lower and upper
limits inclusive of the specified values
✔✔To quickly insert a new function or open the Function Arguments window for a
currently entered function, use what keystroke combination? - ✔✔Shift+F3
✔✔If B3 contains 12/31/2006 and C3 contains 12/31/2005, then =B3<C3 is _____. -
✔✔FALSE
✔✔The result of the formula = SUM( 4,7 ) <> 11 is _____. - ✔✔FALSE
✔✔For the expression =A5=B5, the first equal sign is interpreted as _____. - ✔✔the
beginning of the formula
ANSWERS RATED A+
✔✔_____ is the arithmetic value that occurs in the middle of a data set when organized
from lowest to highest. - ✔✔Median
✔✔To fix the rows so that a number of rows are displayed in the top pane while the
bottom pane can be scrolled, _____. - ✔✔use freeze panes
✔✔To find the 10th largest value from a list of values in cells A1:A100, use _____. -
✔✔=LARGE(A1:A100,10)
✔✔The arithmetic value that occurs most frequently in the set is the _____. - ✔✔mode
✔✔The formula =ROUNDDOWN(9.99) results in the value of 10. - ✔✔False
✔✔In the Windows version of Excel, the keyboard shortcut sequence of "Alt h, o, y" will
autofit the column width of the active cell or range of cells. - ✔✔True
✔✔The formula =ROUND(24.449,1) results in _____. - ✔✔24.4
✔✔The formula =ROUNDUP(2.003,2) results in _____. - ✔✔2.01
✔✔The formula =TRUNC(4.6) results in the integer value of 5. - ✔✔False
✔✔For the formula =3+7=10, the resulting value is _____. - ✔✔TRUE
✔✔A(n) _____ function returns a value of TRUE only if all arguments in the function are
TRUE. - ✔✔AND
✔✔In Excel, relational operators can be used to determine if an expression is _____. -
✔✔TRUE or FALSE
✔✔A(n) _____ function returns a value of TRUE if at least one argument is TRUE. -
✔✔OR
✔✔The formula = AND( F3, NOT( OR( G3:H3 ) ) ) is an example of a(n) _____
construct. - ✔✔"Only"
✔✔To find whether the value in cell A1 is in the twenties, what function could you use? -
✔✔AND
, ✔✔In Excel, what keystroke combination moves one screen to the right within the
current worksheet? - ✔✔Alt+Pg dn
✔✔Relational expressions are not case sensitive. - ✔✔True
✔✔The comparison phrase of "not between" means to identify values outside of lower
and upper limits. - ✔✔True
✔✔If the values in F3:F6 are all <100, then =OR(F3>100, F4>100, F5>100, F6>100)
returns - ✔✔FALSE
✔✔It's usually okay to hard-code text phrases in IF functions. - ✔✔False
✔✔To apply "Cell Value Is" conditional formatting, first _____. - ✔✔select the cells you
want to conditionally format
✔✔An equivalent formula for = IF( G3=0, C3, C3+G3+25 ) is _____. - ✔✔=IF(G3<0,
C3+G3+25, C3)
✔✔The formula = AND( FALSE, FALSE, FALSE, FALSE, FALSE, FALSE ) evaluates to
_____. - ✔✔FALSE
✔✔A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE.
- ✔✔OR
✔✔Relational operators can only be used to evaluate numbers...not text. - ✔✔False
✔✔If a cell contains the formula = Goodbye < Hello the resulting value is _____. -
✔✔TRUE
✔✔The comparison phrase of "between" is used to _____. - ✔✔set lower and upper
limits inclusive of the specified values
✔✔To quickly insert a new function or open the Function Arguments window for a
currently entered function, use what keystroke combination? - ✔✔Shift+F3
✔✔If B3 contains 12/31/2006 and C3 contains 12/31/2005, then =B3<C3 is _____. -
✔✔FALSE
✔✔The result of the formula = SUM( 4,7 ) <> 11 is _____. - ✔✔FALSE
✔✔For the expression =A5=B5, the first equal sign is interpreted as _____. - ✔✔the
beginning of the formula
