Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
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. Your email address is only used to allow you to reset your password. See 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.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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

Working with Data and Macros

QuestionAnswer
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 criterion is 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 steps 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 a 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: meganiannon
Popular Business sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards