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
- No
- Yes
- None
2) What is the use of AFD? Where it can be stored?
- used to create dashboards. It can be stored in repository, corporate or personal.
- used to create Reports and It can be stored in repository, corporate or personal.
- used to create universe and It can be stored in repository, corporate or personal.
- Opt B & C
3) Why do we need metrics and sets?
- Metrics are used for analysis and Sets are used for grouping.
- Metrics are used to hold numeric values and Sets used for aggregation
- Metrics are used in Aggregate awareness and Sets are used for grouping
- Opt A & B
4) BO Xcelsius is a tool for
- Query and Analysis
- Data Visualization
- Data Mining
- A & C
5) Which one them cannot be scheduled
- Crystal Report
- Desktop Intelligence Reports
- Web Intelligence report
- Xcelsius
6) XCelsius is a ___________________ tool
- BI
- Analytical
- Visualization
- NONE
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
- Both 1 & 2
- Area Chart
- Bullet Chart
- Line Chart
8) How many axis a Bubble Chart has?
- Two
- Three
- One
- None
9) Which chart is best suited if one has to display a range of values and a trend line for these values?
- Line Chart
- Scatter Plot
- Combination Chart
- Area Chart
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?
- Area Chart
- XY Chart
- Line Chart
- Combination Chart
11) OHLC is otherwise known as ____________
- Bubble Chart
- Candlestick Chart
- Radar Chart
- Sparkline
12) Sparkline chart is good at displaying ____________ data
- One dimesional
- Two dimensional
- Multi dimensional
- None
13) Which chart is best suited to compare two sets of data along with hierarchical data?
- Bubble Chart
- Treemap
- XY Chart
- Waterfall Chart
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?
- Sparkline
- Waterfall
- XY Chart
- Radar
15) Is it possible to add backgrounds or borders to a Canvas Container?
- TRUE
- FALSE
16) Which of the following is not a Container Component?
- Tab Set
- Canvas
- Image
- Canvas
17) Which of the following components are Selector Components?
- Accordion Menu 2. Toggle Button 3. Fisheye picture menu 4. Ticker
- 1& 2
- 2 & 4
- All of the above
- None of the above
18) Can Icon be used as a selector or display component?
- TRUE
- FALSE
19) Which selector is best suited to animate data for the users?
- Play Selector
- Fisheye Picture Menu
- Sliding Picture Menu
- None
20) Which of the following statement is correct regarding Single value components?
- A) useful for displaying or inserting data to an individual cell.
- B) useful for displaying or inserting an invidual row or column.
21) Visual alerts can be displayed using:
- Fisheye picture Menu
- Scorecard
- Hierarchical Table
- None
22) Which component scrolls the text within the model?
- Sliding Picture Menu
- Ticker
- Fisheye Picture menu
- Play Selector
23) Minimum and Maximum limit cannot be set for input components.
- TRUE
- FALSE
24) Spinner is an _____________ component.
- Input
- Output
- Selector
- Canvas
25) Which of the following is not a Text Component?
- Input Text
- Input Text Area
- Label
- Text Box
26) For which component we can’t set up alerts from the following:
- Spinner
- Dial
- Gauge
- Value
27) How does Trend Analyzer work?
- A) inserts data point for the trendline in the spreadsheet which can be then be added to the model.
- B) automatically inserts the trend line to the model.
- C) creates a trend line and forecast values automatically when applied.
- D) None
28) Image component is an ____________
- Input Component
- OutputComponent
- Art & Background Component
- CanvasComponent
29) Alert Thresholds can be set for
- Specify Value
- Listof Values
- Range of Values
- All of the above
30) Performance of the model is affected in case of
- Embedded Files
- Reference Files
31) In case of embedded files, the external file is loaded even if it is hidden through dynamic visibility.
- TRUE
- FALSE
32) When image is imported in to the normal Image components: Which of the below statement is valid?
- A) Xcelsius stores its own local copy of the image file internally
- B) Xcelsius references the actual image file whenever needed.
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?
- Host application file must be made trusted
- Cross-domain policy file must be set up.
34) Which statement is correct regarding deleting a componentfrom a group?
- A) To delete a component from a group, the components should be ungrouped first.
- B) Ungrouping is not necessary to delete a component
35) Alerts are not available for ___________
- Bubble Chart
- Area Chart
- Bar Chart
- Maps
36) Alert Thresholds can be set for
- Specific Value
- Listof Values
- Range of Values
- All of the above
37) The basic process of creating a model :
- Import data or Create query from external datasource.
- Add components and link them to spreadsheet.
- Modify the appearance, style and layout of components.
- Preview and publish the model.
- 1,2,&4
- 1,3&4
- All of the above
- None
38) Color schemes are not transferred with XLF files.
- TRUE
- FALSE
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?
- Custom color schemes continues to be used by existing components
- New components can’t mak
- 1&2
- 3
- 4
- None
40) Embedded spreadsheet can support macros & conditional formatting.
- TRUE
- FALSE
41) Inserting data in the embedded spreadsheet can be done by:
- Importing data from Excel.
- Copy & paste date from another spreadsheet.
- Manually enter data.
- Link a query’s result objects to cells.
- 1,2&3
- 3&4
- All of the above
- None of the above
42) SUMIF, VLOOKUP & HLOOKUP affects the dashboard models performance.
- TRUE
- FALSE
43) How many number of rows are supported in a range selection in the embedded spreadsheet?
- 512
- 256
- Unlimited
- None
44) Web Service connection allows to connect to external data sources using ________ protocol.
- UDDI
- HTTP
- WSDL
- SOAP
45) An XML data connection allows to connect to external data sources using __________ protocol.
- XML-RPC
- UDDI
- HTTP
- WSDL
46) Flash variable connections can be used to pass
- session tokens
- User IDs
- Web Service URLS
- All of the above
47) LCDS stands for
- Liveoffice Connetions Data Service
- LiveCycle Data Services
- Life Cycle Data Services
- None of the above
48) Dashboards is a ___________________ tool
- BI
- Analytical
- Visualization
- None
49) RunQueryAsASServiceEX is set in the Query As a Web Service connection for?
- Index unaware prompts
- Date Prompts
- Index aware prompts
- Optional Prompts
50) ___________ is considered as a SAP datasource.
- Portal Data
- Flash Variables
- Live Office Connection
- None
51) Logon credentials are not passed from parent Xcelsius model file when calling a secondary SWF file.
- TRUE
- FALSE
52) Xcelsius is a ___________________ tool
- BI
- Analytical
- Visualization
- None
53) Which type of connection can’t be added again to a model after it’s added once?
- QAAWS
- XML Data
- Portal Data
- LCDS
54) Optimize Spreadsheet option when enabled:
- Xcelsius calculates the formulas in the model while exporting to SWF.
- Xcelsius calculates the formulas in the model at runtime of the model.
55) Grid Component allows
1) Static data 2) Edit data 3) Drag the values
- 1&3
- 2 only
- 2&3
- All of the above