Filemaker Pro 9 (104)

Question 1

This set entered on 7-26-14
7.26.14.5

1. What calc would you use to get the volume of a cube?

Answer 1

Length * Width * Height

Question 2

2. What operator works to hook two TEXT values together?

Answer 2

The CONCATENATION OPERATOR (&). It hooks together two text values, as in:

Length & “ Inches”

If the LENGTH FIELD contains 36, the result of this calc is: 36 Inches

Question 3

3. What are the COMPARISON operators?

Answer 3

You often need to compare two values, for example, you may need to add an additional shipping charge of the total weight if an order is more than 20 pounds. ALL COMPARISON OPERATORS RESULT IN A BOOLEAN VALUE.

Question 4

4. What are examples of COMPARISON OPERATORS?

Answer 4

=, >, etc.

Question 5

5. What are the LOGICAL OPERATORS?

Answer 5

They evaluate values and come up with a BOOLEAN (YES/NO) result. Unlike the other operators, most of the LOGICAL OPERATORS are recognizable words.

Question 6

6. What does the AND (Logical Operator) tell you?

Answer 6

it tells you if both values are YES.

Question 7

7. What does this calc evaluate to:
   Length > 3
   and Height > 5 ?

Answer 7

It EVALUATES to Yes if the Length is more than 3 AND the Height is more than 5.

Question 8

8. The OR operator tells you if:

Answer 8

EITHER VALUE IS YES.

Question 9

9. What does this calc evaluate to:
   Length > 3 or
   Height > 5 ?

Answer 9

It evaluates to Yes if the length is more than 3 OR the Height is more than 5.

Question 10

10. The last LOGICAL OPERATOR, Not, stands alone: it works only on one value, NOT TWO. What would this calc evaluate to:
    Not Length > 3 ?

Answer 10

It would evaluate to Yes if the length is NOT more than 3. It simply reverses the BOOLEAN value that comes after it.

Question 11

11. What is the. ˆ (Exponentiation) Logical Operator?

Answer 11

It lets you calculate exponents, as in

Pi * Radius ˆ 2.

This calculation squares the value IN THE RADIUS FIELD.