22. Use the DLOOKUP function to extract a single record from a table that matches criteria you specify. a. True b. False 23. Which of the following Excel features applies a design using theme colors to a table? a. table style b. cell style c. font style d. number format 24. How can you add a new record to a table? Select all the options that apply. a. Type data directly below the last row of the table. b. Drag the sizing handle in the lower-right corner of the table. c. Click a row, click the Insert arrow in the Cells group, then click Insert Table Rows Above. d. Press ENTER at the end of any row. 25. Carmen filtered a table on the values in the Department column and now wants to clear the filter. What can she do? Select all the options that apply. a. Click the Sort \& Filter button on the Home tab, then click Clear. b. Click the Department arrow, then click Clear Filter from "Department". c. Click the Filter Button check box on the Table Design tab. d. Right-click a cell in the Department column, then click Clear Contents on the shortcut menu. 26. Soledad is working with a worksheet that groups data by quarter. The Quarter 4 details are hidden. She can click the Auto Outline button to display the hidden data. a. True b. False 27. One advantage of exporting a workbook as a PDF file is that a PDF preserves formatting and fonts but still lets readers edit the data. a. True b. False