SAP BO Xcelsius Quiz

SAP BO Xcelsius Quiz

 



SAP BO Xcelsius Quiz contain set of 60 MCQ questions for SAP BO Xcelsius MCQ which will help you to clear beginner level quiz.



 
1) Can we view Crystal Xcelsius Design Files (XLF) in Infoview

  1. No
  2. Yes
  3. None

Answer : A

 
 
2) What is the use of AFD? Where it can be stored?

  1. used to create dashboards. It can be stored in repository, corporate or personal.
  2. used to create Reports and It can be stored in repository, corporate or personal.
  3. used to create universe and It can be stored in repository, corporate or personal.
  4. Opt B & C

Answer : A

 
 
3) Why do we need metrics and sets?

  1. Metrics are used for analysis and Sets are used for grouping.
  2. Metrics are used to hold numeric values and Sets used for aggregation
  3. Metrics are used in Aggregate awareness and Sets are used for grouping
  4. Opt A & B

Answer : A

 
 
4) BO Xcelsius is a tool for

  1. Query and Analysis
  2. Data Visualization
  3. Data Mining
  4. A & C

Answer : B

 
 
5) Which one them cannot be scheduled

  1. Crystal Report
  2. Desktop Intelligence Reports
  3. Web Intelligence report
  4. Xcelsius

Answer : D

 
 
6) XCelsius is a ___________________ tool

  1. BI
  2. Analytical
  3. Visualization
  4. NONE

Answer : C

 
 
7) Which of the following chart types can be used to emphasize a trend line?
1) Area Chart 2) Line Chart 3) Bullet Chart 4) Column Chart
 

  1. Both 1 & 2
  2. Area Chart
  3. Bullet Chart
  4. Line Chart

Answer : A

 
 
8) How many axis a Bubble Chart has?

  1. Two
  2. Three
  3. One
  4. None

Answer : B

 
 
9) Which chart is best suited if one has to display a range of values and a trend line for these values?

  1. Line Chart
  2. Scatter Plot
  3. Combination Chart
  4. Area Chart

Answer : C

 
 
10) Consider the following scenario:
Volume of sales is available across region and historical Profit data is available over a period of 5 years.
Which chart can best display this combination of data together?
 

  1. Area Chart
  2. XY Chart
  3. Line Chart
  4. Combination Chart

Answer : D

 
 
11) OHLC is otherwise known as ____________

  1. Bubble Chart
  2. Candlestick Chart
  3. Radar Chart
  4. Sparkline

Answer : C

 
 
12) Sparkline chart is good at displaying ____________ data

  1. One dimesional
  2. Two dimensional
  3. Multi dimensional
  4. None

Answer : A

 
 
13) Which chart is best suited to compare two sets of data along with hierarchical data?

  1. Bubble Chart
  2. Treemap
  3. XY Chart
  4. Waterfall Chart

Answer : B

 
 
14) If there is a sequential series of positive and negative values and to represent these values affects the intital baseline data. Which chart would you suggest?

  1. Sparkline
  2. Waterfall
  3. XY Chart
  4. Radar

Answer : B

 
 
15) Is it possible to add backgrounds or borders to a Canvas Container?

  1. TRUE
  2. FALSE

Answer : B

 
 
16) Which of the following is not a Container Component?

  1. Tab Set
  2. Canvas
  3. Image
  4. Canvas

Answer : C

 
 
17) Which of the following components are Selector Components?

  1. Accordion Menu 2. Toggle Button 3. Fisheye picture menu 4. Ticker

 

  1. 1& 2
  2. 2 & 4
  3. All of the above
  4. None of the above

Answer : C

 
 
18) Can Icon be used as a selector or display component?

  1. TRUE
  2. FALSE

Answer : A

 
 
19) Which selector is best suited to animate data for the users?

  1. Play Selector
  2. Fisheye Picture Menu
  3. Sliding Picture Menu
  4. None

Answer : A

 
 
20) Which of the following statement is correct regarding Single value components?

  1. A) useful for displaying or inserting data to an individual cell.
  2. B) useful for displaying or inserting an invidual row or column.

Answer : A

 
 
21) Visual alerts can be displayed using:

  1. Fisheye picture Menu
  2. Scorecard
  3. Hierarchical Table
  4. None

Answer : B

 
 
22) Which component scrolls the text within the model?

  1. Sliding Picture Menu
  2. Ticker
  3. Fisheye Picture menu
  4. Play Selector

Answer : B

 
 
23) Minimum and Maximum limit cannot be set for input components.

  1. TRUE
  2. FALSE

Answer : B

 
 
24) Spinner is an _____________ component.

  1. Input
  2. Output
  3. Selector
  4. Canvas

Answer : A

 
 
25) Which of the following is not a Text Component?

  1. Input Text
  2. Input Text Area
  3. Label
  4. Text Box

Answer : D

 
 
26) For which component we can’t set up alerts from the following:

  1. Spinner
  2. Dial
  3. Gauge
  4. Value

Answer : D

 
 
27) How does Trend Analyzer work?

  1. A) inserts data point for the trendline in the spreadsheet which can be then be added to the model.
  2. B) automatically inserts the trend line to the model.
  3. C) creates a trend line and forecast values automatically when applied.
  4. D) None

