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

If the file to which a hyperlink refers to is moved or renamed,or a webpage to which a hyperlink refers has a new address,which of the following do you need to do to the hyperlink to make it work correctly?

To move to a specific cell or range of cells in a large worksheet use the ________ command.

You can use a(n)________ list to sort in an order that you define.

Instead of displaying a filtered list,you can copy the results of a filter to another area of your worksheet for comparison purposes;this action is known as ________.

A predesigned set of colors,fonts,lines,and fill effects that look good together and can be applied to your workbook is a ________.

To save an Excel file in another file format,use the ________ command.

By default,Excel 2016 files are saved in the native Microsoft Excel Workbook file format with the following file extension ________.

To force data into a selected number of pages,use the ________ command.

You can customize your table by creating and applying a custom table style of your own design.

You can save a single worksheet as a webpage,where Excel changes the content of the worksheet into ________,a language web browsers can interpret.

Subtotaled rows that are totaled and summarized are referred to as ________ data.

When you create a custom list,the list remains available for all workbooks that you use in Excel.

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.

The first step in adding subtotals to a group or list is to sort the data by the ________ for which you want to create a subtotal.

Fonts are associated with different themes and can be customized by ________.

Data can be pulled out or copied from a filtered list and placed below the table of data.

Which of the following are some frequently and commonly used file formats for Excel?

A theme combines font sets for ________.

Match the terms or phrases with their meanings: i.Database II.Field III.Detail Data IV.Subtotal Command v.List

When outlining a worksheet,if the data is not organized so that Excel can outline it automatically,you can create an outline manually.