Excel - Module 5 study guide
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Using Excel, you can ____. | show 🗑
|
||||
| In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns. | show 🗑
|
||||
| A data ____ table describes the fields you plan to maintain in a table. | show 🗑
|
||||
| You should ____ the field names to make it easier to Excel to distinguish between the data in the list and the field names. | show 🗑
|
||||
| show | Ctrl & Home
🗑
|
||||
| ____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet. | show 🗑
|
||||
| show | below.
🗑
|
||||
| In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet. | show 🗑
|
||||
| show | table.
🗑
|
||||
| To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button. | show 🗑
|
||||
| A table name can include all of the following EXCEPT ____. | show 🗑
|
||||
| As you type in a cell, ____ displays any existing entry in the column that matches the characters you typed. | show 🗑
|
||||
| After Excel displays an existing entry in the column that matches the characters you typed, press the ____ key to accept the entry. | show 🗑
|
||||
| show | match entire cell contents.
🗑
|
||||
| show | descending.
🗑
|
||||
| show | fields.
🗑
|
||||
| show | 64.
🗑
|
||||
| show | editing.
🗑
|
||||
| When you have more than one sort field, you should use the Sort ____ to specify the sort criteria. | show 🗑
|
||||
| You can sort by ____. | show 🗑
|
||||
| show | add level
🗑
|
||||
| To delete a sort field in the Sort dialog box, click the ____ button. | show 🗑
|
||||
| show | four.
🗑
|
||||
| After data is filtered, you can ____ it. | show 🗑
|
||||
| show | clear.
🗑
|
||||
| show | data.
🗑
|
||||
| show | and.
🗑
|
||||
| The ____ condition requires that only one of the selected criteria be true for a record to be displayed. | show 🗑
|
||||
| Criteria filters allow you to specify relationships other than those that are based on a(n) "____" the criterion. | show 🗑
|
||||
| show | criteria.
🗑
|
||||
| show | begins with.
🗑
|
||||
| show | contains
🗑
|
||||
| The ____ criteria filter requires the records displayed not to have the specified text string anywhere. | show 🗑
|
||||
| The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers. | show 🗑
|
||||
| The ____ filtering option displays the top or bottom 10 (or specified number) items in a list. | show 🗑
|
||||
| show | today.
🗑
|
||||
| show | year-to-date
🗑
|
||||
| With the Last Quarter criteria filter, quarters are defined as, for example, ____. | show 🗑
|
||||
| When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions. | show 🗑
|
||||
| show | either two or four.
🗑
|
||||
| You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria. | show 🗑
|
||||
| You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet either of two criteria. | show 🗑
|
||||
| show | total.
🗑
|
||||
| show | insert function.
🗑
|
||||
| The Subtotals command offers summary information such as ____. | show 🗑
|
||||
| To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab. | show 🗑
|
||||
| The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet. | show 🗑
|
||||
| In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed. | show 🗑
|
||||
| A PivotTable summarizes data in different categories using functions such as ____. | show 🗑
|
||||
| show | rearrange, hide or display.
🗑
|
||||
| show | insert.
🗑
|
||||
| show | access database file, excel table in current workbook, excel range in current workbook.
🗑
|
||||
| You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab. | show 🗑
|
||||
| show | column.
🗑
|
||||
| By default, the PivotTable report uses the ____ function for numbers in the Values area. | show 🗑
|
||||
| show | live preview.
🗑
|
||||
| show | summarize values by.
🗑
|
||||
| The ____ report layout displays one column for each field and leaves space for column headers. | show 🗑
|
||||
| show | Refresh.
🗑
|
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:
galvanl
Popular Computers sets