Exam 7: Excell: Creating Pivottables and Pivotcharts

Which of the following is a report that is useful when you want to analyze related totals,such as when you have a long list of numbers to sum and you want to compare several facts about each total?

(Multiple Choice)

4.9/5

(91)

Question 41

Slicers are easy-to-use filtering components that enable you to quickly filter data in a PivotTable report.

(True/False)

4.9/5

(78)

Question 42

A(n)________ is a system of integrating data from multiple and related tables into an Excel worksheet.

(Short Answer)

4.7/5

(88)

Question 43

A PivotChart displays data series,categories,data markers,and axes in the same manner as a standard chart.

(True/False)

4.8/5

(92)

Question 44

An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the ________.

(Multiple Choice)

4.8/5

(88)

Question 45

In the PivotTable field section,you can rearrange existing fields by using which of the following areas in the layout section?

(Multiple Choice)

4.9/5

(87)

Question 46

Which of the following is a button on a PivotChart with an arrow to choose a filter,and thus change the data that is displayed in the chart?

(Multiple Choice)

4.9/5

(78)

Question 47

You can ________ and change the values of the data in the PivotChart report by using the gray field buttons that display on the chart.

(Short Answer)

4.8/5

(77)

Question 48

A slicer includes a ________ that indicates the category of the slicer items.

(Multiple Choice)

4.8/5

(88)

Question 49

A(n)________ is an interactive Excel report that summarizes and analyzes large amounts of data.

(Short Answer)

4.9/5

(63)

Question 50

A chart that illustrates the relationship of each part to a whole is called a ________.

(Multiple Choice)

4.8/5

(73)

Question 51

Match the following terms with their meanings: i.Data Model II.record III.field IV.relationship v.primary key

(Multiple Choice)

4.8/5

(80)

Question 52

In a PivotTable report,the calculations can be modified.

(True/False)

4.7/5

(72)

Question 53

In Microsoft Access,the field used to uniquely identify a record is called a ________.

(Multiple Choice)

5.0/5

(78)

Question 54

A list or table used to create a PivotTable or PivotChart report that comes from an Excel list or external database is called ________.

(Short Answer)

4.7/5

(82)

Question 55

To analyze numeric data in depth and to answer unanticipated questions about worksheet data or an external data source,you can create a PivotTable ________.

(Short Answer)

4.8/5

(62)

Question 56

In Microsoft Access,the field that uniquely identifies a record is the primary key.

(True/False)

4.9/5

(77)

Question 57

An area to position fields that you want to display as rows in the PivotTable reports is called the ________.

(Multiple Choice)

4.8/5

(74)

Question 58

A Microsoft Access database can contain only one table.

(True/False)

4.9/5

(86)

Question 59

A ________ enables you to create PivotTables by using the data from multiple,related tables.

(Short Answer)

4.7/5

(92)

Question 60

Showing 41 - 60 of 91

Which of the following is a report that is useful when you want to analyze related totals,such as when you have a long list of numbers to sum and you want to compare several facts about each total?

Slicers are easy-to-use filtering components that enable you to quickly filter data in a PivotTable report.

A(n)________ is a system of integrating data from multiple and related tables into an Excel worksheet.

A PivotChart displays data series,categories,data markers,and axes in the same manner as a standard chart.

An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the ________.

In the PivotTable field section,you can rearrange existing fields by using which of the following areas in the layout section?

Which of the following is a button on a PivotChart with an arrow to choose a filter,and thus change the data that is displayed in the chart?

You can ________ and change the values of the data in the PivotChart report by using the gray field buttons that display on the chart.

A slicer includes a ________ that indicates the category of the slicer items.

A(n)________ is an interactive Excel report that summarizes and analyzes large amounts of data.

A chart that illustrates the relationship of each part to a whole is called a ________.

Match the following terms with their meanings: i.Data Model II.record III.field IV.relationship v.primary key

In a PivotTable report,the calculations can be modified.

In Microsoft Access,the field used to uniquely identify a record is called a ________.

A list or table used to create a PivotTable or PivotChart report that comes from an Excel list or external database is called ________.

To analyze numeric data in depth and to answer unanticipated questions about worksheet data or an external data source,you can create a PivotTable ________.

In Microsoft Access,the field that uniquely identifies a record is the primary key.

An area to position fields that you want to display as rows in the PivotTable reports is called the ________.

A Microsoft Access database can contain only one table.

A ________ enables you to create PivotTables by using the data from multiple,related tables.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters