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

To move to cells that have special characteristics,are blank,or contain constants,use the ________ command.

If your worksheet is wider than one page,you will also want to repeat the row titles on each page when you print or view the worksheet.

To set column and row titles on the screen while you scroll,use the ________ command.

You can filter by format and value by using ________.

Detail data refers to the subtotaled rows that are totaled and summarized.

A text file can be converted from tab delimited text to a Word table by selecting the ________ command that easily converts a tabbed file into a table.

When using compound criteria on the same row,all the conditions must be met for the records to be included in the results.

In Excel,the applied theme has a set of complimentary ________,which are defined sets of formatting characteristics,such as fonts,font sizes,number formats,cell borders,and cell shading.

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

By using a(n)________ filter,you can apply complex criteria to a single column.

Use the ________ mark wildcard to search criteria that represents a single position or character that is unknown in a group of specified values.

To publish a document and ensure that the appearance of the document is the same no matter what computer it is displayed on,save the document in ________ format.

A sort on a group of numbers that is sorted from highest to lowest is known as a(n)________ sort.

The file format known as Portable Document Format was developed by Microsoft.

You can force the data in a worksheet into a selected number of pages by using the ________ command.

Using the Advanced command disables the AutoFilter command and removes the AutoFilter arrow from the column headings.

When using custom or advanced filters,the selected range can be formatted as a table or a database.

Match the terms or phases with their meanings: i.Theme II.Cell Style III.Hyperlink IV.Scaling v.CSV file (comma separated values)