Excel Chapter 4

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

A conditional format that displays horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.

Data bar

The smallest data element contained in a table, such as first name, last name, address, and phone number.

Field

The process of specifying conditions to display only those records that meet those conditions.

Filtering

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

Format all cells based on their values

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

Freeze Panes command

The process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.

Freezing

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

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

Leave one blank row between records in the table.

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

An indication of where data will start on another printed page.

Page break

The range of cells within a worksheet that will print.

Print area

The sequence in which the pages are printed.

Print order

A group of related fields representing one entity, such as data for one person, place, event, or concept.

Record

A predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a database.

SUBTOTAL function

The process of listing records or text in a specific sequence, such as alphabetically by last name.

Sorting

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 structure that organizes data in a series of records (rows), with each record made up of a number of fields (columns).

Table

The rules that control the fill color of the header row, columns, and records in a table.

Table style

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

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.

Use the Remove Duplicates command.

A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications.

Conditional formatting

A conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells.

Color scale

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

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

Between

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.

Branch office is the primary sort and should be in A to Z order.

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.

Change the print page order.