Excel Lesson 6

Question 0

Filtering reorganizes data so it appears in a different order. True or False

Answer 0

False

Question 1

Sorting always arranges data in a worksheet with the smallest values listed first. True or False

Answer 1

False

Question 2

Hiding deletes a row or column from a worksheet. True or False

Answer 2

False

Question 3

Inserting a comment a cell does not affect the results of a formula contained in that cell. True or False

Answer 3

True

Question 4

Excel workbooks can be saved in other file formats. True or False

Answer 4

True

Question 5

Workbook used as a model to create other workbooks

Answer 5

Template

Question 6

Changes the look of cells that meet a specific condition

Answer 6

Conditional formatting

Question 7

Organizes data in a more meaningful order

Answer 7

Sorting

Question 8

A cell or picture that opens another location or file, an e-mail address, a new document, or Web page when clicked

Answer 8

Hyperlink

Question 9

Displays a subset of data that meet certain criteria

Answer 9

AutoFilter

Question 10

A message that explains or identifies information in a cell

Answer 10

Comment