ITE 140 Chapter 5
A hyperlink in a worksheet may take you to which of the following locations ________.,
another location in the worksheet or the company intranet
The Page Break view shows where the page breaks will occur by displaying ________.,
blue dashed lines and the page number on the worksheet
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) ________.,
cell style
Saving an Excel worksheet as a CSV file separates the cells of each row with ________.,
commas
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
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
You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.,
false
A ________ is a single piece of information that is stored in every record.,
field
Scaling reduces the ________ size of the printed data by a percentage or by the number of pages you specify.,
horizontal and vertical
A series of rows that contains related data is known as a ________.,
list
Fonts are associated with different themes and can be customized by ________.,
mixing Colors and Fonts from any of the supplied themes
A question mark (?) in a search criteria enables you to search for single characters in the field.
,True
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
You can force the data in a worksheet into a selected number of pages by using the ________ command.
,scaling
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
Both the List and the Criteria ranges use absolute references.,
True
Data can be pulled out or copied from a filtered list and placed below the table of data.,
True
Defining data as a table prior to sorting the data is optional.,
True
Detail data refers to the subtotaled rows that are totaled and summarized.,
True
Excel worksheets and workbooks can be saved as web pages.,
True
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 worksheet.,
True
The active area of a worksheet contains data or has contained data and does not contain cells that were not used in the worksheet.,
True
The criteria range must have a row for the column headings and at least one row for the criteria.,
True
The outline bar along the left side of a worksheet enables you to show and hide levels of detail with a single mouse click.,
True
To quickly locate specific text, formatting, or type of information within a workbook, use the Find command.,
True
Use a wildcard character to search a field when you are uncertain of the exact value for which you are searching.,
True
Using the Advanced command disables the AutoFilter command and removes the AutoFilter arrow from the column headings.,
True
When outlining a worksheet, if the data is not organized so that Excel can outline it automatically, you can create an outline manually.,
True
When using compound criteria on the same row, all the conditions must be met for the records to be included in the results.
True
When using custom or advanced filters, the selected range can be formatted as a table or a database.,
True
When you create a custom list, the list remains available for all workbooks that you use in Excel
True
You can create your own themes, cell styles, and table styles in Excel.,
True
You can customize your table by creating and applying a custom table style of your own design.,
True
Which of the following file formats is commonly used to import data into a database program?,
CSV
Subtotaled rows that are totaled and summarized are referred to as ________ data.
Detail
Which of the following are some frequently and commonly used file formats for Excel?,
Excel Template, Excel 97-2003 Workbook, CSV, tab delimited
A series of rows that contains related data is known as a query.,
False
Subtotal rows that are totaled and summarized are referred to as actual data.,
False
The file format known as Portable Document Format was developed by Microsoft.
False
The first sort level is sometimes referred to as the primary sort.,
False
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
________ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results.,
Filtering
You can create a custom table style by clicking ________.,
Format as Table
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?,
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 have special characteristics, are blank, or contain constants, use the ________ command.,
Go to special
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 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
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
To save an Excel file in another file format, use the ________ command.,
Save as
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 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
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
Hyperlinks can be attached to which of the following items?,
text and graphics
A theme combines font sets for ________.,
text and headings
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 ________.,
theme
By default, files are saved in the native Microsoft Excel Workbook file format with the following file extension ________., .
xlsx