Module D
Final study
- 1.
_____ is an Excel function which allows you to view the entire list while having certain information called to your attention.
- A.
Basic Filter
- B.
Custom Filter
- C.
Conditional formatting
- D.
Goal Seek
Correct Answer
C. Conditional formatting -
- 2.
Which of the following spreadsheet features allows you to quickly create a two-dimensional table with totals for groups of information?
- A.
Goal Seeking
- B.
Pivot table
- C.
Forms
- D.
Groups
Correct Answer
B. Pivot table -
- 3.
To highlight information that meets some criterion that you set, you could use _____ formatting.
- A.
Auto
- B.
Restrictive
- C.
Conditional
- D.
Limited
Correct Answer
C. Conditional -
- 4.
Which of the following is an action which needs to be performed before using the Goal Seek tool?
- A.
Creation of a worksheet that includes an objective based on some unknown value in a cell.
- B.
Creation of dimensions of information by specifying how information is to be summarized by dimension.
- C.
Definitions of the dimensions of a list by dragging and dropping information labels or column headings into the row and column areas of a pivot table.
- D.
Entering specific criteria by which a sublist can be created containing only desired information.
Correct Answer
A. Creation of a worksheet that includes an objective based on some unknown value in a cell. -
- 5.
In the skeletal structure of a pivot table, the _____ area is where you will drop a field of information to create pages or layers.
- A.
PivotTable Field List
- B.
Report Filter
- C.
Column Labels
- D.
Row Labels
Correct Answer
B. Report Filter -
- 6.
What is the difference between a Filter and a pivot table?
- A.
A Filter requires that rows are sorted by a column or group before they are analyzed; a pivot table does not.
- B.
A Filter can analyze dissimilar information; a pivot table cannot.
- C.
A pivot table provides summary results on groups of information; a Filter shows only rows in some group.
- D.
A pivot table provides more detailed information than a Filter.
Correct Answer
C. A pivot table provides summary results on groups of information; a Filter shows only rows in some group. -
- 7.
In a list made using spreadsheet software, which of the following would be a label?
- A.
An entry made in the third row of the first column.
- B.
An entry made in the third row of the third column.
- C.
An entry made in the first row of the third column.
- D.
An entry made in the last row of the first column.
Correct Answer
C. An entry made in the first row of the third column. -
- 8.
Which spreadsheet term defines a collection of information arranged in columns and rows?
- A.
Catalog
- B.
Inventory
- C.
List
- D.
Directory
Correct Answer
C. List -
- 9.
A _____ is a description of a list by column.
- A.
List definition table
- B.
Pivot table
- C.
Feature key
- D.
Column definition
Correct Answer
A. List definition table -
- 10.
When creating a ____, you create dimensions of information by specifying how information is to be summarized by dimension.
- A.
List definition table
- B.
Pivot table
- C.
Worksheet
- D.
Sublist
Correct Answer
B. Pivot table -
- 11.
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 ____.
- A.
Summation
- B.
Division
- C.
Count
- D.
Average
Correct Answer
A. Summation -
- 12.
Which of the following is true of lists?
- A.
A list can only contain numerical information (except for labels).
- B.
A list does not usually contain a label for the first column.
- C.
A list does not require a blank line above it if it starts from the first row.
- D.
A list must not have a blank row unless it contains verbal information.
Correct Answer
C. A list does not require a blank line above it if it starts from the first row. -
- 13.
_____ is an Excel function that works backward from an objective to compute an unknown value.
- A.
Pivot table
- B.
Basic Filter
- C.
Custom Filter
- D.
Goal Seek
Correct Answer
D. Goal Seek -
- 14.
Should a spreadsheet list contain any blank rows?
- A.
Yes, between groups of records.
- B.
Yes, blank rows should contain borders.
- C.
No, blank rows should only surround the list.
- D.
No, blank rows should be isolated to the definitions.
Correct Answer
C. No, blank rows should only surround the list. -
- 15.
_____ highlights the information in a cell that meets some criteria you specify.
- A.
Basic Filter
- B.
Custom Filter
- C.
Goal Seek
- D.
Conditional formatting
Correct Answer
D. Conditional formatting -
- 16.
Which of the following is a characteristic that a list must possess?
- A.
Each row must have only one type of information.
- B.
The first column in the list must contain the labels or column headings.
- C.
The list must not contain any blank columns.
- D.
The list must be bordered on all four sides by blank rows and blank columns.
Correct Answer
D. The list must be bordered on all four sides by blank rows and blank columns. -
- 17.
What is the intersection of a row and column in a spreadsheet called?
- A.
Group
- B.
Block
- C.
Cell
- D.
Object
Correct Answer
C. Cell -
- 18.
Which of the following elements of the skeletal structure of a pivot table provides a three-dimensional aspect to the pivot table?
- A.
PivotTable Field List
- B.
"Report Filter" area
- C.
"Row Labels" area
- D.
"Column Labels" area
Correct Answer
B. "Report Filter" area -
- 19.
Which spreadsheet feature allows you to hide rows in a list?
- A.
Conditional formatting
- B.
AutoFilter
- C.
Pivot table
- D.
Data analysis
Correct Answer
B. AutoFilter -
- 20.
In the skeletal structure of a pivot table, the _____ is the list of fields in the original table that you can work with.
- A.
Filter Field Area
- B.
Column and Row Field List
- C.
PivotTable Field List
- D.
PivotTable Labels Area
Correct Answer
C. PivotTable Field List -
- 21.
_____ allows you to hide all the rows in a list except those that match criteria, besides "is equal to", you specify.
- A.
Goal Seek
- B.
Basic Filter
- C.
Custom Filter
- D.
Conditional formatting
Correct Answer
C. Custom Filter -
- 22.
The _____ function allows you to use criteria such as greater than, less than, and so on, to create a sublist of required elements.
- A.
Basic Filter
- B.
Custom Filter
- C.
Goal Seek
- D.
Conditional formatting
Correct Answer
B. Custom Filter -
- 23.
Which of the following enables you to group and summarize information?
- A.
Pivot table
- B.
Conditional formatting
- C.
Basic Filter
- D.
Custom Filter
Correct Answer
A. Pivot table -
- 24.
Which of the following spreadsheet features allows you to show only rows from a list that meets a specific condition?
- A.
Filter
- B.
AutoMatch
- C.
Goal Seek
- D.
Group
Correct Answer
A. Filter -
- 25.
Which of the following represents the steps for selecting the Goal Seek tool?
- A.
On the menu bar, click on Value Field Settings, click on Count, and select Goal Seek.
- B.
On the menu bar, click on Insert, and select Goal Seek.
- C.
On the menu bar, click on Data, then click on What-if Analysis, and select Goal Seek.
- D.
On the menu bar, click on Home, click on Conditional Formatting, and select Goal Seek.
Correct Answer
C. On the menu bar, click on Data, then click on What-if Analysis, and select Goal Seek. -
- 26.
Regardless of how one uses the Filter function, Excel _____ rows that one does not want to see.
- A.
Deletes
- B.
Eliminates from the sublist
- C.
Does not include in the new table
- D.
Hides
Correct Answer
D. Hides -
- 27.
A list definition table:
- A.
Filters a list and allows you to hide all the rows in a list except those that match criteria you specify.
- B.
Creates sublists using exact match criteria.
- C.
Highlights the information in a cell that meets some criteria you specify.
- D.
Describes a list by column.
Correct Answer
D. Describes a list by column. -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 07, 2013Quiz Edited by
ProProfs Editorial Team -
Dec 04, 2012Quiz Created by
Olgerthasko
- Academic Quizzes
- Adult Learning Quizzes
- Blended Learning Quizzes
- Coaching Quizzes
- College Quizzes
- Communication Quizzes
- Curriculum Quizzes
- Distance Learning Quizzes
- E Learning Quizzes
- Early Childhood Education Quizzes
- GCSE Quizzes
- Grade Quizzes
- Graduation Quizzes
- Kindergarten Quizzes
- Knowledge Quizzes
- Literacy Quizzes
- Physical Education Quizzes
- Qualification Quizzes
- Religious Education Quizzes
- School Quizzes
- Special Education Quizzes
- Student Quizzes
- Study Quizzes
- Subject Quizzes
- Teaching Quizzes
- Theory Quizzes
- Thesis Quizzes
- University Quizzes
Back to top