BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 88

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