Chapter 5 Quiz, 20/20
A command that displays only the rows that meet a criteria.
Filter
To apply complex criteria to a single column, use a(n) ________.
custom filter
You can force the data in a worksheet into a selected number of pages by using the ________ command.
scaling
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
A file type that saves the contents of the cells by placing commas between them and an end-of-paragraph mark at the end of each row.
CSV
A widely used file format developed by Adobe Systems that lets you create a representation of electronic paper that displays your data on the screen as it would look when printed
The Excel View in which you can adjust paging in a worksheet.
Page Break Preview
The command on the Page Layout tab that enables you to repeat column or titles when printing a long worksheet.
Print Titles
To save an Excel file in another file format, use the ________ command.
Save As
A command that organizes data in a particular order.
Sort
Before subtotaling a list, the list must be:
Sorted
The command that totals several rows of related data together.
Subtotal
The criteria range is an area on your worksheet where you define the criteria for the filter.
True
To quickly locate specific text, formatting, or type of information within a workbook, use the Find command.
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 save an Excel file as a text file with which of the following file extensions?
.txt
A command that removes information from view in a worksheet.
Hide
Colored and underlined text that you can click to go to a file, a location in a file, a webpage on the Internet, or a webpage on your organization's intranet.
Hyperlink