Question 1

In the figure above, the 300 indicates the amount. Records with the following values meet the criteria: ____.

Accepted Answer

A)  $298 
B)  $299 
C)  $300 
D)  $301 
A)  $298 
B)  $299 
C)  $300 
D)  $301 D

Question 2

A(n) ____________________ is an interactive table that enables you to group and summarize an Excel list into a concise, tabular format for easier reporting and analysis.

Accepted Answer

PivotTable

Question 3

The fields you use to order your data are called sort ____.

Accepted Answer

A)  values 
B)  fields 
C)  tags 
D)  tools 
A)  values 
B)  fields 
C)  tags 
D)  tools B

Question 4

____ order arranges labels in reverse alphabetical order, from A to Z

Accepted Answer

A)  Reverse 
B)  Major 
C)  Ascending 
D)  Descending 
A)  Reverse 
B)  Major 
C)  Ascending 
D)  Descending

Question 5

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

Accepted Answer

A)  CATEGORY 
B)  VIEW 
C)  DATA 
D)  HOME 
A)  CATEGORY 
B)  VIEW 
C)  DATA 
D)  HOME

Question 6

On the bottom-right corner of the figure above, there are four squares labeled FILTER, COLUMNS, ROWS, and VALUES. These four areas represent the ____ of the PivotTable.

Accepted Answer

A)  files 
B)  categories 
C)  segments 
D)  layout 
A)  files 
B)  categories 
C)  segments 
D)  layout

Question 7

The ____ criteria filter requires the records displayed to have the current date.

Accepted Answer

A)  Current Date 
B)  This Date 
C)  This 
D)  Today 
A)  Current Date 
B)  This Date 
C)  This 
D)  Today

Question 8

By default, the PivotTable report uses the ____ function for numbers in the Values area.

Accepted Answer

A)  COUNT 
B)  AVERAGE 
C)  MIN 
D)  SUM 
A)  COUNT 
B)  AVERAGE 
C)  MIN 
D)  SUM

Question 9

Case-Based Critical Thinking Questions
Case 5-1
You are a student who is new to the more advanced features of Excel.
You have a lot of familiarity with ranges from an earlier Excel class, but you know that there is an alternative that will give you access to additional features that you do not have with a cell range. What is that option?

Accepted Answer

A)  Convert the range to a table. 
B)  Convert the range to an index. 
C)  Convert the range to a PivotChart. 
D)  You are wrong; the range has as many features as any Excel alternative. 
A)  Convert the range to a table. 
B)  Convert the range to an index. 
C)  Convert the range to a PivotChart. 
D)  You are wrong; the range has as many features as any Excel alternative.

Question 10

Case-Based Critical Thinking Questions
Case 5-1
You are a student who is new to the more advanced features of Excel.
Which of the following is true about Excel tables (as opposed to structured ranges of data)?

Accepted Answer

A)  You cannot format quickly using a table style. 
B)  You cannot enter a formula in one table cell that is automatically copied to all other cells in that table column. 
C)  You cannot add new rows and columns that automatically expand the range. 
D)  You cannot freeze the top row of the worksheet. 
A)  You cannot format quickly using a table style. 
B)  You cannot enter a formula in one table cell that is automatically copied to all other cells in that table column. 
C)  You cannot add new rows and columns that automatically expand the range. 
D)  You cannot freeze the top row of the worksheet.

Question 11

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

Accepted Answer

A)  Hiding 
B)  Freezing 
C)  Showing 
D)  Sealing 
A)  Hiding 
B)  Freezing 
C)  Showing 
D)  Sealing

Question 12

When you delete a record from a table, a dialog box displays to confirm the delete operation.

Accepted Answer

A) True 
 B)False

Question 13

If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1.

Accepted Answer

A) True 
 B)False

Question 14

In PivotTable terminology, the fields that you summarize are known as ____________________ fields.

Accepted Answer

The answer of In PivotTable terminology, the fields that you...

Question 15

You can use a table's sizing handle to add columns or rows to a table.

Accepted Answer

A) True 
 B)False

Question 16

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion.

Accepted Answer

A) True 
 B)False

Question 17

You can create at most one Excel table in a worksheet.

Accepted Answer

A) True 
 B)False

Question 18

Records have been filtered in the list shown in the accompanying figure.

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Used to group and summarize a list into a concise, tabular format

Accepted Answer

The Answer of custom list and data definition table and is...

Question 20

You can drag one field to the FILTERS area of the PivotTable Fields pane to 
change what values are displayed in the PivotTable.

Accepted Answer

A) True 
 B)False

In the figure above, the 300 indicates the amount. Records with the following values meet the criteria: ____.

A(n) ____________________ is an interactive table that enables you to group and summarize an Excel list into a concise, tabular format for easier reporting and analysis.

The fields you use to order your data are called sort ____.

____ order arranges labels in reverse alphabetical order, from A to Z

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

On the bottom-right corner of the figure above, there are four squares labeled FILTER, COLUMNS, ROWS, and VALUES. These four areas represent the ____ of the PivotTable.

The ____ criteria filter requires the records displayed to have the current date.

By default, the PivotTable report uses the ____ function for numbers in the Values area.

Case-Based Critical Thinking Questions Case 5-1 You are a student who is new to the more advanced features of Excel. Which of the following is true about Excel tables (as opposed to structured ranges of data)?

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

When you delete a record from a table, a dialog box displays to confirm the delete operation.

If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1.

In PivotTable terminology, the fields that you summarize are known as ____________________ fields.

You can use a table's sizing handle to add columns or rows to a table.

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion.

You can create at most one Excel table in a worksheet.

Records have been filtered in the list shown in the accompanying figure.

You can drag one field to the FILTERS area of the PivotTable Fields pane to change what values are displayed in the PivotTable.

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

In the figure above, the 300 indicates the amount. Records with the following values meet the criteria: ____.

A(n) ____________________ is an interactive table that enables you to group and summarize an Excel list into a concise, tabular format for easier reporting and analysis.

The fields you use to order your data are called sort ____.

____ order arranges labels in reverse alphabetical order, from A to Z

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

On the bottom-right corner of the figure above, there are four squares labeled FILTER, COLUMNS, ROWS, and VALUES. These four areas represent the ____ of the PivotTable.

The ____ criteria filter requires the records displayed to have the current date.

By default, the PivotTable report uses the ____ function for numbers in the Values area.

Case-Based Critical Thinking Questions Case 5-1 You are a student who is new to the more advanced features of Excel. Which of the following is true about Excel tables (as opposed to structured ranges of data)?

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

When you delete a record from a table, a dialog box displays to confirm the delete operation.

If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1.

In PivotTable terminology, the fields that you summarize are known as ____________________ fields.

You can use a table's sizing handle to add columns or rows to a table.

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion.

You can create at most one Excel table in a worksheet.

Records have been filtered in the list shown in the accompanying figure.

You can drag one field to the FILTERS area of the PivotTable Fields pane to change what values are displayed in the PivotTable.

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