Exam 5: Working With Excel Tables, Pivot-tables, and Pivot-charts

Explore all topics

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To rearrange records in a table or range based on the data in one or more fields

(Multiple Choice)

4.9/5

(26)

Question 141

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

(Multiple Choice)

4.8/5

(40)

Question 142

-On the bottom-right corner of the figure above,there are four squares labeled Report Filter,Column Labels,Row Labels,and Values.These four areas represent the ____ of the PivotTable.

(Multiple Choice)

4.7/5

(25)

Question 143

What are the guidelines for creating an effective structured range of data?

(Essay)

4.7/5

(43)

Question 144

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

(Multiple Choice)

4.8/5

(36)

Question 145

To get to the screen shown in the figure above,you would click the Insert tab on the Ribbon,and then,in the ____ group,click the PivotTable button.

(Multiple Choice)

4.7/5

(32)

Question 146

Ascending order arranges labels alphabetically from A to Z._________________________

(True/False)

4.9/5

(44)

Question 147

You can change the alignment of the column headings for better placement and readability.

(True/False)

4.7/5

(36)

Question 148

The row of field names across the top of an Excel list is referred to as the header row._________________________

(True/False)

4.9/5

(37)

Question 149

You can display or hide filter arrows for an Excel table or a range of data by using the Filter button in the Sort & Filter group on the View tab._________________________

(True/False)

4.9/5

(35)

Question 150

Showing 141 - 150 of 150

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To rearrange records in a table or range based on the data in one or more fields

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

-On the bottom-right corner of the figure above,there are four squares labeled Report Filter,Column Labels,Row Labels,and Values.These four areas represent the ____ of the PivotTable.

What are the guidelines for creating an effective structured range of data?

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

To get to the screen shown in the figure above,you would click the Insert tab on the Ribbon,and then,in the ____ group,click the PivotTable button.

Ascending order arranges labels alphabetically from A to Z._________________________

You can change the alignment of the column headings for better placement and readability.

The row of field names across the top of an Excel list is referred to as the header row._________________________

You can display or hide filter arrows for an Excel table or a range of data by using the Filter button in the Sort & Filter group on the View tab._________________________

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters