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!
|
|
||||
---|---|---|---|---|---|
show | store, retrieve subset of data, create reports.
🗑
|
||||
show | range.
🗑
|
||||
A data ____ table describes the fields you plan to maintain in a table. | show 🗑
|
||||
show | change the font style or color of text, apply a boldface.
🗑
|
||||
Press ____ to return to cell A1 in a worksheet. | show 🗑
|
||||
show | freezing.
🗑
|
||||
A dark, horizontal line appears ____ the column headers to indicate which row is frozen. | show 🗑
|
||||
In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet. | show 🗑
|
||||
When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data. | show 🗑
|
||||
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 🗑
|
||||
show | tab.
🗑
|
||||
show | match entire cell contents.
🗑
|
||||
show | descending.
🗑
|
||||
show | fields.
🗑
|
||||
show | 64.
🗑
|
||||
You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option. | show 🗑
|
||||
When you have more than one sort field, you should use the Sort ____ to specify the sort criteria. | show 🗑
|
||||
You can sort by ____. | show 🗑
|
||||
To add a sort field in the Sort dialog box, click the ____ button. | show 🗑
|
||||
show | delete level.
🗑
|
||||
Excel provides ____ predefined custom sort lists. | show 🗑
|
||||
show | sort, chart or copy.
🗑
|
||||
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.
🗑
|
||||
The ____ criteria filter requires the records displayed to have the specified text string anywhere. | show 🗑
|
||||
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 🗑
|
||||
The ____ criteria filter requires the records displayed to have the current date. | show 🗑
|
||||
The ____ criteria filter requires the records displayed to be since January 1 of the current year to .the current date. | show 🗑
|
||||
show | Apr, May, June
🗑
|
||||
show | arrow
🗑
|
||||
You can split the worksheet window into ____ separate panes. | show 🗑
|
||||
show | and.
🗑
|
||||
show | or.
🗑
|
||||
show | total.
🗑
|
||||
You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function. | show 🗑
|
||||
show | count s, sums, averages.
🗑
|
||||
To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab. | show 🗑
|
||||
show | outline.
🗑
|
||||
In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed. | show 🗑
|
||||
show | min.
🗑
|
||||
show | rearrange, hide or display.
🗑
|
||||
show | insert.
🗑
|
||||
show | access database file, excel table in current workbook, excel range in current workbook.
🗑
|
||||
show | table tools design.
🗑
|
||||
show | column.
🗑
|
||||
By default, the PivotTable report uses the ____ function for numbers in the Values area. | show 🗑
|
||||
show | live preview.
🗑
|
||||
You can use the ____ tab to change the SUM function to a different summary function, in a PivotTable. | show 🗑
|
||||
The ____ report layout displays one column for each field and leaves space for column headers. | show 🗑
|
||||
You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data | show 🗑
|
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