Part 4 of 4
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| 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.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
jphoto
Popular Computers sets