Chapter 6 Review Questions
True/False
1. Sorting always arranges data in a worksheet with the smallest values listed first.
2. Filtering reorganizes data so it appears in a different order.
3. Hiding deletes a row or column from a worksheet.
4. Inserting a comment in a cell does not affect the results of a formula contained in that cell.
5. Excel workbooks can be saved in other file formats.
Matching
1. Workbook used as a model to create other workbooks. template
2. Changes the look of cells that meet a specific condition. Conditional formatting
3. Organizes data in a more meaningful order sorting
4. A cell or picture that opens another location or file, e-mail address, a new document, web page when clicked. Hyperlink
5. Displays a subset of data that meet certain criteria. filter
6. A message that explains or identifies information in a cell. Comment
Written Questions
Fill in the blank
1. A descending sort arranges data with numbers from highest to lowest.
2. Highlightening cells based on their rank, such as the top 10 items, is an example of formatting.
3. A sdfkj is anything that appears on the screen that you can select and work with as a whole, such as a shape, picture or chart.
4. A sfjk is an area of a program window that you can insert in a workbook as object.
5. The kjfk task pane provides access to information typically found in dictionaries, thesauruses, and encyclopedias.
Copyright © 2026 eLLeNow.com All Rights Reserved.