Chapter 5 Quiz, 20/20

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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

PDF

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


Kaugnay na mga set ng pag-aaral

Anatomy: Blood Supply to the Abdomen

View Set