Hb140 - Hyperion Smart View
Please answer the following questions regarding Hyperion Smart View.
- 1.True or False. Using Smart View allows you to view, import, manipulate, distribute and share data in Microsoft Excel, Word, and PowerPoint
- A.
True
- B.
False
- 2.To begin using Smart View, you must first open which Microsoft Office product?
- A.
Word
- B.
Excel
- C.
PowerPoint
- D.
Project
- 3.What "manager" is used to connect your Smart View data sources and manage your connections?
- A.
Data Source Manager
- B.
Connection Source Manager
- C.
Ad hoc Source Manager
- D.
Common Source Manager
- 4.The Options dialog box contains which of the following options:
- A.
Ad-hoc
- B.
Display
- C.
Cell Styles
- D.
All of the above
- 5.To quickly view the source data that is stored at the Base-level member of a dimension's hierarchy, which option in the ad-hoc tab would you choose?
- A.
Supress Rows > Zero
- B.
Mode > Navigate without Data
- C.
Hierarchy > Bottom level
- D.
Member Retention > Remove Unselected Groups
- 6.In the Display tab, the Replacement option enables you to define labels for which of the following:
- A.
Missing Values
- B.
Missing Formulas
- C.
Missing Formatting
- D.
Missing Connections
- 7.When you zoom-in on a dimension member, it is expanded according to the settings in which of the following dialog boxes?
- A.
Business Rules dialog box
- B.
Connections dialog box
- C.
Options dialog box
- D.
Formatting dialog box
- 8.If you want to be able to double-click to zoom-in on a dimension member, you must first do what?
- A.
Click the Zoom button
- B.
Select Mouse Operation on the Ad-Hoc tab in the options dialog box
- C.
Select Double-click from the View menu in the options dialog box
- D.
Any of the above
- 9.A grid must have at least how many dimensions in the rows and columns for pivoting to be possible?
- A.
Only one in either the row or column
- B.
At least two in either the row or column
- C.
None The row or column may be blank
- D.
At least one in both the row and column
- 10.If you want to be able to suppress repeated dimension members listed for each row, you must first do what?
- A.
Hide each row that contains the repeated dimension member
- B.
Select Repeated Members on the Ad-hoc tab in the Options dialog box
- C.
Delete each cell that contains the repeated dimension member
- D.
Select #NoData/Missing Laabel on the Display tab in the Options dialog box
- 11.By default, the Smart Tags feature is turned off. To turn Smart Tags on, which of the following steps needs to be taken?
- A.
Select: View > Smart Tags
- B.
Select: View > Options > Smart Tags
- C.
Select: Tools > AutoCorrect Options
- D.
None of the above
- 12.In order to use Smart Tags, the document must be connected to what?
- A.
A Point of View
- B.
A Data Source
- C.
A Workspace
- D.
A Worksheet
- 13.True or False. Smart View enables you to copy data points from Excel and paste them into Word or PowerPoint documents, creating linked views (dynamic data points) between applications.
- A.
True
- B.
False
- 14.To retrieve the Excel queries for a data point that was copied into a Word or PowerPoint document, which of the following steps needs to be taken:
- A.
Select: View > Visualize in Excel
- B.
Select: Link View > Visualize in Excel
- C.
Select: Hyperion > Link View > Visualize in Excel
- D.
Select: Options > Visualize in Excel
- 15.What do you use to change the POV once the Excel data points are copied into word or PowerPoint?
- A.
Options dialog box
- B.
POV Manager
- C.
Right-click menu
- D.
Query designer
Questions: 10 | Attempts: 10033 | Last updated: Apr 27, 2015
-
Sample QuestionWho is the Speaker of the House?
Questions: 10 | Attempts: 9515 | Last updated: Jul 20, 2020
-
Sample QuestionAre you aged 0-9?
Questions: 12 | Attempts: 4317 | Last updated: Oct 10, 2018
-
Sample Question999+999=?
Back to top