IBM Planning Analytics Workspace V2.0.0 Explore Data Home 17/30 testing

Which of the following statements are TRUE about member calculations? Select one or more: A. The calculation options available to you depend on the number of members you select B. The members included in the calculation vary depending on which members are showing in the view C. You can change the order of members when calculating percentages D. You can select three or more members to perform a Rank calculation to rank the values in order

A. The calculation options available to you depend on the number of members you select C. You can change the order of members when calculating percentages Link: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=c-member-calculations

What can you do to a single data value in a cube view? Select one: A. Add it to the sheet as a separate widget B. Change the data format, such as adding a percent symbol C. Hide it D. Change the font

A. Add it to the sheet as a separate widget

What is a selector? Select one: A. An icon you can add to a sheet that lets users change the visualization B. A control that lets users input data, such as by choosing a date on a calendar C. A widget that lets you filter data appearing in one or more widgets D. A property that lets you specify the target for a navigation button

A. An icon you can add to a sheet that lets users change the visualization

Which of the following actions can you take when working with a websheet? Select one or more: A. Export websheets to .PDF files B. Transfer the data set to IBM Watson Analytics C. Enter data in cells to which you have Write access D. Use sandboxes E. Change the visualization to a chart or map

A. Export websheets to .PDF files D. Use sandboxes

Which of the following statements is TRUE about entering data into a cube view in IBM Planning Analytics Workspace? Select one: A. In a row with a variety of values, a Proportional Spread distributes a specified value equally across the cells B. You can enter data into green cells provided they are showing leaf level data C. You can populate numeric cells by entering calculations such as 120*350 D. All data entry commands, such as R>10, are case sensitive

A. In a row with a variety of values, a Proportional Spread distributes a specified value equally across the cells

A time dimension appears on columns starting with Year followed by all 12 months. On rows, Units Sold is populated for all 12 months and is showing different values for each month. You want to update the Units Sold to show 24000 units being sold equally divided across 12 months. Which of the following shortcuts could you enter to achieve this? Select one or more: A. S>24000 in the first month B. R>2000 in the first month C. 24000 in the Year D. SL>2000:24000 in the first month

A. S>24000 in the first month B. R>2000 in the first month D. SL>2000:24000 in the first month

When working with a websheet, how do you send all of your changed values to the server and recalculate the data? Select one: A. Press F10 B. Click Refresh C. Click Recreate Book D. Press F7

B. Click Refresh

A view contains 10 products on columns but two products are not needed for this analysis. How can an analyst eliminate these two members from the view? Select one or more: A. Change the font color to match the background color B. Delete them C. Remove them from the current set D. Hide them E. Move them to the bench

B. Delete them C. Remove them from the current set D. Hide them

In a book containing scorecarding data, a metric called "Expenses" is displaying a Trend icon of a red arrow pointing down. What does this mean? Select one: A. Expenses went down this period B. Expenses was further from its target this period than last period C. Expenses was higher this period than last period D. Expenses missed its target this period

B. Expenses was further from its target this period than last period

Which of the following visualization types lets you create calculations? Select one: A. Heat map B. Exploration C. Line and column D. Stacked column

B. Exploration

Which of the following statements is TRUE about holding cells while performing data entry in IBM Planning Analytics Workspace? Select one: A. Held cells appear with blue font B. Held cells are not affected by data spreading C. Held cells are not affected by direct data entry D. Administrator rights are required to hold a cell

B. Held cells are not affected by data spreading Link: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=websheet-excluding-cells-from-data-spreading#ExcludingCellsfromDataSpreading_N100451

A view shows a Time dimension on columns. It shows Total Year, which is expanded to show Q1, Q2, Q3 and Q4, and Q1 is expanded to show Jan, Feb, and Mar. If you create a summary calculation on columns to show Minimum values, which members are included in the calculation? Select one: A. Jan, Feb, Mar B. Jan, Feb, Mar, Q1, Q2, Q3, Q4 C. Total Year, Q1, Q2, Q3, Q4, Jan, Feb, Mar D. Jan, Feb, Mar, Q2, Q3, Q4

B. Jan, Feb, Mar, Q1, Q2, Q3, Q4

A view shows a Geography dimension on rows. This includes several regions expanded to show the countries they contain, including Germany rolling up to Europe. If you type "Select germny" as a snap command, and assuming no other members or sets contain a similar string of characters, what will happen to the view? Select one: A. Nothing changes because Germany is not spelled correctly B. Only Germany appears on rows C. All members remain but Germany appears highlighted D. Only Europe and its countries appear and Germany appears highlighted

B. Only Germany appears on rows

How can you add an image to a book? Select one: A. Drag an image from a folder on your computer or LAN B. Refer to an image on the web using its URL C. Navigate to and select a file from your computer D. Copy and paste an image from another web page

