Quiz 5

Filtering

________ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results.

Field

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

cell style

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)

another location in the worksheet or the company intranet

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

Theme

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

theme

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

list

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

text and headings

A theme combines font sets for ________.

database

An organized collection of facts related to a specific topic is known as a ________.

field

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

show and hide

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

panes

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 ________.

custom filter

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

Freeze Panes

To freeze column and row titles on the screen so that they are visible while you scroll, which of the following command(s) would you use?

Go To

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

Go To Special

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

Save As

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

Arrange All

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

Custom Filter

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

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

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

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?

Format as Table

You can create a custom table style by clicking ________.

Scaling

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

.txt

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

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 ________.

orientation and page breaks

Before printing or distributing a large worksheet, the Print Preview option enables you to see ________.

.xlsx

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

hyperlink

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

mixing Colors and Fonts from any of the supplied themes

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

Text and graphics

Hyperlinks can be attached to which of the following Items?

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

Or comparison operator

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

extracting

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 ________.

commas

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

tab delimited text file

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

horizontal and vertical

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

detail

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

blue dashed lines and the page number on the worksheet

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

List

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