Exam 5: Complex Conditional and Retrieval Functions

If the VLOOKUP range_lookup argument has the ________ value entered,an exact match with the lookup_value argument is required.

The IF function has ________ arguments.

Using ________ makes creating formulas easier because you do not need to worry about adding absolute and mixed cell references.

The ________ function is appropriate when there are many options that do fit the desired criteria and only one option that does not fit the criteria.

The correct syntax for the SUMIF function is ________.

In the process of checking the values and eliminating errors,it is best to start with formulas that are simple and do not reference other cells that have formulas.

The syntax for the IFERROR function is =IFERROR(value,value_if_true)

Which of the following is NOT a database function?

A nested IF decreases the logical outcomes that can be expressed.

A(n)________ IF increases the logical outcomes that can be expressed.

The ________ function looks for a value within a range and returns the position of that value within the range.

A(n)________ advantage is the strategic advantage that a business has over its competition.

The ________ function is a useful tool for detecting an error and displaying something more user friendly than an error message.

If a value is in the third row and fourth column,the cell reference would be R3C4.

All of the following statements are TRUE about the VLOOKUP function EXCEPT:

The MATCH and INDEX functions can be used to overcome the data range limitations of the VLOOKUP and HLOOKUP functions.

The ________ argument of the COUNTIF function lists the cells that will be counted.

The NEVER function allows creation of logical statements in which it creates the opposite or reverse result.

The ________ function is used when the lookup_value argument checks the top row of the table_array.

The first argument of the AVERAGEIFS function is ________.