Which
of the following statements is not true regarding offline cube files in
Microsoft Excel 2010?
a.
An offline cube file stores data in the form of an OLAP cube.
b. If you delete the offline cube
file for a report, still you can create a new offline cube file for the report.
c. An offline cube file allows you
to work with PivotTable and PivotChart reports even when the server is
unavailable.
You
are creating a new formatting rule which will be used to format a PivotTable
report. Which of the following formatting styles is NOT available while
formatting all cells of PivotTable report based on their values in an MS Excel
2010 worksheet?
a. 2-Color Scale
b. 3-Color Scale
c.
4-Color Scale
d. Data Bar
You
are a financial consultant to multiple clients and you made an investment model
for them. Now you want to find out how investment rates change under different
market conditions. Which of the following Microsoft Excel 2010 What-if analysis
tools will you use to study such conditions?
a.
Scenarios
b. Data tables
c. Goal Seek
