Filemaker Pro 9 (106)

Question 1

This set entered on 7-26-14
7.26.14.7

1. FUNCTIONS. What is a FUNCTION?

Answer 1

It is simply a PREDETERMINED FORMULA

Question 2

2. What is a FUNCTION that would find an average in a given field?

Answer 2

Average ( Line Item::Quantity )

Question 3

3. What are the names of the components of the Function:

Average ( Line Item::Quantity )

Answer 3

The word “Average” is the FUNCTION’S NAME. “Line Item::Quantity” is a reference to a RELATED field.

Question 4

4. What is a PARAMETER?

Answer 4

They tell the FUNCTION how to perform its specific calculation. For example, in the function:

Average ( Line Item::Quantity )

the “Line Item::Quantity” is the PARAMETER. This Function has only ONE parameter, but many Functions have two or more.

Question 5

5. How are PARAMETERS presented in a Function?

Answer 5

Parameters are ALWAYS enclosed in PARENTHESIS.

Question 6

6. When there’s more than one Parameter, THEY’RE SEPARATED BY:

Answer 6

A SEMICOLON, as in this Function:

Date ( Month ; Day ; Year )