Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 2013 Lesson 9 Vocab
Test Description: Excel 2013 lesson 9 vocab
Instructions: Answer all questions to get your test result.
1) A feature that automatically groups selected rows in Excel.
A
collapse
B
auto-outline
C
Autofilter
D
criterion
2) A built-in set of filtering capabilities.
A
collapse
B
criterion
C
Autofilter
D
auto-outline
3) To condense groups into single-row headings called outlines.
A
collapse
B
auto-outline
C
Autofilter
D
criterion
4) A condition you specify to limit which records are returned when filtering data.
A
AutoFilter
B
criterion
C
auto-outline
D
collapse
5) An electronic file that stores a series of records in a relatively simple format.
A
database
B
data file
C
delimiter
D
filter
6) 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
filter
C
database
D
delimiter
7) A character that separates data entries from one another.
A
database
B
data file
C
delimitr
D
filter
8) A restriction that Excel uses to determine which worksheet rows to display.
A
filter
B
data file
C
delimiter
D
database
9) Organizing data so it can be viewed as a collapsible and expandable outline.
A
macro
B
outline symbol
C
grouping
D
outline
10) A series of steps you record that you might want to repeat frequently to save time.
A
outline symbol
B
macro
C
grouping
D
outline
11) Single-row headings.
A
grouping
B
outline
C
macro
D
outline symbol
12) 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 symbol
D
outline
13) To separate into components. Also, to interpret character by character.
A
quick format
B
parse
C
slicer
D
subtotal
14) Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional.
A
filter
B
quick format
C
parse
D
slicer
15) One of the ways to filter a table so that it shows only records containing a certain object.
A
quick format
B
slicer
C
subtotal
D
parse
16) The sum of values that are grouped together.
A
slicer
B
outline
C
subtotal
D
macro
17) A range of cells in a worksheet that contains related data and can be used by a lookup function.
A
table
B
spacrse
C
slicer
D
outline
18) A feature in Excel that ensures data is entered correctly, before it is processed incorrectly.
A
filter
B
Validation
C
subtotal
D
table
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?