Question 1

Match between columns
                        Premises: A collection of related fields that are grouped together

Accepted Answer

The Answer of field name and criteria filter and custom is...

Question 2

The second sort field in a sort is called the ____________________ field.

Accepted Answer

The answer of The second sort field in a sort...

Question 3

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

Accepted Answer

A)  Or 
B)  Both 
C)  And 
D)  Either 
A)  Or 
B)  Both 
C)  And 
D)  Either

Question 4

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

Accepted Answer

A)  Top 10 
B)  Between 
C)  Aggregate 
D)  Range 
A)  Top 10 
B)  Between 
C)  Aggregate 
D)  Range

Question 5

In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns.

Accepted Answer

A)  index 
B)  glossary 
C)  list 
D)  range 
A)  index 
B)  glossary 
C)  list 
D)  range

Question 6

Which of the following is a valid table name?

Accepted Answer

A)  %_table 
B)  $Table2 
C)  _Newtable 
D)  2Table 
A)  %_table 
B)  $Table2 
C)  _Newtable 
D)  2Table

Question 7

When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data.

Accepted Answer

A)  table 
B)  catalogue 
C)  index 
D)  roster 
A)  table 
B)  catalogue 
C)  index 
D)  roster

Question 8

Match between columns
                        Premises: A unique label that describes the contents of data in a column

Accepted Answer

The Answer of data definition table and record and freeze is...

Question 9

The ____ criteria filter requires the records displayed to have the specified text string anywhere.

Accepted Answer

A)  Has 
B)  Is 
C)  Contains 
D)  Matches 
A)  Has 
B)  Is 
C)  Contains 
D)  Matches

Question 10

Critical Thinking Case-Based Questions
Case 5-3
As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?

Accepted Answer

A)  SUM 
B)  AGGREGATE 
C)  TOTAL 
D)  COUNT 
A)  SUM 
B)  AGGREGATE 
C)  TOTAL 
D)  COUNT

Question 11

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

Accepted Answer

A)  rows and headers 
B)  grids and columns 
C)  rows and columns 
D)  footers and grids 
A)  rows and headers 
B)  grids and columns 
C)  rows and columns 
D)  footers and grids

Question 12

When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.

Accepted Answer

A)  menu 
B)  arrow 
C)  button 
D)  status bar 
A)  menu 
B)  arrow 
C)  button 
D)  status bar

Question 13

Match between columns
                        Premises: Documentation that lists the fields to be maintained for each record

Accepted Answer

The Answer of field name and data definition table and is...

Question 14

When related fields are grouped together in a row, they form a(n) ____________________, a collection of fields that describes a person, place, or thing.

Accepted Answer

The answer of When related fields are grouped together in...

Question 15

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

Accepted Answer

A)  OR 
B)  NAND 
C)  AND 
D)  IF 
A)  OR 
B)  NAND 
C)  AND 
D)  IF

Question 16

In addition to data fields, a PivotTable uses ____________________ fields to group values such as department, model, year, and vehicle type in an automobile-related sheet, for example.

Accepted Answer

The answer of In addition to data fields, a PivotTable...

Question 17

The ____ report layout displays one column for each field and leaves space for column headers.

Accepted Answer

A)  Outline 
B)  Design 
C)  Tabular 
D)  Headers 
A)  Outline 
B)  Design 
C)  Tabular 
D)  Headers

Question 18

You can calculate sort statistics (including sum, average, count, maximum, and minimum) on all the columns in an Excel table.

Accepted Answer

A) True 
 B)False

Question 19

To add a sort field in the Sort dialog box, click the ____ button.

Accepted Answer

A)  Add Level 
B)  Add Field 
C)  New Sort Field 
D)  New Level 
A)  Add Level 
B)  Add Field 
C)  New Sort Field 
D)  New Level

Question 20

Each column represents a record that describes some attribute or characteristic of a person, place, or thing.

Accepted Answer

A) True 
 B)False

The second sort field in a sort is called the ____________________ field.

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns.

Which of the following is a valid table name?

When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data.

The ____ criteria filter requires the records displayed to have the specified text string anywhere.

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.

When related fields are grouped together in a row, they form a(n) ____________________, a collection of fields that describes a person, place, or thing.

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

In addition to data fields, a PivotTable uses ____________________ fields to group values such as department, model, year, and vehicle type in an automobile-related sheet, for example.

The ____ report layout displays one column for each field and leaves space for column headers.

You can calculate sort statistics (including sum, average, count, maximum, and minimum) on all the columns in an Excel table.

To add a sort field in the Sort dialog box, click the ____ button.

Each column represents a record that describes some attribute or characteristic of a person, place, or thing.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 5: Excell: Working With Excel Tables, Pivottables, and Pivotcharts

The second sort field in a sort is called the ____________________ field.

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns.

Which of the following is a valid table name?

When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data.

The ____ criteria filter requires the records displayed to have the specified text string anywhere.

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.

When related fields are grouped together in a row, they form a(n) ____________________, a collection of fields that describes a person, place, or thing.

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

In addition to data fields, a PivotTable uses ____________________ fields to group values such as department, model, year, and vehicle type in an automobile-related sheet, for example.

The ____ report layout displays one column for each field and leaves space for column headers.

You can calculate sort statistics (including sum, average, count, maximum, and minimum) on all the columns in an Excel table.

To add a sort field in the Sort dialog box, click the ____ button.

Each column represents a record that describes some attribute or characteristic of a person, place, or thing.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters