1. Which of the following is not part of a formula:

Database fields
Queries
Operators
Functions

2. All formulas in Crystal Reports start with:

?
Formula name
@
An operator

3. A Parameter Field allows you to:

Prompt a user to enter a formula
Prompt a user to enter parameters for record selection
Prompt a user for the date of a report creation
Query a user on some information

4. The Selection Expert is always:

Case sensitive
In need of lower case input
Necessary for the construction of a formula
Case insensitive

5. The fact that Crystal Reports cannot find any syntax error in a formula indicates:

Your formula will always produce correct results
Your formula contains valid data
Your formula will produce an error message
Your formula can be completely interpreted by Crystal Reports

6. A Crystal formula is:

Not considered a report object
Case sensitive
Limited as to how many functions it can contain
Not case sensitive

7. Which of the following is not true in formulas:

Always put commas when entering numbers
* is the multiplication operator
All text needs to be enclosed in quotes
< > indicates different than

8. Which of the following is not true in formulas:

{ } French or curly brackets surround database tables, formulas and parameter fields
[ ] Square brackets are used to enclose the subscript of an array of values
( ) Parentheses do not indicate the order in which formula elements are evaluated
( ) Parenthesis are placed around the arguments of a function

9. The formula {tblDemographics.strLastName}[1 to 3]indicates:

The use of a function call strLastName
The first three characters of the LastName field from the table Demographics
Add the first three last names of a table
The first three last names of a table

10. The Formula  UpperCase({tblDemographics.strLastName})

Will change upper case text to lower case
Is invalid and will produce a syntax error
Contains a function called UpperCase
Needs more information in order to be completed