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)