Which task is NOT allowed when spreading data for time periods in Microsoft Excel?
A.
spreading data in a summary time period that includes members and mixed currency types
B.
spreading the value of a summary time period to its base time periods or to the first parent or
first child of the parent time period
C.
spreading values among children and parents proportionally, based on existing distribution
D.
spreading values based on weekly distribution of a quarter, which could be 4-4-5, 5-4-4, or
none
E.
temporarily locking the values of certain cells while spreading data over time periods
Explanation:
Working with a data form page in Excel, you can spread, or distribute, values in
several ways:* Spread the value of a summary time period to its base time periods or to the first parent or
first child of the parent time period
* Spread values among children and parents proportionally, based on existing distribution
* Spread values based on the weekly distribution of a quarter, which could be 4-4-5, 5-4-4,
4-5-4, or None (as set up by the budget administrator)
* Temporarily lock the values of certain cells while spreading data over time periods
Oracle Hyperion Smart View for Office, User’s Guide, Spreading Data for Time Periods