Exam 5: Complex Conditional and Retrieval Functions

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

The ________ functions provide added flexibility of multiple data ranges that can be located throughout an Excel spreadsheet.

If letters appear for the column headings,the reference style for Excel is ________.

Data that is manually calculated is known as ________ data.

All of the following statements are TRUE about an Excel database EXCEPT:

Which of the following is NOT an example of a statistical function?

The IF function can employ other logical functions nested within as arguments.

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

The ________ function expands on the AVERAGEIF function by allowing multiple criteria to determine the subset of data.

If numbers appear for the column headings,the reference style for Excel is ________.

All of the following statements are TRUE about conjunctive functions EXCEPT:

Quotes,shown as a(n)________ symbol,not the curly double quotation marks you use when writing papers,let Excel know that the element is a text string and not a numeric value,cell reference,or named range.

A(n)________ aggregate function incorporates calculation and a logical decision.

The correct syntax for the COUNTIF function is: COUNTIF(range,logical_test).

The AVERAGEIFS function expands on the AVERAGEIF function,allowing multiple criteria to determine the subset of data.

Which of the following is an example of a conditional aggregate function?

A nested IF requires one or more IF functions joined by an AND function.

The function =IF(SUM(Trans_Qty)>E20,"Goal Met","Under Goal")is an example of a(n)________ function.

All of the following statements are TRUE about the SUMIF and SUMIFS functions EXCEPT:

Data that is manually calculated and typed into a spreadsheet is called ________ data.