Hb140 - Hyperion Smart View - Quiz, Trivia & Questions

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Amorgan3

Amorgan3

Community Contributor

Quizzes Created: 3 | Total Attempts: 538

Questions: 15 | Attempts: 135 | Updated: Mar 22, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Please answer the following questions regarding Hyperion Smart View.

Questions and Answers

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
Correct Answer
A. True

Explanation
HB140, Task 1

Rate this question:
2.

To begin using Smart View, you must first open which Microsoft Office product?
- A.
  
  Word
- B.
  
  Excel
- C.
  
  PowerPoint
- D.
  
  Project
Correct Answer
B. Excel

Explanation
HB140, Task 1

Rate this question:
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
Correct Answer
A. Data Source Manager

Explanation
HB140, Task 1

Rate this question:
4.

The Options dialog box contains which of the following options:
- A.
  
  Ad-hoc
- B.
  
  Display
- C.
  
  Cell Styles
- D.
  
  All of the above
Correct Answer
D. All of the above

Explanation
HB140, Task 2

Rate this question:
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
Correct Answer
C. Hierarchy > Bottom level

Explanation
HB140, Task 2

Rate this question:
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
Correct Answer
A. Missing Values

Explanation
HB140, Task 2

Rate this question:
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
Correct Answer
C. Options dialog box

Explanation
HB140, Task 3

Rate this question:
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
Correct Answer
B. Select Mouse Operation on the Ad-Hoc tab in the options dialog box

Explanation
HB140, Task 3

Rate this question:
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
Correct Answer
D. At least one in both the row and column

Explanation
HB140, Task 3

Rate this question:
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
Correct Answer
B. Select Repeated Members on the Ad-hoc tab in the Options dialog box

Explanation
HB140, Task 3

Rate this question:
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
Correct Answer
C. Select: Tools > AutoCorrect Options

Explanation
HB140, Task 4

Rate this question:
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
Correct Answer
B. A Data Source

Explanation
HB140, Task 4

Rate this question:
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
Correct Answer
A. True

Explanation
HB140, Task 5

Rate this question:
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
Correct Answer
D. Select: Options > Visualize in Excel

Explanation
HB140, Task 5

Rate this question:
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
Correct Answer
B. POV Manager

Explanation
HB140, Task 5

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 22, 2023

Quiz Edited by
ProProfs Editorial Team
Mar 17, 2010

Quiz Created by
Amorgan3

Hb140 - Hyperion Smart View

True or False. Using Smart View allows you to view, import, manipulate, distribute and share data in Microsoft Excel, Word, and PowerPoint

To begin using Smart View, you must first open which Microsoft Office product?

What "manager" is used to connect your Smart View data sources and manage your connections?

The Options dialog box contains which of the following options:

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?

In the Display tab, the Replacement option enables you to define labels for which of the following:

When you zoom-in on a dimension member, it is expanded according to the settings in which of the following dialog boxes?

If you want to be able to double-click to zoom-in on a dimension member, you must first do what?

A grid must have at least how many dimensions in the rows and columns for pivoting to be possible?

If you want to be able to suppress repeated dimension members listed for each row, you must first do what?

By default, the Smart Tags feature is turned off. To turn Smart Tags on, which of the following steps needs to be taken?

In order to use Smart Tags, the document must be connected to what?

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.

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:

What do you use to change the POV once the Excel data points are copied into word or PowerPoint?