Question 1

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

Accepted Answer

The answer of The ____________________ command automatically inserts a subtotal...

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

You can split the worksheet window into ____ separate panes.

Accepted Answer

A)  two or four 
B)  four or six 
C)  six or eight 
D)  between two and eight 
A)  two or four 
B)  four or six 
C)  six or eight 
D)  between two and eight

Question 5

You can access the Sort buttons in the ____ group on the HOME tab by clicking the Sort & Filter button and clicking a sort option.

Accepted Answer

A)  Filtering 
B)  Formatting 
C)  Editing 
D)  Text 
A)  Filtering 
B)  Formatting 
C)  Editing 
D)  Text

Question 6

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

Accepted Answer

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

Question 7

Match between columns
                        Premises: To keep headings visible as you work with the data in a large worksheet

Accepted Answer

The Answer of field and field name and freeze and is...

Question 8

With the Last Quarter criteria filter, quarters are defined as, for example, ____.

Accepted Answer

A)  April, May, June 
B)  March, April, May 
C)  May, June, July 
D)  March, April, May, June 
A)  April, May, June 
B)  March, April, May 
C)  May, June, July 
D)  March, April, May, June

Question 9

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.
Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?

Accepted Answer

A)  He would develop a PivotTable using the aggregate filter. 
B)  He would develop a PivotTable using the report filter. 
C)  He would develop a PivotTable using the category filter. 
D)  He would develop a PivotTable using the value filter. 
A)  He would develop a PivotTable using the aggregate filter. 
B)  He would develop a PivotTable using the report filter. 
C)  He would develop a PivotTable using the category filter. 
D)  He would develop a PivotTable using the value filter.

Question 10

Table names cannot include underscores .

Accepted Answer

A) True 
 B)False

Question 11

You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

Accepted Answer

A)  HOME 
B)  VIEW 
C)  TABLE TOOLS DESIGN 
D)  PIVOTTABLE 
A)  HOME 
B)  VIEW 
C)  TABLE TOOLS DESIGN 
D)  PIVOTTABLE

Question 12

Every ____ consists of an object that contains a button for each unique value in that field.

Accepted Answer

A)  piece 
B)  slicer 
C)  section 
D)  part 
A)  piece 
B)  slicer 
C)  section 
D)  part

Question 13

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 14

The process of hiding certain records and viewing the ones you want is called ____________________ your data.

Accepted Answer

The answer of The process of hiding certain records and...

Question 15

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 16

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

Accepted Answer

A)  Year to Date 
B)  Today 
C)  Current 
D)  none of the above 
A)  Year to Date 
B)  Today 
C)  Current 
D)  none of the above

Question 17

To freeze a row, select the cell below the row(s) you want to freeze, click the ____________________ button in the Window group and then click Freeze Top Row.

Accepted Answer

The answer of To freeze a row, select the cell...

Question 18

Match between columns
                        Premises: Enables you to specify various conditions in addition to those that are based on an "equals" criterion

Accepted Answer

The Answer of criteria filter and freeze and data definition is...

Question 19

Match between columns
                        Premises: A column within an Excel range

Accepted Answer

The Answer of criteria filter and sort and freeze and is...

Question 20

Excel assigns the name ____ to the first Excel table created in a workbook.

Accepted Answer

A)  1 
B)  1Table 
C)  NewTable 
D)  Table1 
A)  1 
B)  1Table 
C)  NewTable 
D)  Table1

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

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

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

You can split the worksheet window into ____ separate panes.

You can access the Sort buttons in the ____ group on the HOME tab by clicking the Sort & Filter button and clicking a sort option.

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

With the Last Quarter criteria filter, quarters are defined as, for example, ____.

Table names cannot include underscores .

You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

Every ____ consists of an object that contains a button for each unique value in that field.

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

The process of hiding certain records and viewing the ones you want is called ____________________ your data.

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

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

To freeze a row, select the cell below the row(s) you want to freeze, click the ____________________ button in the Window group and then click Freeze Top Row.

Excel assigns the name ____ to the first Excel table created in a workbook.

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 ____________________ command automatically inserts a subtotal line into the range for each group of data.

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

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

You can split the worksheet window into ____ separate panes.

You can access the Sort buttons in the ____ group on the HOME tab by clicking the Sort & Filter button and clicking a sort option.

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

With the Last Quarter criteria filter, quarters are defined as, for example, ____.

Table names cannot include underscores .

You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

Every ____ consists of an object that contains a button for each unique value in that field.

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

The process of hiding certain records and viewing the ones you want is called ____________________ your data.

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

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

To freeze a row, select the cell below the row(s) you want to freeze, click the ____________________ button in the Window group and then click Freeze Top Row.

Excel assigns the name ____ to the first Excel table created in a workbook.

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