Quiz 5

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. a) CSV b) CDV c) PDF

a) CSV

A command that displays only the rows that meet a criteria. a) Filter b) Sort c) Table Style

a) Filter

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. a) Hyperlink b) Cell Style c) URL

a) Hyperlink

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. a) PDF b) XPS c) HTML

a) PDF

Before subtotaling a list, the list must be: a) Sorted b) Formatted as a Table c) Filtered

a) Sorted

The command that totals several rows of related data together. a) Subtotal b) Split c) Filter

a) Subtotal

The Excel View in which you can adjust paging in a worksheet. a) Normal b) Page Break Preview c) Print Preview

b) Page Break Preview

A command that organize data in a particular order. a) Filter b) Sort c) Table Style

b) Sort

A command that removes information from view in a worksheet. a) Split b) Unhide c) Hide

c) Hide

The command on the Page Layout tab that enables you to repeat column or titles when printing a long worksheet. a) Preview Titles b) Page Break Preview c) Print Titles

c) Print Titles