B. Refer to an image on the web using its URL

You have a book containing a view. Which of the following components can you hide? Select one or more: A. The overview area B. Sheet names C. Row and column headers D. A single data value

B. Sheet names D. A single data value

Which of the following statements are TRUE about websheets? Select one or more: A. They can use different fonts B. They can let users move dimensions between rows, columns and the context area C. They are found in the Cubes folder of a server by expanding the related cube D. They can be added to books even when not in Edit mode E. They can use Microsoft Excel conditional formatting

B. They can let users move dimensions between rows, columns and the context area E. They can use Microsoft Excel conditional formatting

How do you change the appearance of a view, such as to remove grid lines or change the background color? Select one: A. Use the Navigation pane B. Use the Properties window C. Use the view's toolbar D. Use the Menu icon

B. Use the Properties window

Which of the following statements is TRUE about Snap commands? Select one: A. Snap commands are case sensitive B. You can type snap commands by using abbreviations such as 'u' for unhide C. Snap commands require proper spelling of member names D. You cannot undo snap commands by clicking the Undo icon

B. You can type snap commands by using abbreviations such as 'u' for unhide https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=wibv-snap-commands

Which of the following statements is TRUE about sharing content? Select one: A. Security cannot be applied to shared books or views B. You can share folders C. A book or view must be open in order to share it D. Sharing a book automatically grants the recipient access to the TM1 server to see the data

C. A book or view must be open in order to share it

A book must be in Edit Mode in order to perform which of the following tasks? Select one or more: A. Change data values B. Choose a different member from a context filter C. Add a new sheet to the book D. Move and resize widgets E. Drill down on a consolidated member

C. Add a new sheet to the book D. Move and resize widgets https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=books-edit-mode

Which of the following statements is TRUE about synchronizing objects? Select one: A. You can synchronize objects to show data for the same sandbox B. You can set synchronization even when not in Edit mode C. By default, objects are synchronized at the book level D. You cannot synchronize a view with a websheet

C. By default, objects are synchronized at the book level

Which of the following actions can a navigation button in a book perform? Select one: A. Refresh data in a cube view B. Open a PDF on a LAN location C. Go to a URL location D. Open a spreadsheet saved locally

C. Go to a URL location Link:https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=wibv-buttons

An exploration is showing time on columns including Total Year, all four quarters, and all twelve months. How can an analyst quickly show data for just the quarters and Total Year? Select one: A. Show totals as trailing B. Summarize all C. Sort hierarchical D. Expand to level

C. Sort hierarchical

Why would an analyst choose "book from template" when creating a book? Select one: A. To share the book with other users B. To alter the appearance of the book such as using different background colors C. To organize objects using a specific layout D. To commit data back to the server

C. To organize objects using a specific layout

An exploration is showing time on columns including Total Year and all four quarters. What will appear on columns if you drill down on Q1 (assuming Q1 contains the months January, February, and March)? Select one: A. Total Year, all quarters, and all months B. Q1, January, February, and March C. Total Year, Q1, January, February, and March D. January, February, and March

C. Total Year, Q1, January, February, and March

Which of the following statements is TRUE about transferring data from IBM Planning Analytics Workspace to IBM Watson Analytics? Select one: A. All transferred data appears in a public folder B. When transferring data, you can choose a name for the transfer C. You can transfer data from a websheet D. If you overwrite an existing data set, all previous analyses are lost

C. You can transfer data from a websheet

Which of the following actions can an analyst perform to change the way data appears in the cells of a view? Select one: A. Apply borders, such as to apply a double bottom border to totals B. Change the format, such as to show a percent sign or currency symbol C. Make consolidated values appear bold D. Show data as a percentage of the totals on rows, columns, or the grand total

D. Show data as a percentage of the totals on rows, columns, or the grand total Link:https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=viewer-display-cell-values-as-percentages

Which of the following statements is TRUE about using the Intent bar? Select one: A. The search is case sensitive B. It lets users use commands to perform actions such as hide or highlight specific data C. It requires users to use an SQL-like syntax such as "Year=2018" to find the desired data D. If a cube or view name matching your search criteria is not found, a view will be created for you

D. If a cube or view name matching your search criteria is not found, a view will be created for you

You are working in a sandbox and a value appears blue. What does the blue font indicate? Select one: A. It has not yet been recalculated B. It is a consolidated value C. It cannot be edited D. It is different than the base data

D. It is different than the base data https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=view-edit-data

Which objects are found in your collection and how do they get there? Select one: A. Books, views and folders that are saved privately automatically appear here B. Recently used objects such as views or widgets automatically appear here C. Bookmarks to folders, cubes, and sets appear here when you specifically add them D. Objects such as views or widgets appear here when you specifically add them

D. Objects such as views or widgets appear here when you specifically add them