27 terms

Com S Ch. 4 Key terms/Matching

STUDY
PLAY

Terms in this set (...)

Color scale
Conditional format displaying particular color based on the relative value of cell contents to other selected cells.
Conditional formatting
Set of rules that applies specific formatting to highlight or emphasize cells that meet specifications
Data bar
Conditional format that displays a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells
Field
Smallest data element contained in a table such as first name, last name, and phone number
Filtering
Process of specifying conditions to display only those records that meet those conditions
Freezing
Process of keeping rows and/or columns visible on screen at all times even when scrolling through large data sheet
Icon set
Symbols or signs that classify data into three, four or five categories based on the values in a range.
Page break
Indication of where data will start on another printed page
Print area
Range of cells within a worksheet that will print
Print order
Sequence in which pages are printed
Record
Group of related fields representing one entity, such as data for one person, place, event, or concept
Sorting
Process of listing records or text in specific sequence, such as alphabetically by last name
Structured reference
Tag or use of table element such as field label, as a reference in a formula
SUBTOTAL function
Predefined formula that calculates an aggregate value such as totals for values in a range a table or a database
Table
Structure that organizes data in a series of records (rows) with each record made up of a number of fields (columns)
Table style
Rules that control the fill color of the header row, columns, and records in a table
Total row
Table row that appears below the last row of records in an excel table and displays summary or aggragate statistics such as a sum or an average
You have large dataset printing on several pages, you want to ensure that related records print on same page with column and row labels visible and that confidential info isn't printed, what shouldn't you apply page setup option...?
Change print page order
You have large worksheet, which command should be use to see row headings and distant info in columns xyz?
Freeze planes comand
What isn't a recommended guideline for designing and creating an excel table?
Leave one blank row between records in the table
What are characters are wildcards in excel?
* ?
How do you ensure that records in a table are unique?
Use remove duplicates command
Which conditional formatting rule is best suited to apply formatting to the top five values in a range of values?
Top 10 items
Which date filter option enables you to restrict the view to only dates that occur in March of 2018?
Between
Which of the following is an unqualified structured reference?
=[sales]purchase_price-[sales]down_payment
which isn't an aggregate function that can be applied in a total row?
VLOOKUP
If you like to set a conditional formatting rule based on the function =AND(g6="finance",h7<7000) which formatting rule type is needed?
Use a formula to determine which cells to format