Excel 2016 Lessons 9 & 10 Vocabulary Quiz

To condense groups into single row headings called outlines

• Criterion
• Filter
• Collapse
• Quick format

A condition you specify to limit which records are returned when filtering data

• Criterion
• Macro
• Parse
• Subtotal

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

• Database
• Data file
• Table
• Delimiter

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

• Macro
• Data file
• Database
• Table

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

• Grouping
• AutoFilter
• Subtotal
• Filter

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

• Grouping
• Collapse
• Filter
• Parse

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

• Filter
• AutoFilter
• Macro
• Delimiter

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

•  Criterion
• Validation
• Grouping
• AutoFIlter

The values that a function uses to perform operations or calculations

• Criteria
• Table array
• Arguments
• Macro

A formula in which the result is determined by the presence or absence of a particular conditon

• Conditional formula
• Criterion
• Database
• Subtotal