Chapter 4 Excel: Getting and Managing Data

The Microsoft Office relational database application that works with Excel to import and export data is called?

- Access

When you need to highlight information in a worksheet by setting different fill colors or font styles for cells containing data that meet specific criteria, use this Excel feature?

- Conditional formatting

To use an Advanced Filter in Excel, you first need to create a?

- Criteria range

The term for specified Excel data that is indicated with a fill color, a horizontal bar, or an icon within the cell is?

- Data visualization

When you import a document into Excel that uses special characters, such as commas to separate columns, you are importing a?

- Delimited File

To sort numerical data from the largest to the smallest value, use this sort order?

- Descending

Imported content in a worksheet that originated in another program or format is?

- External Data

An Excel command that recognizes a pattern and duplicates it is?

- Flash Fill

In an Excel table, the first row of the table with unique descriptive titles or labels is called the?

- Header row

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?

- Highlight Cells Rules

Website data can be imported into Excel if the data is?

- List-type

When you use Excel's subtotal command your list data is formatted as an?

- Outline

The process of arranging rows of data in an identified order is called?

- Sorting

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?

- Table style

The type of importable document that includes raw data, no formatting, and uses commas or other characters to separate the data into columns and row is a?

- Text File

Matching 1. External data 2. Business Intelligence (BI) 3. Tab delimited 4. Record 5. Structured reference 6. Pivot Table 7. Microsoft SharePoint 8. Subtotal command 9. Auto Outline 10. Advanced Filter

1. Data from another program or format. 2. Applications and processes for assessing types of results or changes to data. 3. A tab character separates the fields. 4. Row of data in a table. 5. A column name along with its table nme. 6. Summary report in a separate worksheet based on list-type data. 7. Family of products that enable collaboration and simultaneous work by a co-workers and team members. 8. Inserts summary rows for a sorted list and formats the data as an outline. 9. Creates groups based on formulas that are in a consistent pattern in a list. 10. Criteria range separate from the actual data.