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

To quickly locate specific text,formatting,or type of information within a workbook,use the Find command.

Both the List and the Criteria ranges use absolute references.

Saving an Excel worksheet as a CSV file separates the cells of each row with ________.

Match the terms or phrases with their meanings: i.Sort II.Ascending III.Descending IV.Query v.Custom List

Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.

Hyperlinks can be attached to which of the following items?

A defined set of formatting characteristics for a cell,such as fonts,font sizes,number formats,cell borders,and cell shading is known as a(n)________.

To specify three or more criteria for a particular column,use a(n)________ filter.

A hyperlink in a worksheet may take you to which of the following locations ________.

You can use criteria to compare two values by using ________ operators.

Subtotal rows that are totaled and summarized are referred to as actual data.

A series of rows that contains related data is known as a ________.

Match the terms or phrases with their meanings: i.tab delimited text file II..xlsx file name extension III.HTML (Hypertext Markup Language) IV.PDF (Portable Document File) v.comma delimited file

To tile multiple open worksheets on the screen,use the ________ command.

The criteria range must have a row for the column headings and at least one row for the criteria.

Which of the following file formats is commonly used to import data into a database program?

________ is the process of organizing data in a specific order.

To apply complex criteria to a single column,use a(n)________.

Scaling reduces the ________ size of the printed data by a percentage or by the number of pages you specify.

The first step in filtering using advanced criteria is to create a criteria ________ on your worksheet where you define the criteria for the filter.