Answer : A

 
 
28) Image component is an ____________

  1. Input Component
  2. OutputComponent
  3. Art & Background Component
  4. CanvasComponent

Answer : C

 
 
29) Alert Thresholds can be set for

  1. Specify Value
  2. Listof Values
  3. Range of Values
  4. All of the above

Answer : D

 
 
30) Performance of the model is affected in case of

  1. Embedded Files
  2. Reference Files

Answer : A

 
 
31) In case of embedded files, the external file is loaded even if it is hidden through dynamic visibility.

  1. TRUE
  2. FALSE

Answer : A

 
 
32) When image is imported in to the normal Image components: Which of the below statement is valid?

  1. A) Xcelsius stores its own local copy of the image file internally
  2. B) Xcelsius references the actual image file whenever needed.

Answer : A

 
 
33) If a model is connected with external sources then which of these option should be enabled or done inorder to run the model in a web server?

  1. Host application file must be made trusted
  2. Cross-domain policy file must be set up.

Answer : B

 
 
34) Which statement is correct regarding deleting a componentfrom a group?

  1. A) To delete a component from a group, the components should be ungrouped first.
  2. B) Ungrouping is not necessary to delete a component

Answer : B

 
 
35) Alerts are not available for ___________

  1. Bubble Chart
  2. Area Chart
  3. Bar Chart
  4. Maps

Answer : B

 
 
36) Alert Thresholds can be set for

  1. Specific Value
  2. Listof Values
  3. Range of Values
  4. All of the above

Answer : D

 
 
37) The basic process of creating a model :

  1. Import data or Create query from external datasource.
  2. Add components and link them to spreadsheet.
  3. Modify the appearance, style and layout of components.
  4. Preview and publish the model.

 

  1. 1,2,&4
  2. 1,3&4
  3. All of the above
  4. None

Answer : A

 
 
38) Color schemes are not transferred with XLF files.

  1. TRUE
  2. FALSE

Answer : A

 
 
39) Consider the scenario:
A custom color scheme is applied in the model and the model is opened in design mode on another computer. Which statements are correct?

  1. Custom color schemes continues to be used by existing components
  2. New components can’t mak
  3. 1&2
  4. 3
  5. 4
  6. None

Answer : A

 
 
40) Embedded spreadsheet can support macros & conditional formatting.

  1. TRUE
  2. FALSE

Answer : B

 
 
41) Inserting data in the embedded spreadsheet can be done by:

  1. Importing data from Excel.
  2. Copy & paste date from another spreadsheet.
  3. Manually enter data.
  4. Link a query’s result objects to cells.
  5. 1,2&3
  6. 3&4
  7. All of the above
  8. None of the above

Answer : C

 
 
42) SUMIF, VLOOKUP & HLOOKUP affects the dashboard models performance.

  1. TRUE
  2. FALSE

Answer : A

 
 
43) How many number of rows are supported in a range selection in the embedded spreadsheet?

  1. 512
  2. 256
  3. Unlimited
  4. None

Answer : C

 
 
44) Web Service connection allows to connect to external data sources using ________ protocol.

  1. UDDI
  2. HTTP
  3. WSDL
  4. SOAP

Answer : B

 
 
45) An XML data connection allows to connect to external data sources using __________ protocol.

  1. XML-RPC
  2. UDDI
  3. HTTP
  4. WSDL

Answer : C

 
 
46) Flash variable connections can be used to pass

  1. session tokens
  2. User IDs
  3. Web Service URLS
  4. All of the above

Answer : D

 
 
47) LCDS stands for

  1. Liveoffice Connetions Data Service
  2. LiveCycle Data Services
  3. Life Cycle Data Services
  4. None of the above

Answer : B

 
 
48) Dashboards is a ___________________ tool

  1. BI
  2. Analytical
  3. Visualization
  4. None

Answer : C

 
 
49) RunQueryAsASServiceEX is set in the Query As a Web Service connection for?

  1. Index unaware prompts
  2. Date Prompts
  3. Index aware prompts
  4. Optional Prompts

Answer : C

 
 
50) ___________ is considered as a SAP datasource.

  1. Portal Data
  2. Flash Variables
  3. Live Office Connection
  4. None

Answer : C

 
 
51) Logon credentials are not passed from parent Xcelsius model file when calling a secondary SWF file.

  1. TRUE
  2. FALSE

Answer : A

 
 
52) Xcelsius is a ___________________ tool

  1. BI
  2. Analytical
  3. Visualization
  4. None

Answer : C

 
 
53) Which type of connection can’t be added again to a model after it’s added once?

  1. QAAWS
  2. XML Data
  3. Portal Data
  4. LCDS

Answer : B

 
 
54) Optimize Spreadsheet option when enabled:

  1. Xcelsius calculates the formulas in the model while exporting to SWF.
  2. Xcelsius calculates the formulas in the model at runtime of the model.

Answer : A

 
 
55) Grid Component allows
1) Static data 2) Edit data 3) Drag the values

  1. 1&3
  2. 2 only
  3. 2&3
  4. All of the above

Answer : C