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