Click on the correct response for each question below.
 |
1 | |
In a list, each column contains |
| | A) | the same category of information. |
| | B) | different categories of information. |
| | C) | blank rows. |
| | D) | different types of data. |
|
|
2 | |
Using a simple Excel data form for record maintenance operations |
| | A) | greatly reduces the chances of making data entry mistakes. |
| | B) | lessens the amount of formatting necessary. |
| | C) | lessens the amount of information that must be entered. |
| | D) | lessens necessary changes. |
|
|
3 | |
When typing character search criteria, Excel matches fields based on |
| | A) | alphabetical order. |
| | B) | capitalization. |
| | C) | spelling. |
| | D) | primary records. |
|
|
4 | |
This should be used for more complex sort operations that involve more than one column. |
| | A) | Sort command |
| | B) | Sort field command |
| | C) | Sort table command |
| | D) | Sort column command |
|
|
5 | |
The Sort command of the Data menu provides this capability. |
| | A) | Multiple-row |
| | B) | Multiple-column |
| | C) | Multiple-field |
| | D) | Multiple-table |
|
|
6 | |
When using AutoFilter, this is not one of the three filter choices that appear in all list columns. |
| | A) | None |
| | B) | All |
| | C) | Custom |
| | D) | Top 10 |
|
|
7 | |
With AutoFilter, you can eliminate displaying rows in which a particular column contains a |
| | A) | field. |
| | B) | record. |
| | C) | blank. |
| | D) | sort. |
|
|
8 | |
This is the only requirement for the Subtotals command to do its work properly. |
| | A) | The list must be sorted by relational operators before the Subtotals command is used. |
| | B) | The list must be sorted in Ascending order before the Subtotals command is used. |
| | C) | The list must be sorted by conditions before the Subtotals command is used. |
| | D) | The list must be sorted in order by the field specified as the grouping field before the Subtotals command is used. |
|
|
9 | |
This detail level displays all active list members, subtotals, and the grand total. |
| | A) | Three |
| | B) | One |
| | C) | Two |
| | D) | Four |
|
|
10 | |
To display row or column headings on each page use this menu command. |
| | A) | Format, Page Setup, Sheet tab |
| | B) | Table, Page Setup, Sheet tab |
| | C) | Tools, Page Setup, Sheet tab |
| | D) | File, Page Setup, Sheet tab |
|
|
11 | |
The most efficient method to locate a record is to use the Find Record tab. |
| | A) | True |
| | B) | False |
|
|
12 | |
Excel uses the asterisk (*), question mark (?), and pound sign (#) as wildcard characters for search criteria. |
| | A) | True |
| | B) | False |
|
|
13 | |
The descending sort order arranges dates from oldest to newest. |
| | A) | True |
| | B) | False |
|
|
14 | |
By using two sort fields, you will always be able to sort a list into order and eliminate any ties. |
| | A) | True |
| | B) | False |
|
|
15 | |
The AutoFilter feature will allow data to be displayed as blanks or nonblanks for any column. |
| | A) | True |
| | B) | False |
|
|
16 | |
Excel has the ability to hide or unhide rows when needed. |
| | A) | True |
| | B) | False |
|
|
17 | |
The Data Subtotals command can be used to calculate subtotals and grand totals in a list. |
| | A) | True |
| | B) | False |
|
|
18 | |
Only cells meeting specified criteria in a worksheet will display under the control of the relational formatting. |
| | A) | True |
| | B) | False |
|
|
19 | |
Pivot tables can help you simplify and understand data in an Excel table or list. |
| | A) | True |
| | B) | False |
|
|
20 | |
With the Pivot table feature, one can easily summarize information contained in an Excel list of individual transactions. |
| | A) | True |
| | B) | False |
|