Microsoft Excel Study Guide Flash Card
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Order that arranges labels in reverse alphabetical order, from Z to A. | descending
🗑
|
||||
| Doing this to rows and columns lets you keep headings on the screen as you work with the data in a large worksheet. | freezing
🗑
|
||||
| Displays any existing entry in the column that matches the characters you typed, as you type. | autocomplete
🗑
|
||||
| Accepts the existing entry that Excel gives. | tab
🗑
|
||||
| A collection of similar data arranged in rows and columns (often converted to/from a table) is called a: | range
🗑
|
||||
| Returns to cell A1 in a worksheet. | Ctrl+Home
🗑
|
||||
| Condition that requires all of the selected criteria to be true for the record to be displayed. | AND
🗑
|
||||
| Criteria filter that requires the records displayed to start with the specified text string. | begins with
🗑
|
||||
| Fields used to order your data. | sort fields
🗑
|
||||
| Button (plus sign) at the top of the outline area that allow you to show different levels. | expand
🗑
|
||||
| Appears below column headers to indicate which row is frozen | dark line
🗑
|
||||
| To insert a total row in an Excel table, check this box on the Design tab: | total row
🗑
|
||||
| To collapse items in a PivotTable, press this: | minus sign
🗑
|
||||
| After data is filtered, it can be copied, sorted, or: | charted
🗑
|
||||
| Using these instead of regular tables makes is easier to rearrange, hide or display data in alternative views: | PivotTables
🗑
|
||||
| The small triangle show in the bottom right corner of a table range is called: | sizing handle
🗑
|
||||
| After an autocorrection is made, the little button that pops up is called: | AutoCorrect Options
🗑
|
||||
| This command can be used to provide summary information easily, including count, sum, and average: | Subtotals
🗑
|
||||
| The _____ buttons at the top of the outline area allow you to show or hide different levels of detail: | outline
🗑
|
||||
| You can sort data by things other than just numbers or text, including cell color, font color and: | cell icon
🗑
|
||||
| To remove precedent arrows, click this tab: | Formulas
🗑
|
||||
| To display Subtotals, click this tab: | Data
🗑
|
||||
| To freeze rows and columns, click this tab: | View
🗑
|
||||
| These provide a way to quickly format an entire table using a preset definition: | table styles
🗑
|
||||
| Each column in a table represents this, which describes some characteristic of a person, place or thing. | field
🗑
|
||||
| The first row of a range contains field names and is called: | header row
🗑
|
||||
| Each row in a table represents a; | record
🗑
|
||||
| The Total Row summary function can either SUM, AVERAGE, MIN, MAX or: | COUNT
🗑
|
||||
| If you sort on more than one column, the second sort field is called the: | secondary sort field
🗑
|
||||
| You can use up to this many sort fields in a single sort; | 64
🗑
|
||||
| If you sort on more than one column, the third sort field is called the: | tertiary sort field
🗑
|
||||
| If you wished to create a list that sorted on custom values (like in Month order or Condition order), you would lneed to create a: | custom list
🗑
|
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:
skindawg
Popular Computers sets