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

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