Exam 5: Complex Conditional and Retrieval Functions

Which of the following is the correct syntax when using the AND function within the IF function?

VLOOKUP and HLOOKUP are two functions used to look up a value and return data that is associated with that value.

The ________ function is the most common logical function.

The ________ function is a database function that is great for setting up a criteria range and calculating the sum based on the filters within that criteria range.

Advantages of using the ________ function instead the SUMIFS function include criteria are changed in cells and there is no need to alter the function.

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

When a(n)________ function is nested in the logical_test argument of an IF function,both logical tests need to be evaluated as "TRUE" for the [value_if_true] argument to be returned.

________ functions allow evaluation of multiple logical tests and enable linking or joining of functions or formulas.

COUNTIF and AVERAGEIF are examples of ________ statistical functions.

The foundation of a logical function is a logical ________ or logical expression.

AND,OR,and NOT are examples of Excel ________ functions.

Outline-code uses the structure of functions but with wording that is for logical understanding.

At least one logical test must be included for the AND function.

If cell B7 contains a value that is greater than 20,and "ORDER" will be displayed when the logical test is TRUE,which of the following contains the correct IF function syntax?

A(n)________ tree allows you to break down potential decisions in a logical,structured format.

All of the following statements are TRUE regarding the INDIRECT function EXCEPT:

The ________ function can change a text string within a cell to a cell reference.

A pair of ________ is needed around each nested function.