|
1 | | Which of the following functions would you use, if you wished to quickly create smaller lists out of a much larger list on an Excel worksheet? |
| | A) | PivotTable |
| | B) | Filter |
| | C) | Conditional format |
| | D) | Data analysis |
|
|
|
2 | | To filter a list with the Filter function, on an Excel worksheet, you need to perform the following steps: (1) click in any cell within the list; (2) From the menu bar, click on _____ and then click on Filter. |
| | A) | Review |
| | B) | Formulas |
| | C) | Page Layout |
| | D) | Data |
|
|
|
3 | | Which of the following data functions would you use to hide all rows in a worksheet except those that meet some criteria you specify? |
| | A) | Sort |
| | B) | Query |
| | C) | Custom Filter |
| | D) | Conditional Formatting |
|
|
|
4 | | The Custom Filter box allows the entry of how many criteria for creating a filtered list? |
| | A) | Two |
| | B) | Three |
| | C) | Four |
| | D) | Five |
|
|
|
5 | | Which of the following Excel tools would you use, if you wish to highlight, not hide, some information in a worksheet, because it meets some criteria you specify? |
| | A) | List Definition |
| | B) | Value Field Settings |
| | C) | Conditional Formatting |
| | D) | Custom Filter |
|
|
|
6 | | Which of the following Excel tools enables you to group and summarize information? |
| | A) | Conditional Formatting |
| | B) | PivotTable |
| | C) | Sorting |
| | D) | Field Lists |
|
|
|
7 | | While using a pivot table in Excel, the _____ area is where you will drop a field of information to create pages or layers. |
| | A) | Report Filter |
| | B) | Column Labels |
| | C) | Row Labels |
| | D) | Values |
|
|
|
8 | | While using a pivot table in Excel, you drop the fields of information that you want in the interior of the pivot table in which of the following areas? |
| | A) | Report Filter |
| | B) | Column Labels |
| | C) | Row Labels |
| | D) | Values |
|
|
|
9 | | While using a pivot table in Excel, when you drop information into the "Values" area in the lower-right corner, the default summarization is by summation. Which of the following tools will you use to change the default summarization? |
| | A) | Value Field Settings |
| | B) | PivotTable Field List |
| | C) | What-If Analysis |
| | D) | Column Labels |
|
|
|
10 | | Which of the following Excel tools works backward from an objective to compute an unknown value? |
| | A) | Goal Seek |
| | B) | Custom Filter function |
| | C) | PivotTable |
| | D) | Boolean operator |
|
|