2. To change the math function applied to a value field, you can: A. Right-click the value cell and select the desired function from the Show Values As shortcut menu item. B. Right-click the value cell and select the desired function from the Summarize Values By shortcut menu item. C. Select the desired PivotTable value cell and then type an equal sign (=) followed by the desired math function, for example, =SUM. D. Similar to the SUBTOTAL function, you enter the desired function number into the function_num argument, for example, code 9 for SUM.

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.