QUESTION 17

1. A single PivotTable can draw information from two tables if the tables are _____.

   	a.	similar
   	b.	from the same source
   	c.	filtered
   	d.	related,

4 points

QUESTION 18

1. A(n} _____ combines items in a PivotTable field to create a new group, which appears as a new field in the PivotTable.

   	a.	value filter
   	b.	autocategory
   	c.	field header
   	d.	manual group

4 points

QUESTION 19

1. What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?

   	a.	Advanced
   	b.	Proofing
   	c.	Language
   	d.	Formulas