feature that automatically groups selected rows in excel

a builtin set of filtering capabilities

to condense groups into single-row headings called outlines

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

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

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 character that separates entries from one another

restriction that excel uses to determine which worksheet rows to display

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

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

add controls next to the row and column headings to change the view of an outlined worksheet

to separate into components and to interpret character by character

predefined formatting in excel that enables you to apply an elaborate format that makes a table look sleek and professional

one of the ways to filter a table so that it shows only records containing a certain object.

sum of values that are grouped together

a range of cells in a worksheet that contains related data and can be used by a lookup function

feature in excel that ensures data is entered correctly, before it is processed incorrectly.

Help

Options

Question

auto-outline

click to flip

focusNode

Didn't know it?
click below

Knew it?
click below

Don't know

Question

autofilter

Remaining cards (17)

Know

retry

shuffle

restart

0:00

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Excel Lesson 9

Terms/Questions

Question	Answer
auto-outline	feature that automatically groups selected rows in excel
autofilter	a builtin set of filtering capabilities
collapse	to condense groups into single-row headings called outlines
criterion	a condition you specify to limit which records are returned when filtering data
data file	an electronic file that stores a series of records in a relatively simple format
database	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
delimiter	a character that separates entries from one another
filter	restriction that excel uses to determine which worksheet rows to display
grouping	organizing data so it can be viewed as a collapsible and expandable outline
macro	series of steps you record that you might want to repeat frequently to save time.
outline	single row headings
outline symbol	add controls next to the row and column headings to change the view of an outlined worksheet
parse	to separate into components and to interpret character by character
quick format	predefined formatting in excel that enables you to apply an elaborate format that makes a table look sleek and professional
slicer	one of the ways to filter a table so that it shows only records containing a certain object.
subtotal	sum of values that are grouped together
table	a range of cells in a worksheet that contains related data and can be used by a lookup function
validation	feature in excel that ensures data is entered correctly, before it is processed incorrectly.

Created by: pskendrick

"Know" box contains:
Time elapsed:
Retries: