Microsoft Excel Lesson 9 Knowledge and Terms

Which of the following characters would not appear on an outline symbol or control for grouped or outlined data?

@

Which of the following does Excel not provide features for importing data?

A Web search

AutoFilter

A built-in set of filtering capabilities.

Database

A comparatively complex system that can store a large amount of related data, which requires a program to be able to assess and render that data.

Criterion

A condition you specify to limit which records are returned when filtering data. The plural of criterion is criteria.

Validation

A feature in Excel that ensures data is entered correctly, before it is processed incorrectly.

Auto-Outline

A feature that automatically groups selected rows in Excel.

Table

A range of cells in a worksheet that contains related data and can be used by a lookup function.

Filter

A restriction that Excel uses to determine which worksheet rows to display.

Macro

A series of steps you record that you might want to repeat frequently to save time.

Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table?

A table given a title enables its field names to be used in formulas in place of cell references.

TableName

An arbitrary name you give to a table, in place of its reference as a range. You can have more than one table on a worksheet, although it might not always be convenient. Examples: Customers, Back Orders, Comics Issues

Data File

An electronic file that stores a series of records in a relatively simple format.

Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?

Auction Items[#Totals]

Delimiters

Characters that separate data entries from one another

Which of the following procedures is not a way to SORT a table by the contents of one column?

Click AN AutoFilter button in the total row.

Which of the following procedures is not a way to FILTER a table by the contents of one column?

Click THE AutoFilter button in the total row at the bottom.

Which of the following attributes is not potential criterion for an AutoFilter sort?

Font style

Slicer

One of the ways to filter a table so that it shows only records containing a certain object. A slicer is a selection panel that floats above a worksheet (the way a chart does).

Grouping

Organizing data so it can be viewed as a collapsible and expandable outline.

Quick Format

Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional.

Outlines

Single-row headings.

Outline Symbols

Symbols that add controls next to the row and column headings to change the view of an outlined worksheet.

FieldName

The field name from the header row of the table. The name refers to the set of all cells that comprise the named column in the table. You do not need to specify the start and end cell. The field name is always denoted with [square brackets]. Examples: [Last Name], [Issue Date], [Sale Price]

Subtotals

The sum of values that are grouped together

Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups?

There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups

Collapse

To condense groups into single-row headings called outlines

Which of the following is a valid reason for converting a table to a range?

To prepare for importing new data from a non-Excel file

Parse

To separate into components. Also, to interpret character by character.

Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative references?

You want to preserve the integrity of any cells referenced by formulas in the macro.