MODULE D

1. To highlight information that meets some criterion that you set, you could use _____ formatting.

Auto

Restrictive

Conditional

Limited

2. What is the intersection of a row and column in a spreadsheet called?

Group

Block

Cell

Object

3. _____ highlights the information in a cell that meets some criteria you specify.

Basic Filter

Custom Filter

Goal Seek

Conditional formatting

4. Which of the following spreadsheet features allows you to show only rows from a list that meets a specific condition?

Filter

AutoMatch

Goal Seek

Group

5. Regardless of how one uses the Filter function, Excel _____ rows that one does not want to see.

Deletes

Eliminates from the sublist

Does not include in the new table

Hides

6. A _____ is a description of a list by column.

List definition table

Pivot table

Feature key

Column definition

7. _____ is an Excel function that works backward from an objective to compute an unknown value.

Pivot table

Basic Filter

Custom Filter

Goal Seek

8. When creating a ____, you create dimensions of information by specifying how information is to be summarized by dimension.

List definition table

Pivot table

Worksheet

Sublist

9. Which of the following spreadsheet features allows you to quickly create a two-dimensional table with totals for groups of information?

Goal Seeking

Pivot table

Forms

Groups

10. Which of the following enables you to group and summarize information?

Pivot table

Conditional formatting

Basic Filter

Custom Filter

11. What is the difference between a Filter and a pivot table?

A Filter can analyze dissimilar information; a pivot table cannot.

A pivot table provides summary results on groups of information; a Filter shows only rows in some group.

A pivot table provides more detailed information than a Filter.

12. Should a spreadsheet list contain any blank rows?

Yes, between groups of records.

Yes, blank rows should contain borders.

No, blank rows should only surround the list.

No, blank rows should be isolated to the definitions.

13. The _____ function allows you to use criteria such as greater than, less than, and so on, to create a sublist of required elements.

Basic Filter

Custom Filter

Goal Seek

Conditional formatting

14. In a list made using spreadsheet software, which of the following would be a label?

An entry made in the third row of the first column.

An entry made in the third row of the third column.

An entry made in the first row of the third column.

An entry made in the last row of the first column.

15. _____ allows you to hide all the rows in a list except those that match criteria, besides "is equal to", you specify.

Goal Seek

Basic Filter

Custom Filter

Conditional formatting

16. Which spreadsheet term defines a collection of information arranged in columns and rows?

Catalog

Inventory

List

Directory

17. When you drop information into the "Values" area in the lower-right corner of the skeletal structure of a pivot table, the default aggregation of summarization is ____.

Summation

Division

Count

Average

18. Which of the following is true of lists?

A list can only contain numerical information (except for labels).

A list does not usually contain a label for the first column.

A list does not require a blank line above it if it starts from the first row.

A list must not have a blank row unless it contains verbal information.

19. Which spreadsheet feature allows you to hide rows in a list?

Conditional formatting

AutoFilter

Pivot table

Data analysis

20. Which of the following represents the steps for selecting the Goal Seek tool?

On the menu bar, click on Value Field Settings, click on Count, and select Goal Seek.

On the menu bar, click on Insert, and select Goal Seek.

On the menu bar, click on Data, then click on What-if Analysis, and select Goal Seek.

On the menu bar, click on Home, click on Conditional Formatting, and select Goal Seek.

21. Which of the following elements of the skeletal structure of a pivot table provides a three-dimensional aspect to the pivot table?

PivotTable Field List

"Report Filter" area

"Row Labels" area

"Column Labels" area

22. _____ is an Excel function which allows you to view the entire list while having certain information called to your attention.

Basic Filter

Custom Filter

Conditional formatting

Goal Seek

23. A list definition table:

Creates sublists using exact match criteria.

Highlights the information in a cell that meets some criteria you specify.

Describes a list by column.

24. In the skeletal structure of a pivot table, the _____ area is where you will drop a field of information to create pages or layers.

PivotTable Field List

Report Filter

Column Labels

Row Labels

25. Which of the following is an action which needs to be performed before using the Goal Seek tool?

Creation of a worksheet that includes an objective based on some unknown value in a cell.

Creation of dimensions of information by specifying how information is to be summarized by dimension.

Entering specific criteria by which a sublist can be created containing only desired information.

26. Which of the following is a characteristic that a list must possess?

Each row must have only one type of information.

The first column in the list must contain the labels or column headings.

The list must not contain any blank columns.

The list must be bordered on all four sides by blank rows and blank columns.

27. In the skeletal structure of a pivot table, the _____ is the list of fields in the original table that you can work with.

Filter Field Area

Column and Row Field List

PivotTable Field List

PivotTable Labels Area

Module D