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

Excel

CH 4: Datasets and Tables

TermDefinition
Color scale A conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells.
Conditional formatting A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications.
Data bar A conditional format that displays horizontal gradient or solid fill indicating the cell's relative value compared to the other selected cells.
Field The smallest data element in a table, such as first name, last name, address, or phone number.
Filtering The process of specifying conditions to display only those records that meet those conditions.
Freezing The process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.
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.
Page break An indication where data will start on another printed page. The software inserts automatic page breaks based on data, margins, and paper size. Users can insert additional page breaks.
Print area The range of cells within a worksheet that will print.
Print order The sequence in which the pages are printed.
Record A group of related fields, representing one entity, such as data for one person, place, event, or concept.
Sorting The process of listing records or text in a specific sequence, such as alphabetically by last name.
Structured reference A tag or use of a table element, such as a column label, as a reference in a formula. Column labels are enclosed in square brackets, such as [Amount], within the formula.
SUBTOTAL function A math or trig function that calculates the total of values contained in two or more cells; the first argument in the function specifies which aggregate function applies to the values to the values in the range specified by the second argument.
Table An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns).
Table style A named collection of color, font, and border design that can be applied to a table.
Total row A table row that displays below the last row of records in an Excel table, or in Datasheet view of a table or query, and displays summary or aggregate statistics, such as a sum or an average.
A dataset prints on several pages. You want to ensure related records print on the same page with column and row labels visible and confidential information is not printed. You should apply following page setup options except which one to accomplish this? Change the print page order
You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z? Freeze Panes command
Which statement is not a recommended guideline for designing and creating an Excel table? Leave one blank row between records in the table.
You have a list of employees. The list contains name, office, title, & salary. You want to list employees in each office branch. The branches should be listed alphabetically, with the highest salary listed first in each office. Which is right sort order? Branch office is the primary sort and should be in A to Z order.
You suspect a table has several identical records. What should you do? Use the Remove Duplicates command.
Which check box in the Table Style Options group enables you to apply different formatting to the records in a table? Banded Rows
Which date filter option enables you to specify criteria for selecting a range of dates, such as between 3/15/2016 and 7/15/2016? Between
You want to display a total row that identifies the oldest date in a field in your table. What function do you select from the list? Min
What type of conditional formatting displays horizontal colors in which the width of the bar indicates relative size compared to other values in the selected range? Sparklines
When you select the ______ rule type, the New Formatting Rule dialog box does not show the Format button. Format all cells based on their values.
A conditional format that displays horizontal gradient or solid fill including the cell's relative value compared to other selected cells. Data bar.
The process of listing records or text in a specific sequence, such as alphabetically by last name. Sorting.
The process of specifying conditions to display only those records that meet those conditions. Filtering
A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications. Conditional formatting
A group of related fields representing one entity, such as data for one person, place, event, or concept. Record
The rules that control the fill color of the header row, columns, and records in a table. Table style
An indication of where data will start on another printed page. Page break
A table row that appears below the last row of records in an Excel table and displays summary or aggregate statistics, such as sum or an average. Total row
A conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells. Color scale
The sequence in which the pages are printed. Print order
A tag or use of a table element, such as a field label, as a reference in a formula. Field labels are enclosed in square brackets, such as [Amount] within the formula. Structured reference
A conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range. Icon set
The range of cells within a worksheet that will print. Print area
A predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a database. SUBTOTAL function
The smallest data element contained in a table, such as first name, last name, address, and phone number. Field
A structure that organizes data in a series of records (rows), with each record made up of number of fields (columns). Table
The process of keeping rows and/or columns visible onscreen all times even when you scroll through a large dataset. Freezing
Created by: TroyIS2241
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