Which of the following feature is not supported by Excel pivot table? Connect to
ID: 3735803 • Letter: W
Question
Which of the following feature is not supported by Excel pivot table?
Connect to an SSAS server cube and use its measures and dimensions
Format values in the table
Expand/collapse a hierarchy
Insert an Excel formula in the table cell
Which of the following statement about Excel cube functions is incorrect?
Cube functions are more flexible than pivot table.
Cube functions have to work with a pivot table.
Cube functions are entered in spreadsheet cells
Cube functions need a valid data source connection to work
Which of the following is NOT a valid Excel cube function?
cubevalue
cubemeasure
cubemember
cubeset
The slicer control in Excel is used to
-separate chart axis values
-set a filter on a dimension member
-change aggregation levels.
-display hidden members.
A)Connect to an SSAS server cube and use its measures and dimensions
B)Format values in the table
C)Expand/collapse a hierarchy
D)Insert an Excel formula in the table cell
Explanation / Answer
1.
Option D correct.
Excel pivot table features:
2.
Option B correct.
Excel cube functions:
3.
Option B correct.
Excel cube functions
4.
Option 1 correct.
The slicer control in Excel is used to separate chart axis values.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.