27 terms
Excel Chapter 4
A conditional format that displays horizontal gradient or solid fill indicating 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 a 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 a number of fields (columns).
Table
The process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.
Freezing
You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this?
Print titles.
Set a print area.
Change the print page order.
Adjust page breaks.
Print titles.
Set a print area.
Change the print page order.
Adjust page breaks.
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?
Hide Rows command
Freeze Panes command
New Window command and cascade the windows
Split Rows command
Hide Rows command
Freeze Panes command
New Window command and cascade the windows
Split Rows command
Freeze Panes command
Which statement is not a recommended guideline for designing and creating an Excel table?
Include field names on the first row of the table.
Ensure no blank columns separate data columns within the table.
Leave one blank row between records in the table.
Avoid naming two fields with the same name
Include field names on the first row of the table.
Ensure no blank columns separate data columns within the table.
Leave one blank row between records in the table.
Avoid naming two fields with the same name
Leave one blank row between records in the table.
You have a list of all the employees in your organization. The list contains employee name, office, title, and salary. You want to list all employees in each office branch. The branches should be listed alphabetically, with the employee earning the highest salary listed first in each office. Which is true of your sort order?
Salary is the primary sort and should be from highest to lowest.
Branch office is the primary sort and should be in A to Z order.
Salary is the primary sort and should be from lowest to highest.
Branch office is the primary sort and should be in Z to A order.
Salary is the primary sort and should be from highest to lowest.
Branch office is the primary sort and should be in A to Z order.
Salary is the primary sort and should be from lowest to highest.
Branch office is the primary sort and should be in Z to A 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?
Find the duplicate records and change some of the data to be different.
Use the Remove Duplicates command.
Do nothing; a logical reason probably exists to keep identical records.
Look at each row yourself and manually delete duplicate records.
Find the duplicate records and change some of the data to be different.
Use the Remove Duplicates command.
Do nothing; a logical reason probably exists to keep identical records.
Look at each row yourself and manually delete duplicate records.
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?
Header Row
Total Row
Banded Columns
Banded Rows
Header Row
Total Row
Banded Columns
Banded Rows
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?
Before
Equals
Between
All Dates in the Period
Before
Equals
Between
All Dates in the Period
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
Count
Sum
Max
Min
Count
Sum
Max
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?
Data Bars
Color Scales
Icon Sets
Sparklines
Data Bars
Color Scales
Icon Sets
Sparklines
Data Bars
When you select the ______ rule type, the New Formatting Rule dialog box does not show the Format button.
Use a formula to determine which cells to format
Format only cells that contain
Format all cells based on their values
Format only unique or duplicate values
Use a formula to determine which cells to format
Format only cells that contain
Format all cells based on their values
Format only unique or duplicate values
Format all cells based on their values