FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Complex Conditional and Retrieval Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) The INDIRECT function can change a text string within a cell to a cell reference.
B) The INDIRECT function has three arguments.
C) The INDIRECT function's first argument is usually a cell reference or a text string.
D) The cell reference in the INDIRECT function reroutes to a new reference.

E) None of the above
F) A) and C)

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

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

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

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

A pair of ________ is needed around each nested function.

COUNTIF and AVERAGEIF are examples of ________ statistical functions.

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.

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

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.

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

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

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

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

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

Match the following terms to their description.

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

The ________ function is the most common logical function.

Match the following terms to their description.

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?