Question 1

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 2

When you create a PivotTable , you need to specify where to find the data for the  PivotTable. ____________________

Accepted Answer

A) True 
 B)False

Question 3

To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.

Accepted Answer

A) Design 
B) Home 
C) Insert 
D) View 
A) Design 
B) Home 
C) Insert 
D) View

Question 4

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

Question 5

When you create a table, if your data does not contain column headers, Excel adds headers with default names.

Accepted Answer

A) True 
 B)False

Question 6

The ____ criteria filter requires the records displayed to start with the specified text string.

Accepted Answer

A) Origin 
B) Begins With 
C) Initial 
D) Start 
A) Origin 
B) Begins With 
C) Initial 
D) Start

Question 7

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 8

A data ____ table describes the fields you plan to maintain in a table.

Accepted Answer

A) structure 
B) definition 
C) map 
D) linked 
A) structure 
B) definition 
C) map 
D) linked

Question 9

Case-Based Critical Thinking Questions Case 5-2 Cali has just discovered the power of using text filters to control which records display in his worksheet, and he has begun to use them often to find precisely the records he needs. The following questions are based on a camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number. If Cali wants to find all of his campers named Cathy, Carla, and Carey, what should she do?

Accepted Answer

A) Create a text filter using the Begins With operator to display all records that have Ca at the beginning of the text value. 
B) Create a text filter using the Contains operator to display all records that have Ca at the beginning of the text value. 
C) Create a text filter using the Begins With operator to display all records that have Car at the beginning of the text value. 
D) Create a text filter using the Contains operator to display all records that include Ca in the text value. 
A) Create a text filter using the Begins With operator to display all records that have Ca at the beginning of the text value. 
B) Create a text filter using the Contains operator to display all records that have Ca at the beginning of the text value. 
C) Create a text filter using the Begins With operator to display all records that have Car at the beginning of the text value. 
D) Create a text filter using the Contains operator to display all records that include Ca in the text value.

Question 10

To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab.

Accepted Answer

A) Expand for Calculation 
B) Convert to Range 
C) Summary 
D) Function 
A) Expand for Calculation 
B) Convert to Range 
C) Summary 
D) Function

Question 11

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

Accepted Answer

A) True 
 B)False

Question 12

Case-Based Critical Thinking Questions Case 5-2 Cali has just discovered the power of using text filters to control which records display in his worksheet, and he has begun to use them often to find precisely the records he needs. The following questions are based on a camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number. To find anyone whose Camp is either Day Camp , or Overnight Camp , or Nature Camp , what should he do?

Accepted Answer

A) Create a text filter using the Contains operator to display all records that have Nature anywhere in the text value. 
B) Create a text filter using the Ends With operator to display all records that have Day as the last characters in the text value. 
C) Create a text filter using the Begins With operator to display all records that have Overnight as the first characters in the text value. 
D) Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value. 
A) Create a text filter using the Contains operator to display all records that have Nature anywhere in the text value. 
B) Create a text filter using the Ends With operator to display all records that have Day as the last characters in the text value. 
C) Create a text filter using the Begins With operator to display all records that have Overnight as the first characters in the text value. 
D) Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.

Question 13

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

The answer of A(n)____________________ is an interactive table that enables...

Question 14

When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.

Accepted Answer

A) menu 
B) status bar 
C) wizard 
D) dialog box 
A) menu 
B) status bar 
C) wizard 
D) dialog box

Question 15

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

Which of the following is a valid table name?

When you create a PivotTable , you need to specify where to find the data for the PivotTable. ____________________

To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.

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

When you create a table, if your data does not contain column headers, Excel adds headers with default names.

The ____ criteria filter requires the records displayed to start with the specified text string.

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)?

A data ____ table describes the fields you plan to maintain in a table.

To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

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.

When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.

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

Access 1: Creating Advanced Queries and Enhancing Table Design

Access 2: Using Form Tools and Creating Custom Forms

Access 3: Creating Custom Reports

Access 4: Sharing Integrating and Analyzing Data

Excel 2: Managing Multiple Worksheets and Workbooks

Excel 3: Developing an Excel Application

Excel 4: Working With Advanced Functions

Powerpoint 1: Applying Advanced Formatting to Objects

Powerpoint 2: Advanced Animations and Distributing Presentations

Productivity Apps for School and Work Angel

Word 1: Working With Templates Themes and Styles

Word 2: Using Mail Merge

Word 3: Collaborating With Others and Integrating Data

Filters

Exam 5: Excel 1: Working With Excel Tables Pivottables and Pivotcharts

Which of the following is a valid table name?

When you create a PivotTable , you need to specify where to find the data for the PivotTable. ____________________

To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.

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

When you create a table, if your data does not contain column headers, Excel adds headers with default names.

The ____ criteria filter requires the records displayed to start with the specified text string.

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)?

A data ____ table describes the fields you plan to maintain in a table.

To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

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.

When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.

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

Access 1: Creating Advanced Queries and Enhancing Table Design

Access 2: Using Form Tools and Creating Custom Forms

Access 3: Creating Custom Reports

Access 4: Sharing Integrating and Analyzing Data

Excel 2: Managing Multiple Worksheets and Workbooks

Excel 3: Developing an Excel Application

Excel 4: Working With Advanced Functions

Powerpoint 1: Applying Advanced Formatting to Objects

Powerpoint 2: Advanced Animations and Distributing Presentations

Productivity Apps for School and Work Angel

Word 1: Working With Templates Themes and Styles

Word 2: Using Mail Merge

Word 3: Collaborating With Others and Integrating Data

Filters