Terms/Questions
Help!
|
|
||||
|---|---|---|---|---|---|
| auto-outline | feature that automatically groups selected rows in excel
🗑
|
||||
| autofilter | a builtin set of filtering capabilities
🗑
|
||||
| collapse | to condense groups into single-row headings called outlines
🗑
|
||||
| criterion | a condition you specify to limit which records are returned when filtering data
🗑
|
||||
| data file | an electronic file that stores a series of records in a relatively simple format
🗑
|
||||
| database | a comparatively complex system that can store a large amount of related data, which requires a program to be able to assess and render that data
🗑
|
||||
| delimiter | a character that separates entries from one another
🗑
|
||||
| filter | restriction that excel uses to determine which worksheet rows to display
🗑
|
||||
| grouping | organizing data so it can be viewed as a collapsible and expandable outline
🗑
|
||||
| macro | series of steps you record that you might want to repeat frequently to save time.
🗑
|
||||
| outline | single row headings
🗑
|
||||
| outline symbol | add controls next to the row and column headings to change the view of an outlined worksheet
🗑
|
||||
| parse | to separate into components and to interpret character by character
🗑
|
||||
| quick format | predefined formatting in excel that enables you to apply an elaborate format that makes a table look sleek and professional
🗑
|
||||
| slicer | one of the ways to filter a table so that it shows only records containing a certain object.
🗑
|
||||
| subtotal | sum of values that are grouped together
🗑
|
||||
| table | a range of cells in a worksheet that contains related data and can be used by a lookup function
🗑
|
||||
| validation | feature in excel that ensures data is entered correctly, before it is processed incorrectly.
🗑
|
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:
pskendrick