Excel chap 5

list

A series of rows that contain related data is known as a:

orientation and page breaks

Before printing or distributing a large worksheet, the Preview option will allow you to see:

save as

Using the ____ command, you can choose to save an Excel file in another file format.

printing paper copies, sending the file electronically, or posting the file to the Web or a shared workspace

You can share worksheets or workbooks with others by:

database

an organized collection of facts related to a specific topic is known as a

text and graphics

hyperlinks can be attached to which of the following items?

and comparison operator

if you want every one of the comparison criteria that you specify to be true you would use the

cell style

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

theme

A predesigned set of colors, fonts, lines, and fill effects that look good together and which can be applied across all Office 2016 applications is called a

text and headings

A theme combines font sets for:

extracting

An advanced filter that is used for copying selected rows to another part of the worksheet is called:

A to Z

An ascending sort refers to text that is sorted alphabetically from:

major sort

The first sort level is sometimes referred to as the:

show and hide

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

blue dashed lines and the page number on the worksheet

The page break preview window shows where the page breaks by displaying:

panes

The portions of a worksheet bounded by and separated from other parts of the worksheet by horizontal and vertical lines are called:

compound criteria

The use of two or more criteria on the same row, it is known as a(n):

custom filter

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

Go To

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

sort dialog box

To sort data on several criteria at once use the ____, which enables you to sort by more than one column or row.

custom filter

Use a(n) ____ to apply complex criteria to a single column.

Go To Special

Which command would you use to move cells that have special characteristics, are blank, or contain constants?

Excel Template, Excel 97-2003 Workbook, CSV or tab delimited

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

Format, values, and criteria

Which of the following are the three types of filters you can create with AutoFilter?

record

Which of the following describes all of the categories of data pertaining to one person, place, thing, event, or idea within a table row?

CSV

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

extracting

You can copy the results of a filter to another area of your worksheet for comparison purposes: this action is known as:

Format as Table

You can create a custom table style by clicking:

.txt

You can save and Excel file as a text file with which of the following file extensions?

scaling

By applying ____ to a worksheet, the data will be forced into a selected number of pages.

.xlsx

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

another file location, a webpage on the intranet, or to your organization's Internet.

Clicking a hyperlink will take you to which other locations?

additive

Filtering actions are ____, each additional filter that you apply is based on the current filter.

mixing colors and fonts from any of the supplied themes

Fonts are associated with different themes and can be customized by:

modify the hyperlink to reflect the change

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 the hyperlink to make it work correctly?

And operator

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

extracted

Multiple sets of data can be pulled out or ____ from a filtered list and placed below the table of data.

commas

Saving and Excel worksheet as a CSV file separates the cells of each row with:

detail

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

asterisk (*)

The ____ is used as a wildcard symbol when searching for criteria in an Excel spreadsheet.

list

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

tab-delimited text files

saving an excel worksheet as a ______ separates the cell of each row with tab characters

page and worksheet

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

field

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

Freeze Panes

to freeze column and row tiles on the screen so that they are visible while you scroll, which of the following commands would you use?

Arrange all

to tile multiple open worksheets on the screen use the _______ command