Busy. Please wait.

show password
Forgot Password?

Don't have an account?  Sign up 

Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
Don't know
remaining cards
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
restart all cards
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


Lesson 9

Auto-Outline A feature that automatically groups selected rows in Excel
Autofilter A built-in 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. The plural of criteria
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 data entries from one another
Filter A 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 A series of step you record that you might want to repeat frequently to save time
Outline Single-row headings
Outline Symbol Symbols that add controls next to the row and column headings to change the view of an outlined worksheet
Parse To separate into components. Also, 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. A slicer is selection panel that floats above a worksheet (the way a chart does)
Subtotal The 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 A feature in Excel that ensures data is entered correctly, before it is processed incorrectly
Created by: 1641620