Question 1

You should ____ the field names to make it easier to Excel to distinguish between the data in the list and the field names.

Accepted Answer

A) boldface 
B) change the font of 
C) use a different color for 
D) any of the above 
A) boldface 
B) change the font of 
C) use a different color for 
D) any of the above D

Question 2

The item marked 5 in the accompanying figure is a box for specifying a second condition for the ____________________.

Accepted Answer

filter

Question 3

Match between columns
                        Premises: A column within an Excel range

Accepted Answer

The Answer of filter and PivotTable and record and criteria is...

Question 4

Excel displays ____ to indicate which rows and columns are frozen.

Accepted Answer

A) dark horizontal and vertical lines 
B) marquees 
C) different font colors 
D) hyperlinks 
A) dark horizontal and vertical lines 
B) marquees 
C) different font colors 
D) hyperlinks

Question 5

The QuickFix button shown in the accompanying figure enables you to undo table formatting if for example you had not intended new data to be part of an existing table.

Accepted Answer

A) True 
 B)False

Question 6

The item marked 2 in the accompanying figure is the ____ for the first condition.

Accepted Answer

A) criterion 
B) operator 
C) handle 
D) pivot point 
A) criterion 
B) operator 
C) handle 
D) pivot point

Question 7

The PivotTable Field List enables you to change or pivot the view of the data in the PivotTable by dragging the field buttons to different areas in the layout section.

Accepted Answer

A) True 
 B)False

Question 8

After Excel displays an existing entry in the column that matches the characters you typed press the ____ key to accept the entry.

Accepted Answer

A) Shift 
B) Tab 
C) Esc 
D) Alt 
A) Shift 
B) Tab 
C) Esc 
D) Alt

Question 9

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 10

You can use the ____ tab to change the SUM function to a different summary function in a PivotTable.

Accepted Answer

A) New Function 
B) Change Function 
C) Summarize by 
D) Summary function 
A) New Function 
B) Change Function 
C) Summarize by 
D) Summary function

Question 11

The ____ filtering option displays the top or bottom n items in a list.

Accepted Answer

A) Bottom 10 
B) Top 10 
C) Custom 
D) All 
A) Bottom 10 
B) Top 10 
C) Custom 
D) All

Question 12

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 13

Ascending order arranges labels alphabetically from A to Z.

Accepted Answer

A) True 
 B)False

Question 14

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 15

You can format cells in a PivotTable the same way as you do cells in the worksheet

Accepted Answer

A) True 
 B)False

Question 16

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 17

Match between columns
                        Premises: Groups and summarizes a list into a concise tabular format

Accepted Answer

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

Question 18

When you filter your data all records that do not meet your criteria are temporarily hidden from view.

Accepted Answer

A) True 
 B)False

Question 19

The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet.

Accepted Answer

A) Expansion 
B) Outline 
C) Summary 
D) Function 
A) Expansion 
B) Outline 
C) Summary 
D) Function

Question 20

You can point to any style in a gallery to see a ____ of the PivotTable with that style applied.

Accepted Answer

A) Demo 
B) AutoView 
C) Live Preview 
D) Snapshot 
A) Demo 
B) AutoView 
C) Live Preview 
D) Snapshot

You should ____ the field names to make it easier to Excel to distinguish between the data in the list and the field names.

The item marked 5 in the accompanying figure is a box for specifying a second condition for the ____________________.

Excel displays ____ to indicate which rows and columns are frozen.

The QuickFix button shown in the accompanying figure enables you to undo table formatting if for example you had not intended new data to be part of an existing table.

The item marked 2 in the accompanying figure is the ____ for the first condition.

The PivotTable Field List enables you to change or pivot the view of the data in the PivotTable by dragging the field buttons to different areas in the layout section.

After Excel displays an existing entry in the column that matches the characters you typed press the ____ key to accept the entry.

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

You can use the ____ tab to change the SUM function to a different summary function in a PivotTable.

The ____ filtering option displays the top or bottom n items in a list.

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

Ascending order arranges labels alphabetically from A to Z.

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.

You can format cells in a PivotTable the same way as you do cells in the worksheet

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

When you filter your data all records that do not meet your criteria are temporarily hidden from view.

The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet.

You can point to any style in a gallery to see a ____ of the PivotTable with that style applied.

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

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Excel: Developing an Excel Application

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters

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

You should ____ the field names to make it easier to Excel to distinguish between the data in the list and the field names.

The item marked 5 in the accompanying figure is a box for specifying a second condition for the ____________________.

Excel displays ____ to indicate which rows and columns are frozen.

The QuickFix button shown in the accompanying figure enables you to undo table formatting if for example you had not intended new data to be part of an existing table.

The item marked 2 in the accompanying figure is the ____ for the first condition.

The PivotTable Field List enables you to change or pivot the view of the data in the PivotTable by dragging the field buttons to different areas in the layout section.

After Excel displays an existing entry in the column that matches the characters you typed press the ____ key to accept the entry.

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

You can use the ____ tab to change the SUM function to a different summary function in a PivotTable.

The ____ filtering option displays the top or bottom n items in a list.

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

Ascending order arranges labels alphabetically from A to Z.

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.

You can format cells in a PivotTable the same way as you do cells in the worksheet

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

When you filter your data all records that do not meet your criteria are temporarily hidden from view.

The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet.

You can point to any style in a gallery to see a ____ of the PivotTable with that style applied.

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

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Excel: Developing an Excel Application

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters