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
Autofilter
B
auto-outline
C
collapse
D
criterion
2) A built-in set of filtering capabilities.
A
auto-outline
B
Autofilter
C
criterion
D
collapse
3) To condense groups into single-row headings called outlines.
A
auto-outline
B
collapse
C
criterion
D
Autofilter
4) A condition you specify to limit which records are returned when filtering data.
A
criterion
B
AutoFilter
C
auto-outline
D
collapse
5) An electronic file that stores a series of records in a relatively simple format.
A
delimiter
B
filter
C
data file
D
database
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
delimiter
B
filter
C
database
D
data file
7) A character that separates data entries from one another.
A
delimitr
B
data file
C
filter
D
database
8) A restriction that Excel uses to determine which worksheet rows to display.
A
delimiter
B
data file
C
database
D
filter
9) Organizing data so it can be viewed as a collapsible and expandable outline.
A
outline symbol
B
macro
C
grouping
D
outline
10) A series of steps you record that you might want to repeat frequently to save time.
A
grouping
B
macro
C
outline symbol
D
outline
11) Single-row headings.
A
macro
B
grouping
C
outline
D
outline symbol
12) Symbols that add controls next to the row and column headings to change the view of an outlined worksheet.
A
outline
B
macro
C
grouping
D
outline symbol
13) To separate into components. Also, to interpret character by character.
A
parse
B
subtotal
C
slicer
D
quick format
14) Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional.
A
quick format
B
slicer
C
parse
D
filter
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
subtotal
B
macro
C
outline
D
slicer
17) A range of cells in a worksheet that contains related data and can be used by a lookup function.
A
spacrse
B
table
C
outline
D
slicer
18) A feature in Excel that ensures data is entered correctly, before it is processed incorrectly.
A
filter
B
subtotal
C
table
D
Validation
*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?