6. Intro to Sheets

Question 1

How many sheet types does Workday Adaptive Planning have?

1. 1
2. 3
3. 5

Answer 1

2. 3 (Standard, cube and modelled)

Question 2

You can do version comparison in which of the below sheets?

1. Standard
2. Modelled
3. Cube

Answer 2

1. Standard

Question 3

Assumption sheets are ___-___ sheets. They can be standard, modelled or cube sheets. They are unique because you assign access to specific users rather than relying on access ___.

Answer 3

User-assigned, rules

Question 4

User-assigned sheets have two significant security differences:
1. Any user assigned to an assumption sheet can view data for all levels enabled on the sheet.
2. Assumption sheets do not abide by access rules.
True or false?

Answer 4

True

Question 5

Splits can be added to ___ and ___ sheets.

Answer 5

Standard, Modelled

Question 6

Splits can be added manually and by import into Adaptive Planning. True or false?

Answer 6

True

Question 7

On a sheet, which colour is the text when data has been saved?

1. Blue
2. Black
3. Green
4. Red

Answer 7

2. Black
   (Blue is unsaved data, green is actuals data, red means the formula is correct, but it references another cell with an error).

Question 8

On a sheet, what is the background colour of a cell when it contains rollup data for accounts, time, custom dimensions or splits?

1. White
2. Grey
3. Blue
4. Red

Answer 8

3. Blue
   (White is for editable data, grey is for uneditable data, red is for a formula error or data needs to be entered before saving).

Question 9

When a cell on a sheet has a blue triangle in the lower right-hand corner, it means that cell contains a ___.

Answer 9

Calculation

Question 10

When a cell on a sheet has an orange triangle in the lower right-hand corner, it means that cell contains a ___.

Answer 10

Note

Question 11

You can always add notes to cells on a sheet. True or false?

Answer 11

False (if version or level is locked, or the cell is a header cell, you cannot add notes to these).

Question 12

In standard sheets, you can overwrite cells that contain formulas with a data input value. True or false?

Answer 12

True

Question 13

Selecting the “Access Sheets” permission is a prerequisite for the other sheet permissions. True or false?

Answer 13

True

Question 14

A user’s access to sheets is based on the currently selected ___ and ___. And the granted access to the Level from your assigned ___ ___.

Answer 14

Level, Version, access rules.

Question 15

Which of the below are required in a Modelled sheet?

1. Date
2. Account
3. Levels
4. Time
5. Dimensions

Answer 15

3. Levels

Question 16

A “derived dimension” has values that automatically populate on modeled sheets based on ___ rules.

Answer 16

Mapping

Question 17

Cube sheets support the use of multiple dimensions and attributes. True or false?

Answer 17

True

Question 18

Cube sheets have which functionality?

1. When building a sheet with attributes, you must also include the related element (account, level, or dimension) in the design.
2. Flexible display options are available for the row and column axes.
3. When allowed in the sheet’s design and a user’s permission, you can add new dimension values during data entry.
4. You can restrict relationships between elements to limit the display in data entry.
5. Add splits.

Answer 18

1. When building a sheet with attributes, you must also include the related element (account, level, or dimension) in the design.
2. Flexible display options are available for the row and column axes.
3. When allowed in the sheet’s design and a user’s permission, you can add new dimension values during data entry.
4. You can restrict relationships between elements to limit the display in data entry.

Question 19

You can nest dimensions in a cube sheet. True or false?

Answer 19

True

Question 20

Best practice for standard sheets include;

1. Avoid sheet duplication to prevent data being overwritten.
2. Add account rollups so all child accounts are automatically included in the sheet.
3. Refrain from using too many account splits due to difficulty managing them.
4. Share sheets and apply the same access rules to everyone in the team so everyone has access to the same data.

Answer 20

Best practice for standard sheets include;

1. Avoid sheet duplication to prevent data being overwritten.
2. Add account rollups so all child accounts are automatically included in the sheet.
3. Refrain from using too many account splits due to difficulty managing them.

Question 21

Which sheet type doesn’t allow actuals overlay?

1. Standard
2. Modelled
3. Cube

Answer 21

Modelled

Question 22

Standard sheets allow for account customization. True or false?

Answer 22

True

Question 23

In standard sheets, formulas are only applied to the first split then copied to the remaining splits. True or false?

Answer 23

True

Question 24

Which of the below are required in a Cube sheet?

1. Accounts
2. Time
3. Levels
4. Dimensions
5. Attributes

Answer 24

1. Accounts
2. Time
3. Levels

Question 25

You can use the following cube accounts in cube sheets…

1. Cube Standard Account
2. Cube Modelled Account
3. Cube calculated account
4. Cube Assumption account
5. Cube metric account.

Answer 25

1. Cube Standard Account
2. Cube calculated account
3. Cube Assumption account
4. Cube metric account