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
JavaScript is disabled. Get Netscape 3.0 or turn it on!
1. Which of the following is not part of a formula:
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