DataConsulting’s Coffee Corner

2013-04-01

DataConsulting’s Coffee Corner

For this month’s coffee corner, I thought it would be good to actually know where we are with your ACL skills. Are you really an expert at ACL? Or maybe you think you’re at a beginner level. You may actually be a lot better than you think. Try this little quiz and see how well you do.

Please do not cheat as this can identify any areas for improvements. Unless of course you’re an expert. Can you finish this before your coffee?

Question 1
The Cross-tabulate command is a logical extension of the __________ command

A. StatisticsB. StratifyC. ClassifyD. Sampling

Question 2
Which of the following statements is not a reason to use the Stratify command?

A. To identify anomalies in the dataB. To summarise dataC. To determine date rangesD. To determine materiality

Question 3
Which statement is not true about the Age command?

A. The table must be sorted before running the Age commandB. The default aging periods can be customisedC. The Age command is commonly used to produce an aging summaryD. Results of the Age command can be graphed

Question 4
Which statement is not true about the Sort command?

A. As a general rule, free disk space of at least 2.5 times the file size of the table to be sorted should be availableB. The Sort command works with fixed files, but not variable length filesC. Any type of field can be sorted D. Tables can be sorted in ascending or descending order

Question 5
Which statement is not true about the Index command?

A. An indexed table takes up significantly more space than the equivalent sorted tableB. The Index command is an alternative to the Sort commandC. Any type of field can be indexed D. Tables can be indexed in ascending or descending order

Question 6
Which of the following statements is not true about the Verify command?

A. Verify identifies any possible data validity errors B. Verify ensures that all data conforms to the field C. Verify fixes errors in the table D. You can choose to have ACL verify data automatically

Question 7
Which statement is not true about the Join command?

A. Join can be used to determine if two tables are identical by joining on record numberB. The Join command has four output optionsC. Join permits the inclusion of additional detail in reports and analysis D. Tables are joined based on one or more common key fields

Question 8
In order to append two tables together, they must have identical table layouts.

A. TrueB. False

Question 9
Which statement is not true about the Export command?

A. It is possible to select the entire record for exportB. It can be used to create a mail merge documentC. It can convert data from one package to another D. It can export to a presentation graphics package

Question 10
Which statement is not true about the Export command?

A. They are used to logically separate auditsB. They contain physical dataC. They act as a repository for tables and views D. Both a and c are true

Submit