by the number of pages in the workbook by the value in field( s) within a table by permanently removing extraneous data
Question 4. Question:( TCO 4) Filtering the Last _ Name column( field) to show only records that begin with the letter S is an application of _____.
the use of a table element as a formula a Number Filter a Text Filter a Date Filter
Question 5. Question:( TCO 4) To apply a red background color to cells for employees who have sales greater than $ 1,000, you can use _____.
a pivot table a multiple level sort conditional formatting a range name
Question 6. Question:( TCO 4) In addition to sorting and filtering cells by content, you can sort and / or filter by _____.
top / bottom rules conditional formatting