PRACTICE EXAM BANK 2026 TESTED
QUESTIONS WITH EXPLANATIONS
GRADED A+
⩥ ADDMONTHS. Answer: Add a specified number of months to a date.
⩥ ADDYEARS. Answer: Add a specified number of years to a date.
⩥ AGENTS. Answer: Calculates the number of agents required to
service a given number of calls and meet the service level agreement.
⩥ AGENTSB. Answer: Calculates the number of agents required to
handle the busy-period call traffic, given a percentage of calls that might
receive a busy tone.
⩥ AND. Answer: Enter several conditions and the AND function tests to
see if all conditions are met.
⩥ x[ALL:y]. Answer: Flags where all members are populated with a
checkmark (used with Boolean format).
,⩥ x[ANY:y]. Answer: Flags where any members are populated with a
checkmark (used with Boolean format).
⩥ ANSWERTIME. Answer: Calculates the minimum waiting time for
which the service level agreement can be maintained.
⩥ ARRIVALRATE. Answer: Calculates the arrival rate of calls that can
be received while guaranteeing the service level agreement.
⩥ x[AVERAGE:y]. Answer: Calculates the average for a specified range
of values.
⩥ AVGDURATION. Answer: Calculates the average duration of calls
that are answered while guaranteeing the service level agreement.
⩥ AVGWAIT. Answer: Calculates the average waiting time for incoming
calls.
⩥ BLANK. Answer: When the result is text, list, time period, or date
formatted the result can be set to be BLANK.
⩥ CODE. Answer: Returns the code of a list item.
, ⩥ COLLECT. Answer: Collects the data from the original line items
from one or more modules (module must have a line item subset as a
dimension).
⩥ COMPARE. Answer: Compares text values; result is 0 if they match,
1 or -1 if not matched.
⩥ CUMULATE. Answer: Gives the cumulative sum of values from the
first period of the timescale or the cumulative sum across the items in a
named non-time list.
⩥ CURRENTPERIODEND. Answer: The end date of the 'current
period'.
⩥ CURRENTPERIODSTART. Answer: The start date of the 'current
period'.
⩥ CURRENTVERSION. Answer: Returns the value of the current
version as defined under Settings, Versions.
⩥ DATE. Answer: Converts numbers yyyy, mm and dd to a date. Date
format depends on your locale.
⩥ DAY. Answer: Converts a date to a day in number format. Date format
depends on your locale.