business analytics excel chapter 6

Which of the following is NOT an area in the Fields areas?

LIST

All of the following statements are TRUE regarding PivotCharts EXCEPT:

Once a PivotChart is created, all formatting elements from a regular chart are no longer available.

Data

Table

Design tab [Table tools]

advanced [filter]

The context-sensitive tabs available to aid in the control of the PivotTable include ________.

analyze and design

of original data should be made so it is possible to return to the original data should errors occur.

backup

________ variables are data that can be aggregated

summary

Blue data is very valuable to everyone.

false

________ is data that has context, meaning, and relevance.

information

After making changes to a source data set, PivotTable data should be refreshed to update the changes in the PivotTable.

true

Any records that should not be used in the SUBTOTAL calculations should be excluded using the filtering process.

true

As columns or rows are added to a table formatted with a banded style, the new columns and rows are automatically formatted to match the banded style.

true

Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate.

true

Functions like SUM or AVERAGE aggregate an entire set of data

true

If a set of data is not organized, it is difficult to transform the data into information.

true

If the criteria range for the Advanced Filter includes a row with no criteria, the entire record set will be returned because nothing is constraining the records.

true

It is better to use PivotTables for multiple purposes than to create a set of separate PivotTables.

true

Raw data without context is of minimal value to users

true

The function_num argument of the SUBTOTAL function can only have entries from 1 to 10 or from 101 to ____

111

When using the ___ Filter feature, filtering criteria must be set up in a specific format

Adavanced

The PivotTable ____ tab has all the options for fine-tuning the PivotTable

Analyze

When using an Excel table, a table can do all of the following EXCEPT

Automatically sort data in table columns

Pressing ___ allows you to select multiple criteria on a slicer

Ctrl

To open the Create PivotTable dialog box, click on the ________ tab, and then click Summarize with PivotTable.

Design

All of the following statements are TRUE regarding PivotTable and PivotChart best practices EXCEPT:

Distinguish fields as slicer variables.

Variables can be thought of as any field within a data set that can be used to categorize for comparison

Grouping

________ variables are fields within a data set that can be used to categorize data for comparison.

Grouping

It is not recommended to use the standard formatting techniques found on the ________ tab with PivotTables.

Home

Which of the following functions is NOT available as an option when selecting the first argument in the SUBTOTAL function?

IF

All of the following statements are TRUE regarding raw data EXCEPT:

Information is another name for data.

All of the following statements are TRUE regarding PivotTables EXCEPT:

Multiple PivotTables are allowed on one worksheet for comparison and analysis purposes.

Format tab

Name Manager

All of the following statements are TRUE regarding the function_num argument of the SUBTOTAL function EXCEPT:

One set of function_num values will include only hidden data.

charts that are field to the data within a Pivot Table

PivotCharts

Which of the following is NOT a benefit of using PivotTables?

PivotTables are useful to consolidate multi-worksheet data

allows a user to import up to one million rows of data from multiple sources, such as large corporate databases, public data feeds, spreadsheets, and text files on your computer.

PowerPivot

The ___ field should give a big picture perspective of the data.

Report Filter

When filtering data, records that are on hidden rows will not automatically be used in the calculation of the___function

SUBTOTAL

The ________ feature offers a list of options for summarizing its data values

Summarize Values By

All of the following statements are TRUE regarding grouping in PivotTables EXCEPT:

The grouping variables are positioned in the COLUMNS or ROWS areas at the top of the PivotTable Fields pane.

Which of the following statements regarding PivotTables is NOT true?

There are three context-sensitive tabs associated with PivotTables.

When creating a PivotTable, fields from the PivotTable Field list entries can be dragged and dropped to each of the following quadrant areas EXCEPT:

Variables

Which of the following should NOT be performed in an effort to protect the integrity of data?

Whenever possible, keep data and the analysis of that data on the same worksheet.

When using the ________ Filter feature in Excel, filtering criteria will be listed on the same worksheet.

advanced

To ___ data means to consolidate or summarize data, and can be accomplished through functions such as SUM and AVERAGE.

aggregate

A table defaults to a table style that has ____ rows, making it easier to read data across rows.

banded

Click ________ in the Sort & Filter group on the Data tab to remove any existing filters that have been applied to a data set on the Excel worksheet

clear

