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 icon sets the data bar
Question 7. Question:( TCO 4) For subtotals to be useful and accurate, it is important that the data be _____ correctly. sorted formatted aligned labeled
Question 8. Question:( TCO 4) _____ are created to organize and summarize data in pivot tables. Categories Types Titles