ANAPLAN MASTER ANAPLANNER PRACTICE
QUESTIONS AND DETAILED SOLUTIONS
◉ 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.
QUESTIONS AND DETAILED SOLUTIONS
◉ 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.
