Exam 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Match the terms or phrases with their meanings: i.Custom Filter II.Extract III.Advanced Filter IV.Comparison Operators v.Criteria

Match the terms or phrases with their meanings: i.Sort dialog box II.Record III.Filtering IV.Extract area v.Criteria range

When filtering by format or value using AutoFilter in Excel,each filter type is mutually exclusive for the column;that is,you can use only one at a time.

A ________ is a single piece of information that is stored in every record.

Excel worksheets and workbooks can be saved as web pages.

Match the terms or phrases with their meanings: i.Freeze Panes II.Split III.Go To IV.Go To Special v.Arrange All

A custom list that you define must be based on a ________ such as text,a number,a date,or time.

The ________ button totals several row of related data together by automatically inserting subtotals and totals for the selected cells.

You can create a custom table style by clicking ________.

If you want every one of the comparison criteria that you specify to be true,you would use the ________.

Clicking a ________ will take you to another location in the worksheet,another file location,a webpage on the intranet,or to your organization's Internet.

Use a wildcard character to search a field when you are uncertain of the exact value for which you are searching.

The defined table range will automatically display as the ________ range in the Advanced Filter dialog box.

You can create your own themes,cell styles,and table styles in Excel.

Defining data as a table prior to sorting the data is optional.

The portions of a worksheet window bounded by and separated from other portions by vertical or horizontal lines as a result of using the Freeze Panes command are referred to as ________.

The outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click.

The Page Break view shows where the page breaks will occur by displaying ________.

In the outline bar,other views for outlining a worksheet include summary totals or ________ totals.

When you add subtotals,Excel defines groups and these groupings form a(n)________ of your worksheet that displays along the left side of the worksheet.