Question | Answer |
A total row appears as the last row of a table to? | Display summary statistics, such as a sum. |
Sorting arranges records in a table by what? | the value in field(s) within a table. |
A page break? | Indicates where data starts on a new printed page. |
A table is? | an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis. |
To Freeze Columns and/or rows..? | Use the View Tab, Window Group, and click Freeze Panes/ |
A structured reference is? | is a tag or use of a table element as a reference in a formula. |
Using Conditional Formatting to draw attention to cells containing errors does what? | Helps locate errors in cells quickly. |
Filtering the Cost column (field) to show only records Greater than $10,000 is an application of what? | a Number filter |
Sorting Values smallest to largest does what? | arranges numbers in sequential order. |
Using Conditional Formatting to draw attention to cells that are bland does what? | helps locate where data may be missing. |
A Table Style controls what? | The fill color of the header row, columns, and records in a table. |
A Table is what? | An area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis. |
A Field is what? | An individual piece of data, such as a last name. |
A print area is? | It defines the range of data to print. |
A data bar is? | a horizontal gradient or solid fill indicating the cell's relative value compared to other cells. |
Top Bottom Rules? | Format cells based upon their value in relation to the value of other cells such as the top 10%. |
To convert a table back into a range..? | Click within the table, click the Table Tools Design tab, and then select Convert to Range. |
A structured reference..? | is a tag or use of a table element as a reference in a formula. |
What does previewing the worksheet in Backstage view do? | it enables you to adjust settings to control how the worksheet will print. |
A Record is ..? | a complete set of data for and entity. |
To remove duplicate records (rows), | Select any cell in the table, then click Remove Duplicates from the TOols group on the Table Tools Design tab. |
An color scale...? | a conditional format that displays a particular color based on the relative value of the cell contents to other selected cells. |
Conditional Formatting? | highlights or emphasizes cells that meet certain conditions. |
Filtering the Date column (field0 to show only records older than January 2001 is an example of what? | a Date filter |
What is an 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. |
Freeze Top Row | keeps only the top row visible as you scroll through a worksheet. |
Filtering the Cost column (field) to show only record Greater than $10,000 is an application of what? | a Number Filter |
Sorting Values smallest to largest does what? | arranges numbers in sequential order. |