ITE 140 Module 5

By default, Excel files are saved in the Excel Workbook file format with the ________ file name extension.

.xlsx

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

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

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

Field

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

Filtering

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

Freeze Panes

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

Go To

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

Go To Special

HTML is an acronym for which of the following?

Hypertext Markup Language

Hyperlinks can be attached to which of the following items?

Text and graphics

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

Theme

A defined set of formatting characteristics for a cell, such as the font, font size, font color, cell border, and cell shading, is known as a(n) ________.

cell style

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

database

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

extracting

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

Custom table styles that you create are stored ________.

only in the current workbook

You can change the ________ of a worksheet to landscape if you want to display more columns on the page.

orientation

A theme combines font sets for ________.

text and headings

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

Save As

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

And comparison operator

To tile multiple open 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

In the default Office theme, Calibri Light is the font for headings and ________ is the font for body text.

Calibri

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

Commas

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

List

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

Not "Record"

The Page Break Preview window displays ________ where the page breaks will occur.

Not "Solid red lines"

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

Not "advanced filter"

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

Not "summary"

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

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

horizontal and vertical

When you click a ________ in a worksheet, Excel may take you to another location in the worksheet, another file, or a webpage.

hyperlink

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

panes

You can use ________ to force a worksheet into a selected number of printed pages.

scaling

You can ________ worksheets or workbooks by printing paper copies, sending the file electronically, or posting the file to the web or a shared workspace.

share

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

show and hide

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

tab delimited text file