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

Excelfinal4

Part 4 of 4

QuestionAnswer
A total row appears as the last row of a table to? Display summary statistics, such as a sum.
Sorting arranges records in a table by what? the value in field(s) within a table.
A page break? Indicates where data starts on a new printed page.
A table is? an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
To Freeze Columns and/or rows..? Use the View Tab, Window Group, and click Freeze Panes/
A structured reference is? is a tag or use of a table element as a reference in a formula.
Using Conditional Formatting to draw attention to cells containing errors does what? Helps locate errors in cells quickly.
Filtering the Cost column (field) to show only records Greater than $10,000 is an application of what? a Number filter
Sorting Values smallest to largest does what? arranges numbers in sequential order.
Using Conditional Formatting to draw attention to cells that are bland does what? helps locate where data may be missing.
A Table Style controls what? The fill color of the header row, columns, and records in a table.
A Table is what? An area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
A Field is what? An individual piece of data, such as a last name.
A print area is? It defines the range of data to print.
A data bar is? a horizontal gradient or solid fill indicating the cell's relative value compared to other cells.
Top Bottom Rules? Format cells based upon their value in relation to the value of other cells such as the top 10%.
To convert a table back into a range..? Click within the table, click the Table Tools Design tab, and then select Convert to Range.
A structured reference..? is a tag or use of a table element as a reference in a formula.
What does previewing the worksheet in Backstage view do? it enables you to adjust settings to control how the worksheet will print.
A Record is ..? a complete set of data for and entity.
To remove duplicate records (rows), Select any cell in the table, then click Remove Duplicates from the TOols group on the Table Tools Design tab.
An color scale...? a conditional format that displays a particular color based on the relative value of the cell contents to other selected cells.
Conditional Formatting? highlights or emphasizes cells that meet certain conditions.
Filtering the Date column (field0 to show only records older than January 2001 is an example of what? a Date filter
What is an icon set? a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
Freeze Top Row keeps only the top row visible as you scroll through a worksheet.
Filtering the Cost column (field) to show only record Greater than $10,000 is an application of what? a Number Filter
Sorting Values smallest to largest does what? arranges numbers in sequential order.
Created by: jphoto
Popular Computers 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