Excel End of Chapter 4 Quiz

STUDY
PLAY

Terms in this set (...)

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 on to accomplish this?
Answer: 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 S,Y, and Z?
Answer: Freeze Panes command
Which statement is not a recommended guideline for designing and creating an Excel table?
Answer: Leave on 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?
Answer: 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?
Answer: 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?
Answer: 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?
Answer: 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?
Answer: 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?
Answer: Data Bars
When you select the ___ rule type, the New Formatting Rule dialog box does not show the Format button.
Answer: Format all cells based on their values