Excel 2013 Lesson 9 Vocab Question Preview (ID: 37798)


Excel 2013 Lesson 9 Vocab. TEACHERS: click here for quick copy question ID numbers.

A feature that automatically groups selected rows in Excel.
a) auto-outline
b) Autofilter
c) collapse
d) criterion

A built-in set of filtering capabilities.
a) auto-outline
b) Autofilter
c) collapse
d) criterion

To condense groups into single-row headings called outlines.
a) auto-outline
b) Autofilter
c) collapse
d) criterion

A condition you specify to limit which records are returned when filtering data.
a) auto-outline
b) AutoFilter
c) collapse
d) criterion

An electronic file that stores a series of records in a relatively simple format.
a) data file
b) database
c) delimiter
d) filter

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.
a) data file
b) database
c) delimiter
d) filter

A character that separates data entries from one another.
a) data file
b) database
c) delimitr
d) filter

A restriction that Excel uses to determine which worksheet rows to display.
a) data file
b) database
c) delimiter
d) filter

Organizing data so it can be viewed as a collapsible and expandable outline.
a) grouping
b) macro
c) outline
d) outline symbol

A series of steps you record that you might want to repeat frequently to save time.
a) grouping
b) macro
c) outline
d) outline symbol

Single-row headings.
a) macro
b) outline
c) outline symbol
d) grouping

Symbols that add controls next to the row and column headings to change the view of an outlined worksheet.
a) grouping
b) macro
c) outline
d) outline symbol

To separate into components. Also, to interpret character by character.
a) parse
b) quick format
c) slicer
d) subtotal

Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional.
a) parse
b) quick format
c) filter
d) slicer

One of the ways to filter a table so that it shows only records containing a certain object.
a) parse
b) quick format
c) slicer
d) subtotal

The sum of values that are grouped together.
a) slicer
b) macro
c) outline
d) subtotal

A range of cells in a worksheet that contains related data and can be used by a lookup function.
a) table
b) slicer
c) spacrse
d) outline

A feature in Excel that ensures data is entered correctly, before it is processed incorrectly.
a) table
b) subtotal
c) filter
d) Validation

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 37798 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links