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

Database

Excel- Chapter 6

QuestionAnswer
table (also called database) organized collection of rows and columns of similaryly structured data on a worksheet
record data related to each person or item
fields individual data items that make up a record
Each row of a worksheet can store a _________________? record
Each column of a worksheet can store ________ field for each _______. one record
What is the easiest way to create a table? create a table style
What is a banded row? a row that is highlighted in some way, usually every other row in a table
What is a header? a table header is the column heading that appears above the data
What are the rules about naming table? no spaces must begin with a letter or underscore
Why do duplicate entries sometimes happen? data is entered incorrectly updated by more than one person or source
What happens to the rows or columns adjacent to the table? rows and/or columns become part of the table.
When should you use 'Merge & Center'? centering text across a range of cells; it becomes one cell
When should you use 'Center Across Selection'? When you do not want the cells to become one cell. Center across selection centers across multiple cells
What is a table array? a range-containing table that contains data you want to retrieve
What is a lookup table? a table array that stores data retrieved with a lookup function
What are the two most widely used lookup functions? HLOOKUP VLOOKUP
What is the HLOOKUP function? it searches for a value in the top row of a lookup table or an array of values, and then returns a corresponding value in the same column. )
What is the VLOOKUP function? searches for a value in a column of a lookup table, and then returns a corresponding value in the same row from a column you specify
In the HLOOKUP function, which direction must the table be? horizontal (across: wide)
In the VLOOKUP function, which direction must the table be? vertical (tall)
What is the first argument of the VLOOKUP function? lookup value- data or location of the data you need to look up
What is the second argument of the VLOOKUP function? the location of the lookup table (set of rows and columns)
What is the third argument of the VLOOKUP function? column index number- represents the column location of the return value within the table array
What is the formula for the VLOOKUP? =VLOOKUP(lookup_value,table_array,col_index_)
What is a calculated field? contains a formula, function, cell reference, structured reference, or condition; automatically fills in the column without the use of a fill or copy command
What is a structured reference? a reference that allows table formulas to refer to table columns by names that are automatically generated when the table is created
When typing a function, what is the purpose of the [ (left bracket)? it begins a structured reference and causes excel to display the list of table fields
With Conditional Formatting, what does the variety of icons consist of? traffic signals, circles, flags, bars, arrows sets of 3, 4, or 5 icons
What are data bars? colored, horizontal rectangles in the cell the larger the number the wider the data bar
What is sorting? arranging records in a specific sequence
What is ascending order? sorted from lowest to highest; A to Z
What is descending order? sorted from highest to lowest; Z to A
What are sort keys? a field or fields that are selected to sort
What does criteria mean? a logical rule by which data is tested and chosen
What is a query? process of filtering records based on one or more filter criteria
What is the search string? the sequence of data you enter
What is a criteria range? a location separate from the table used to list specific search specifications
What is an extract range?
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