ITSW 1304 Excel Spreadsheet Ch. 5

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

.txt

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

.xlsx

Freeze Panes

A command to set column and row headings so that they remain on the screen while scrolling to other parts of the worksheet

Record

All of the categories of data pertaining to a person, place, thing, event, or idea

CSV file (comma separated values)

Files type in Excel that saves the file with a comma between each cell

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

Filtering

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

T

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

T

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

T

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

T

You can create your own themes, cell styles, and table styles in Excel.

T

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

T

You would use a wildcard character to search a field when you are uncertain of the exact value for which you are searching.

T

Query

Term that refers to asking a question about the data in a database

Hyperlinks can be attached to which of the following items?

Text and graphics

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

compound criteria.

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

custom filter.

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

database

A ________ is a single piece of information that is stored in every record within each table column.

field

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.

field

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

theme.

Criteria and List ranges are a(n) ________ reference when defining a database area in a spreadsheet.

Absolute

The use of two or more criteria on the same row is known as a:

compound criteria.

Cell Styles

A set of formatting characteristics you can apply to a cell

Field

A single piece of information that is stored with every record in a spreadsheet

Wildcard

A special character, such as the asterisk (*) used when searching for files or fields when you are uncertain of the exact value or to widen the search results

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

A to Z.

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

And operator.

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

Arrange All

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

CSV

Which of the following types of files can be readily exchanged with various database programs?

CSV or comma separated values

Hyperlink

Colored and underlined text that, when clicked, takes you to another location, such as the Web or an intranet

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

Custom filter

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

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

A file developed by Microsoft that provides a visual image of a spreadsheet is a portable document format file.

F

A question mark (?) in a search criteria will allow you to search for multiple characters in the field.

F

Detail data does not refer to the subtotaled rows that are totaled and summarized.

F

When filtering by format and value using AutoFilter in Excel, each of the filter types are not mutually exclusive for the column, where you can use one filter at a time.

F

You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.

F

You can create a custom table style by clicking:

Format as Table.

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

Format, values, and criteria

To set column and row titles on the screen while you scroll, which of the following command(s) would you use?

Freeze Panes

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

Go To

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

Go To Special

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

List

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

List

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?

Modify the hyperlink to reflect the change

For the ________, only one of the two comparison criteria that you specify must be true.

Or comparison operator

Database

Organized collection of facts related to a specific topic

Themes can be found on the ________ tab in the themes group.

Page Layout

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

Save As

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

Sort dialog box

Defining data as a table prior to sorting the data is optional.

T

Excel worksheets and workbooks can be saved as Web pages, no matter how large or how many worksheets there are in a file.

T

If data within an Excel spreadsheet is not organized so that Excel can outline it automatically, you can create an outline manually.

T

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

T

It is not required to format the selected range in a spreadsheet as a table, it can be a table or a database.

T

The criteria range indicates how the displayed records in a spreadsheet are filtered.

T

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

T

Arrange All

Tiles all open worksheets on the screen

The ________ area of a worksheet contains data or has contained data and does not include any empty cells.

active

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

additive

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

another location in the worksheet or the company intranet.

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

asterisk (*)

The Page Break Preview window shows where the page breaks by displaying:

blue dashed lines and the page number on the worksheet.

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

cell style.

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

commas.

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

detail

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

extracted

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

extracting.

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

extracting.

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

horizontal and vertical

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.

hyperlink

The first sort level is sometimes referred to as the:

major sort.

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

mixing Colors and Fonts from any of the supplied themes.

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

orientation and page breaks.

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

panes

You can share worksheets or workbooks with others by:

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

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

record

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

scaling

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

show and hide

A theme combines font sets for:

text and headings.

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

text file