Chapter 4: Getting and Managing Data

Questions

Multiple Choice

1. Imported content in a worksheet that originated in another program or format is:
   1. External data
   2. Imported content
   3. Matching sheets
   4. Exported files
   5. Access database
2. An Excel command that recognizes a pattern and duplicates it is:
   1. AutoSum
   2. AutoComplete
   3. Flash Fill
   4. Copy Down
   5. Replicate
3. The type of importable document that includes raw data, no formatting, and uses commas or other characters to separate the data into columns and rows is a:
   1. Field
   2. Text file
   3. List
   4. Table
   5. Worksheet
4. When you import a document into Excel that uses special characters, such as commas to separate columns, you are importing a:
   1. Delimited file
   2. Field file
   3. Table
   4. Grid defined file
   5. Source file
5. The Microsoft Office relational database application that works with Excel to import and export data is called:
   1. WordPad
   2. Backstage
   3. Office Wizard
   4. DataDrop
   5. Access
6. Website data can be imported into Excel if the data is:
   1. Hyperlinked
   2. List-type
   3. Delimited
   4. Simplified
   5. CSS
7. In an Excel table, the first row of the table with unique descriptive titles or labels is the:
   1. Header row
   2. Title row
   3. Field bar
   4. Ribbon
   5. Descriptor
8. When you apply a predesigned set of built-in format options such as borders, fill colors, and effects for an Excel table, you use a:
   1. Custom group
   2. Filter
   3. Data design
   4. Table style
   5. Layout
9. The process of arranging rows of data in an identified order is called:
   1. Sorting
   2. Arranging
   3. Editing
   4. Formatting
   5. Aligning
10. To use an Advanced Filter in Excel, you first need to create a:
    1. Condition
    2. Criteria range
    3. Location
    4. Data definition
    5. Query
11. When you use Excel’s subtotal command your list data is formatted as a(n):
    1. Outline
    2. Table
    3. Worksheet
    4. Record
    5. Group
12. When you need to highlight information in a worksheet by setting different fill colors or font styles for cells containing data that meet specified criteria, use this Excel feature.
    1. AutoFormat
    2. Shade and Fill
    3. Filter
    4. Conditional formatting
    5. Range formatting
13. The term for specified Excel data that is indicated with a fill color, a horizontal bar, or an icon within the cell is:
    1. Data visualization
    2. Graphic interface
    3. Gradient display
    4. Special formatting
    5. Data table
14. The basic conditional formatting command that uses relational or comparison operators to determine if the value or label in a cell should be formatted is:
    1. Conditional Rules
    2. Conditional Selection
    3. Highlight Cells Rules
    4. DataFind
    5. Standard Deviation
15. To sort numerical data from the largest to the smallest value, use this sort order:
    1. Ascending
    2. Conditional
    3. Filter
    4. Descending
    5. Down