MGSC 290 Exam 2 Questions with Complete Solutions

MGSC 290 Exam 2 Questions with Complete
Solutions

criteria Correct Answ_When you use database functions, you must build a

__________________.




and Correct Answ_When you use database functions and you enter criteria on the same row,

they are treated as ______________ conditions.




3 Correct Answ_How many arguments do all data database functions have?




and Correct Answ_The ______________ function is used to define more than one condition

that must be met for a TRUE result.




or Correct Answ_An _______________ function is much less restrictive than an AND

function.




nest Correct Answ_A ________________ is a function within a function.

, #N/A Correct Answ_A ________________ error values indicates a value or an argument is

missing.




#Values Correct Answ_A ________________ error values indicates an incorrect data type is

used (for example, a label is used instead of a value).




#REF! Correct Answ_A ________________ error values indicates a cell reference is empty,

usually because cells were deleted.




#DIV/10 Correct Answ_A ________________ error values indicates the formula divides by

zero (0) or an empty cell.




index Correct Answ_The _______________ function displays the contents of the cell at the

intersection of an identified column and row.




Match Correct Answ_The _______________ function looks for data that you specify and

returns the relative location of the data that matches the search.