To change a table back to a range of data, click ________ located in the Tools group on the Design tab.

convert to range

Pressing ________ allows you to select multiple criteria on a slicer

ctrl

________ set is the name used for a collection of related sets of information that are composed of separate elements.

data

named collections of related sets of information that are composed of separate elements.

data sets

The PivotTable ____ tab focuses on the appearance aspects of designing a PivotTable

design

The PivotTable ________ tab focuses on formatting and the appearance aspect of designing the PivotTable.

design

________ allows a user to select an individual piece of data in a PivotTable and then create a copy of individual records that were used to get that summary data on another worksheet.

drilling down

a method for accessing the detailed records that were used in a PivotTable to get to the aggregated data

drilling down

Adding new columns and rows in a table requires users to manually adjust formula references within that table.

false

After a table has been converted back to data, the converted data still possesses table functionality.

false

If there are a lot of groups within a field, it is better to put those fields across the top in the columns of a PivotTable instead of along the row side.

false

It is recommended to use the standard formatting techniques found on the Home tab with PivotTables.

false

Pressing Shift allows you to select multiple criteria on a slicer.

false

Standard functions can be applied to filtered data.

false

Table names can include spaces

false

The SUBTOTAL function includes hidden records and only uses visible filtered records to calculate the formula.

false

To edit or view existing named ranges, click the Define Name button on the Formulas tab.

false

Using Excel's Hide Rows command is a required feature when filtering data.

false

When using the SUBTOTAL function, entering a number from 1 to 10 in the SUBTOTAL function's first argument will result in the filtered only data being used.

false

You do not need to have a cell selected in your data table in order to insert a slicer.

false

When Advanced Filter is run, the ___ buttons disappear from the field headings

filter arrow

a process of hiding record that do not meet specified criteria in a data set

filtering

Which of the following statements about filtering is NOT true?

filters can only be established on excel table

By default, PivotTables show a(n) ________ for both columns and rows.

grand total

Gender and dates are two examples of PivotTable ________ variables.

grouping

a method for accessing the detailed records used in a PivotTable to get to the aggregated data

grouping variables

A table can be created by selecting a range on an Excel worksheet, clicking the ________ tab, clicking the Format as Table button, and selecting a table style

home

created by users when they organize data in a meaningful context.

infromation

While it is possible to create multiple PivotTables from the same data set, only ____ Pivot Tables is allowed per worksheet

one

________ are interactive tables that extract, organize, and summarize data.

pivottables

________ allows a user to import up to one million rows of data from multiple sources, such as large corporate databases, public data feeds, spreadsheets, and text files on your computer.

powerpivot

Convert to ____ located on Design tab is used to convert a table to data

range

include elements or facts that may or may not have meaning or relevance.

raw data

Use the ________ button on the Options tab to update PivotTable data changes made to source data.

refresh

A ________ is a visual mechanism for quickly filtering data in a PivotTable.

slicer

A ________ is a window that is used to quickly filter data in an Excel table.

slicer

an object that sits or floats on top of the spreadsheet that lists the data options of a field.

slicer

It is not recommended to use the ___ formatting techniques found on the Home tab with PivotTables

standard

The ___ filter displays the values in the field that can be toggled on and off through the use of check boxes

standard

The ________ filter displays the values in the field that can be toggled on and off through the use of check boxes.

standard

The ________ function will run calculations on data that is in a subset when a filter is applied.

subtotal

Exam scores, quantity, and price are three examples of PivotTable ________ variables.

summary

data that is not categorical in nature and is likely to be used for summarization

summary variables

A filter is a standard part of an Excel table

true

Advanced Filter in Excel provides AND and OR features to join multiple criteria.

true

Multiple data sets that need to be filtered should be placed on separate worksheets.

true

Numerical data placed into the VALUES area of a PivotTable will be summed by default.

true

Slicers can be used to filter data in Excel tables.

true

The filtering feature in Excel is great to perform ad hoc and spur-of-the-moment exploration of data.

true

When PivotTable data are rearranged, corresponding changes are automatically made in the PivotChart.

true

When creating a PivotTable, any existing automatic subtotals or other summary functions at the bottom of the data should be removed.

true

PivotTable data formatted through the ________ dialog box applies to all other cells within the same field.

value field settings

A PivotTable can be created on a new or an existing ____

worksheet