Busy. Please wait.
Log in with Clever

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever

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.
Didn't know it?
click below
Knew it?
click below
Don't Know
Remaining cards (0)
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

Adv Office: Excel T5

Excel Tables, Pivot Tables, Pivot Charts

Data Definition Table Documentation that lists the fields to be maintained for each record and a description of the information each field will include.
ascending order The arrangement of text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.
criteria filter Conditions you specify for a filter
custom list The sequence you specify to sort data
descending order The arrangement of text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest
field A characteristic or a person, place, or thing (such as a last name, address, city, or state); in Excel, each column represents a field.
field name A unique label that describes the contents of the data in a column; also called a column header
filter The process of displaying a subset of rows in an Excel table that meets the specified criteria.
freeze The process of keeping rows and/or columns you select visible as you scroll the worksheet
header row The first row of the range or Excel table that contains field names
pane A section of a window; In Excel, you can split the worksheet window into two or four resizable panes
PivotChart A graphical representation of the data in a PivotTable
PivotTable An interactive table used to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis
primary sort field The first sort field
record A collection of related fields that are grouped together; in Excel, each row in an Excel table or range represents a record
refresh To update
secondary sort field The second sort field
slicer An object used to filter a PivotTable or PivotChart
sort The process of rearranging data such as the records in an Excel table or range based on one or more fields; data can be sorted in ascending or descending order
sort field A field that you use to order data
split bar A moveable bar that indicates the division between panes and that can be dragged to resize the panes
Total row A row at the end of an Excel table that is used to calculate summary statistics (such as sum, average, count, maximum, and minimum) for each column in the Excel table
value field A field that contains summary data in a PivotTable
Created by: mgarda
Popular Computers sets




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:
restart all cards