What must you do to hide the field buttons of a PivotTable? a. Click Field Buttons on the PivotChart Analyze tab. b. Right-click the field buttons and select Delete. c. Remove any slicers. d. Remove the fields from the PivotTable. Which of the following techniques can you use to remove hyperlink from a cell? a. Right-click the hyperlink and then click Restore on the shortcut menu. b. Click the Delete button on the Home tab and then click Remove Hyperlink. c. Right-click the hyperlink and then click Remove Hyperlink on the shortcut menu. d. Click the Clear button on the Home tab and then click Remove Hyperlink. Will has a table that includes a field with four product types. What kind of filter would be best to create for the table? a. Custom number filter b. Date filter c. Slicer d. Advanced filter The PivotTable Fields pane lists the fields available to the PivotTable. True False The VLOOKUP function returns the position of a value found within a row or column True False QUESTION 29 To count only records that match a filter criteria, you use the SUBTOTAL function. True False