Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
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
NP Excel 5
Microsoft Excel Study Guide Flash Card
| Question | Answer |
|---|---|
| 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 |
Created by:
skindawg
Popular Computers sets