Excel 2010 Test Questions 32

161. Which is the name of an interactive graphical representation of data that allows a user to change the groupings?

A.    PivotChart

B.     PivotTable

C.     PivotDate

D.    RotateTable

Answer: A

162. What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?

A.    Slivers

B.     Partials

C.     Slicers

D.    Movers

Answer: C

163. When creating a PivotTable, which are drawn in columns in the worksheet data?

A.    Records

B.     Fields

C.     Cells

D.    Ranges

Answer: B

164. What is the process of viewing a PivotTable report for a subset that meets the criterion only?

A.    Filtering

B.     Sorting

C.     Positioning

D.    Arranging

Answer: A

165. Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?

A.    Layout

B.     Options

C.     Design

D.    Format

Answer: C

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati