3. When we attempt to group a date field, the Grouping dialog box enables us to apply which of the following groups?

A. Months only.

B. Quarters only.

C. Years only

D. Months, Quarters, and Years.

4. Three of the following are valid methods for filtering a PivotTable. Which one is not?

A. Insert a field into the Filters area to create a report filter.

B. Use the field filter control on any row or column field.

C. Create a slicer

D. Use conditional formatting to highlight the desired values.

5. Which command launches Excel's web browser?

A. From Access.

B. From Web.

C. From Text.

D. From Other Sources.