6. What happens when you insert a table column or row? A. Excel uses the next table style on the new column or row for easy identification. B. The table and the worksheet take on the new column or row. C. Any sorts or filters applied are removed. D. The new column or row is added to the table area only. 7. When you apply a filter, Excel: A. puts a line through records not meeting your specifications B. temporarily hides the records not meeting your specifications C. automatically sorts the column data alphabetically D. deletes the unwanted data 8. How can you filter this data to show only the most successful salespeople based on tier level, with Tier 4 representing more sales? A. Select columns B-D and then click any of the three filter buttons and choose Arrange. B. Click the Tier 4 filter button and check only the box labeled x. C. Sort the table by Tier 4. D. Filter the Tier 1 column. 9. What is the difference between a sort and a filter? A. There is no difference; the terms are synonymous. B. Filters are associated with calculated columns and sorts are not. C. Sorts are done on regular worksheet cells while filters are for tables. D. A sort arranges table data as defined while a filter hides undesired data from view. 10. What does the upward-pointing arrow on a filter button indicate? A. The highest values have been filtered from the column. B. The column is sorted in ascending order. C. The sparkline is trending up. D. The total row values increased