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.

Remove Ads
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

NP Excel 5

Microsoft Excel Study Guide Flash Card

Order that arranges labels in reverse alphabetical order, from Z to A. descending
Doing this to rows and columns lets you keep headings on the screen as you work with the data in a large worksheet. freezing
Displays any existing entry in the column that matches the characters you typed, as you type. autocomplete
Accepts the existing entry that Excel gives. tab
A collection of similar data arranged in rows and columns (often converted to/from a table) is called a: range
Returns to cell A1 in a worksheet. Ctrl+Home
Condition that requires all of the selected criteria to be true for the record to be displayed. AND
Criteria filter that requires the records displayed to start with the specified text string. begins with
Fields used to order your data. sort fields
Button (plus sign) at the top of the outline area that allow you to show different levels. expand
Appears below column headers to indicate which row is frozen dark line
To insert a total row in an Excel table, check this box on the Design tab: total row
To collapse items in a PivotTable, press this: minus sign
After data is filtered, it can be copied, sorted, or: charted
Using these instead of regular tables makes is easier to rearrange, hide or display data in alternative views: PivotTables
The small triangle show in the bottom right corner of a table range is called: sizing handle
After an autocorrection is made, the little button that pops up is called: AutoCorrect Options
This command can be used to provide summary information easily, including count, sum, and average: Subtotals
The _____ buttons at the top of the outline area allow you to show or hide different levels of detail: outline
You can sort data by things other than just numbers or text, including cell color, font color and: cell icon
To remove precedent arrows, click this tab: Formulas
To display Subtotals, click this tab: Data
To freeze rows and columns, click this tab: View
These provide a way to quickly format an entire table using a preset definition: table styles
Each column in a table represents this, which describes some characteristic of a person, place or thing. field
The first row of a range contains field names and is called: header row
Each row in a table represents a; record
The Total Row summary function can either SUM, AVERAGE, MIN, MAX or: COUNT
If you sort on more than one column, the second sort field is called the: secondary sort field
You can use up to this many sort fields in a single sort; 64
If you sort on more than one column, the third sort field is called the: tertiary sort field
If you wished to create a list that sorted on custom values (like in Month order or Condition order), you would lneed to create a: custom list
Created by: skindawg