Question 1
When you click the ________ button, the filtering arrows are removed from the cells, but the color and formatting of the table style remain.
◦ Get External Data
◦ Convert to Table
◦ Convert to Range
◦ Available Windows
Question 2
To make sorting and filtering easier, you can separate data into separate fields by using ________.
◦ data rule
◦ Remove Duplicates
◦ query
◦ Flash Fill