NEW
Font size
WorksheetsSMALL TEST W3 - KP E
Total questions: 14
Worksheet time: 11mins
What Analyze Menu is used to produce aged summaries of data?
Age
Profile
Summarize
Statistics
Which menu is used to know that data is not in sequenced?
Examine sequence
Look for gaps
Look for duplicate
Stratify
What menu is used to generate digital analysis using the Benford formula?
Benford Analysis
Statistical (Statistics)
Summarize
Stratify
What is the function of Statistical (Profile) Menu?
To provide summary statistics on one or more numeric fields in a table. (total value, absolute value, minimum & maximum value)
To group the numeric field (quantify, unit price, amount of invoice)
To provide summary statistics on date and numeric fields to obtain an overview of the data.
To count the number of records in the current table, or only those that meet a specified test condition. (non numeric fields )
What is the function of Look for Gaps menu?
To detect gaps in the key fields of the active table.
To determine whether data in key fields in the active table are in sequential order.
to sort data into the right sequence
to determine whether data have twins or not
What Analyze Menu is used to produce the classification of A/R based on the due date?
Age
Stratify
Summarize
count record
After we do several check, there will be 2 possibilities of result such as
No error found and validity error detected
Nothing found and something found
Nothing happened and something happened
A finding and not a finding
What are the formula should be used when we want to sort the quantity on hand that exceeds the maximum storage inventory?
QTYOH>MAX CAP
QTYOH<MAX CAP
QTYOH>MIN QTY
QTYOH<MIN QTY
What Analyze Menu is used to sum up the numeric field / record ?
total fields
count record
statistical
stratify
Which of the following are not the steps to start ACL?
Interpreting the data
Accessing the data
Exploring the data
Verifying the data
Which function is used to make sure the equation?
Verify
Record
Field
If
What Analyze Menu is used to calculate records for non numeric fields in the current table, or only those that meet a specified test condition?
Classify
Stratify
Benford Analysis
Statistical (Statistics)
Which menu is not an analyze menu in ACL?
count fields
cross tabulate
age
look for gaps
What are leading digit means?
the first digit in our number
the whole number
the number that will be analyzed
the last digit
