the range of data to print
TCO 4 ) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet . ( Points : 2 )
Indicates where data starts on a new printed page Collection of structured , related data in columns and rows Freezing rows to keep them visible Freezing panes to keep them visible ( TCO 4 ) When sorting in Excel , it arranges records in a table _____. ( Points : 2 ) by the number of pages in the worksheet by the number of pages in the workbook by the value in field ( s ) within a table by permanently removing extraneous data
( TCO 4 ) Filtering the Last _ Name column ( field ) to show only records that begin with the letter S is an application of _____. ( Points : 2 )
the use of a table element as a formula a Number Filter a Text Filter a Date Filter ( TCO 4 ) Which of the following best describes conditional formatting ? ( Points : 2 ) Highlights or emphasizes cells that meet certain conditions Tags a table element as a reference in a formula Formats the condition of the worksheet in preparation for printing Calculates an aggregate for values in a range or database
( TCO 4 ) Using Conditional Formatting to draw attention to cells containing errors _____. ( Points : 2 )