Excel 2010 Test Questions 33

166. Which of the following is the default method for summarizing data in a PivotTable?

A.    Count

B.     Average

C.     Max

D.    Sum

Answer: D

167. What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?

A.    Decrease/Increase

B.     Collapse/Expand

C.     Reduce/Add

D.    Subtract/Add

Answer: B

168. In order to directly report the data, what must a PivotChart always be associated with?

A.    Table

B.     Range

C.     PivotTable

D.    Worksheet

Answer: C

169. Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?

A.    Design

B.     Layout

C.     Format

D.    Analyze

Answer: A

170. Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart?

A.    Design

B.     Layout

C.     Format

D.    Analyze

Answer: B

If You Enjoyed This, Take 5 Seconds To Share It

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