Dashboard Multiple Choice Questions

[Former Member]

Hai all

Please answer for the below Mention Questions.

Which are the benefits of using Xcelsius?

Perform what-if analysis.

Represent tabular data graphically.

Identify problems in source data or business assumptions.

Alert your organization to potential issues and opportunities.

Which element of the Xcelsius interface is used to select and hide components on the canvas?

Components Browser

Object Browser

Property Sheets

Which type of component has drill-down functionality?

Sliders

Gauges

Progress Bars

Charts

How often is the data in the embedded Excel workbook updated?

Each time a new cell is selected

Never

At customized intervals

At fixed intervals

According to best practices, why should you color code cells in your embedded Excel workbook?

In order to conform with the Spread Sheet Standards Association's style guide.

It makes it easier to find the cells that you want to use in your models.

Xcelsius automatically selects cells with coloring and converts them into components.

What is the difference between embedded data and connected data models?

Embedded models use data from file servers; connected models use data from web sites

Embedded models use data from an embedded Excel workbook; connected models use a data connection to an external data source

No difference

How do you create a legend in a chart?

Bind Category axis labels to the cell with the Series name in the General property sheet

Bind the Legend to the cell with the Series name in the General property sheet

Bind the entire data range to the legend in the Appearance property sheet

Select Create Legend from the General property sheet.

Select Enable Legend from the Appearance property sheet

When binding a chart to non-contiguous data, which binding method should be used?

Data - By Series

Data - By Range

Category Labels

What is the maximum number of cells to which a single value component can be bound in the embedded Excel workbook?

0

1

2

3

What happens when you bind a single value component to a cell with a formula?

The single value component behaves like any other component.

You must change the input options on a Property sheet to make it work.

The single value component behaves like any other component, but performance of the visualization is degraded.

Nothing. You cannot bind a single value component to a cell with a formula.

11. If you want to set a maximum value of 50% for a single value component that references a percentage in the source file, what would you do?

Your Ans. Sol- ution Points Please select the correct answer.

Bind the Common tab of the Behavior property sheet to the value 0.05.

Bind the Common tab of the Behavior property sheet to the value 50.

Set a scale limit of 50% on the General property sheet.

Set a scale limit of 0.5 on the General property sheet.

Set a scale limit of 0.5 on the Behavior property sheet.

Explanation:

12. What happens if you set up alerts for a multi-series chart?

Your Ans. Sol- ution Points Please select the correct answer.

The alerts must be set up for each series.

The same alerts apply for all series.

The alert setup is automatically determined by the thresholds for the series.

Nothing. You cannot set up alerts for a multi-series chart.

Explanation:

13. As a best practice when you start designing a dashboard you sketch flow diagrams, mind maps, or simple lists. What best practice questions should you ask yourself from the user's perspective? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

Who will use the dashboard?

What tables do they need?

What decisions or actions will they drive from the dashboard?

What database(s) will supply the needed data?

What information will they need to drive action and decisions?

Explanation:

14. Which of the following are valid methods for bringing data from Excel into an Xcelsius model? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

Copy from Excel and paste into the embedded Excel workbook in Xcelsius

Import external Excel workbook into embedded Excel workbook

Enter data manually into the embedded Excel workbook in Xcelsius

Create a sum formula that points to an Excel workbook outside of Xcelsius

Explanation:

15. Which Property sheet would you use to indicate performance using color coding?

Your Ans. Sol- ution Points Please select the correct answer.

General

Drill Down

Behavior

Alerts

Appearance

Explanation:

16. When a selector is used with data insertion, which insertion type is valid?

Your Ans. Sol- ution Points Please select the correct answer.

Filtered Rows

Filtered Colums

Filtered Cells

Explanation:

17. What formats can you use for embedded images that you import into the fish-eye picture menu or the sliding picture menu? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

BMP

PNG

WMV

SWF

Explanation:

18. How do you create interactive links in your map that will display a chart?

Your Ans. Sol- ution Points Please select the correct answer.

Include a row or column in the embedded Excel workbook that references the appropriate abbreviations or names for the areas.

Define the areas in the Behavior tab of the Properties window.

Set up a series for each geographical area.

Nothing, Maps are not interactive. You must set up hotspots to link to data in other charts.

Explanation:

19. For which settings do you need to include the specific map areas in alphabetic order along with the data? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

Source data

Data Insertion

Display data

Alerts target

Explanation:

20. Which data insertion option passes the location of the data in the data range to the selector?

Your Ans. Sol- ution Points Please select the correct answer.

Value

Position

Row

Status

Explanation:

21. How do you link your data to specific areas in a map?

Your Ans. Sol- ution Points Please select the correct answer.

Include a row or column in the embedded Excel workbook that references the appropriate abbreviations or names for the areas.

Define the areas in the Behavior tab of the Properties window.

Set up a series for each geographical area.

Nothing. Maps are not interactive; you must set up hotspots to link to data in other charts.

Explanation:

22. Which component offers the drill-down feature?

Your Ans. Sol- ution Points Please select the correct answer.

Single Value Components

Selectors

Charts

Maps

Explanation:

23. When using dynamic visibility, which is true? (Select all that apply)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

A component is visible only if the value of the Status field matches the value of the Key field.

Each component that will have a visibility change associated with the same event should be bound to the same status cell, but each component should be bound to a unique key.

An Excel formula is required to determine whether components are visible.

Each component that will have a visibility change associated with the same event should be bound to a unique status cell, but each component should be bound to the same key.

Explanation:

24. What components and functions can be used to toggle dynamic visibility? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

A cell contained within the destination range specified in a selector

A VLOOKUP formula within a cell

A single value component

A range contained within a destination range specified in a selector

Explanation:

25. On which property sheet can Dynamic Visibility be configured?

Your Ans. Sol- ution Points Please select the correct answer.

Alerts

Appearance

Behavior

General

Explanation:

26. When testing your model you discover that the dynamic formatting in your Excel workbook does not appear in your published model. What should you do?

Your Ans. Sol- ution Points Please select the correct answer.

Setup dynamic visibility in your model.

Remove dynamic formatting from your Excel workbook.

Make sure that the text object is not hidden in the Object Browser.

Reformat your Excel workbook cells to avoid using bold.

Explanation:

27. Which are the correct steps for setting up dynamic visibility?

Your Ans. Sol- ution Points Please select the correct answer.

From the Behavior property sheet, bind Dynamic Visibility Status to a destination range and bind Dynamic Visibility Key to a label.

From the Behavior property sheet, bind Dynamic Visibility Status to a label and bind Dynamic Visibility Key to a destination range.

In the Object Browser, place a checkmark under the Eye icon to hide the component.

From the General property sheet, bind Dynamic Visibility Status to a destination range and bind Dynamic Visibility Key to a label.

From the General property sheet, bind Dynamic Visibility Status to a label and bind Dynamic Visibility Key to a destination range.

Explanation:

28. Alerts can be enabled for the following components: (Select all that apply)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

Selectors

Containers

Single Value components

Calendars

Explanation:

29. Which of the following are valid publishing formats for Xcelsius visualizations? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

SWF embedded in PowerPoint slide

SWF embedded in Word document

SWF embedded in ZIP compressed file

SWF formatted for BusinessObjects Enterprise

Explanation:

30. Management has asked to see a snapshot of the data in the Excel workbook embedded in a published visualization. Of the methods below, which will produce a spreadsheet that contains a snapshot of the data? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

Switch to Preview mode. From the File menu select Snapshot > Current Excel Data.

Switch to Design mode. From the Data menu, select Export Current Excel Data.

Highlight and copy the embedded Excel workbook from the Xcelsius interface and paste into new workbook in Excel.

Switch to Design mode. From the File menu, select Export Settings > Current Excel Data.

Explanation:

31. Which of the following methods will produce an .XLS file that contains a copy of the data in the .XLF embedded Excel workbook? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

From the Data menu, select Export.

From the File menu, select Snapshot > current Excel data.

From the File menu, select Preview > File > Snapshot > current Excel.

From the File menu, select Export > Word.

Explanation:

32. Which files created in SAP BusinessObjects Xcelsius Enterprise 2008 can be sent to BusinessObjects Enterprise? (Select all that apply.)

Your Ans. Sol- ution Points More than one answer is correct. Please choose the correct answers.

XLS (Excel)

.SWF (Xcelsius Flash)

.XLF (Xcelsius design)

.XML (Extensible Markup)

.HTML (Hypertext Markup)

[Former Member]

Answers for 2 question

Object Browser

3 Ans: Charts

5 Ans:It makes it easier to find the cells that you want to use in your models.

[Former Member]

Hi guys by this week ill tell u briefly

[Former Member]

hi naveen,

can you send answers to me..

thanks in advance

pk

[xjhacking]

Please review your message before you post it. How can you expect someone to go through it if you just copy-past a large piece of text without any formatting?

Xavier

[Former Member]

1.Which are the benefits of using Xcelsius?

2.Which element of the Xcelsius interface is used to select and hide components on the canvas?

3. Which type of component has drill-down functionality?

4. How often is the data in the embedded Excel workbook updated?

5. According to best practices, why should you color code cells in your embedded Excel workbook?

6. What is the difference between embedded data and connected data models?

7. How do you create a legend in a chart?

7. When binding a chart to non-contiguous data, which binding method should be used?

8. What is the maximum number of cells to which a single value component can be bound in the embedded Excel workbook?

9. What happens when you bind a single value component to a cell with a formula?

11. If you want to set a maximum value of 50% for a single value component that references a percentage in the source file, what would you do?

10. What happens if you set up alerts for a multi-series chart?

11. As a best practice when you start designing a dashboard you sketch flow diagrams, mind maps, or simple lists. What best practice questions should you ask yourself

from the user's perspective? (Select all that apply.)

12. Which of the following are valid methods for bringing data from Excel into an Xcelsius model? (Select all that apply.)

13. Which Property sheet would you use to indicate performance using color coding?

14. When a selector is used with data insertion, which insertion type is valid?

15. What formats can you use for embedded images that you import into the fish-eye picture menu or the sliding picture menu? (Select all that apply.)

16. How do you create interactive links in your map that will display a chart?

19. For which settings do you need to include the specific map areas in alphabetic order along with the data? (Select all that apply.)

17. Which data insertion option passes the location of the data in the data range to the selector?

18. How do you link your data to specific areas in a map?

22. Which component offers the drill-down feature?

19. When using dynamic visibility, which is true? (Select all that apply)

20. What components and functions can be used to toggle dynamic visibility? (Select all that apply.)

21. On which property sheet can Dynamic Visibility be configured?

22. When testing your model you discover that the dynamic formatting in your Excel workbook does not appear in your published model. What should you do?

27. Which are the correct steps for setting up dynamic visibility?

28. Alerts can be enabled for the following components: (Select all that apply)

23. Which of the following are valid publishing formats for Xcelsius visualizations? (Select all that apply.)

24. Management has asked to see a snapshot of the data in the Excel workbook embedded in a published visualization. Of the methods below, which will produce a

spreadsheet that contains a snapshot of the data? (Select all that apply.)

25. Which of the following methods will produce an .XLS file that contains a copy of the data in the .XLF embedded Excel workbook? (Select all that apply.)