cable.gif (2986 bytes)

Answer correctly 7 of the questions below to advance to the next level
Find the correct answer by positioning your mouse over the underlined Answer hot spot

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

Database fields
Queries
Operators
Functions

2. All formulas in Crystal Reports start with: Answer 2

?
Formula name
@
An operator

3. A Parameter Field allows you to: Answer 3

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: Answer 4

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: Answer 5

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: Answer 6

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: Answer 7

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: Answer 8

{ } 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: Answer 9

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}) Answer 10

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

 

 

Last modified: December 09, 2004
Yannis Grammatis