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.
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
Log In | Sign Up / Register