Deck 6: Analyze Data Using Tables

Question 1

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

A)PivotTables are useful when working with a huge table of data.
B)PivotTables are useful when looking for trends.
C)PivotTables are useful for summarizing data.
D)PivotTables are useful for to consolidate multi-worksheet data.

Answer 1

D

Question 2

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

A)Delete
B)Clear
C)Remove
D)Cancel

Answer 2

B

Question 3

All of the following statements are TRUE regarding slicers EXCEPT:

A)Slicers were introduced in Excel 2007 as an interactive way to filter PivotTable data.
B)In Excel 2013, slicers can now also be used to filter data in Excel tables, query tables, and other data tables.
C)One of the benefits to using slicers is that they are easy to generate and use.
D)Slicers indicate the current filter so you will know exactly what data you are viewing.

Answer 3

A

Question 4

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

A)Home
B)Insert
C)Data
D)Design

Question 5

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

A)automatically adjust table formatting and formula references
B)provide both flexibility and scalability
C)automatically sort data in table columns
D)help provide context to the user by organizing data in a meaningful way

Question 6

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

A)IF
B)SUM
C)AVERAGE
D)COUNT

Question 7

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

A)Convert to Data
B)Convert to Range
C)Convert to Information
D)Convert to Cells

Question 8

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

A)DataTables
B)PivotTables
C)ValueTables
D)VariableTables

Question 9

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

A)Keep a backup of original data.
B)Whenever possible, keep data and the analysis of that data on the same worksheet.
C)Check data for completeness and accuracy.
D)Organize data within a workbook in a meaningful manner.

Question 10

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

A)Alt
B)Ctrl + Alt
C)Ctrl
D)Ctrl + Shift

Question 11

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

A)Raw data may be numeric or text.
B)Raw data without context is meaningless to users.
C)Information is another name for data.
D)Raw data is unorganized.

Question 12

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

A)This argument informs Excel which function to use on the subset of records.
B)One set of function_num values will include both filtered and hidden data.
C)One set of function_num values will include only filtered data.
D)One set of function_num values will include only hidden data.

Question 13

Which of the following statements about filtering is NOT TRUE?

A)Filtering makes it possible to view specific data.
B)The filtering function can be applied to only one data set on a worksheet.
C)Filters can only be established on an Excel table.
D)Filtering enables a user to examine and analyze a subset of records.

Question 14

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

A)SUM
B)TOTAL
C)SUBTOTAL
D)SUMMARY

Question 15

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

A)Information
B)Raw data
C)A data element
D)A variable set

Question 16

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

A)advanced
B)enhanced
C)standard
D)additional

Question 17

All of the following statements are TRUE regarding PivotTables EXCEPT:

A)Multiple PivotTables are allowed on one worksheet for comparison and analysis purposes.
B)Prior to creating a PivotTable, any desired calculated fields should be added.
C)PivotTables can be created on a new worksheet or an existing worksheet.
D)PivotTables automatically expand and contract on a worksheet as variables are added, removed, or rearranged.

Question 18

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

A)Advanced
B)Enhanced
C)Standard
D)Additional

Question 19

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.

A)Home
B)Insert
C)Data
D)Design

Question 20

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

A)Information sets
B)Variable sets
C)Data sets
D)Field sets

Question 21

Which of the following statements regarding PivotTables is NOT TRUE?

A)When there are a lot of groups within a field, it is better to put those fields along the row side of the PivotTable.
B)There are three context-sensitive tabs associated with PivotTables.
C)Typically the contents of a PivotTable should go down more than across.
D)Fields for PivotTable grouping could be all in the Rows area, all in the Columns area, or a mixture.

Question 22

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

A)Column Labels
B)Row Labels
C)Values
D)Variables

Question 23

________ variables are data that can be aggregated by summing,counting,or averaging.

A)Aggregate
B)Category
C)Grouping
D)Summary

Question 24

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

A)selector
B)sifter
C)slicer
D)strainer

Question 25

All of the following statements are TRUE regarding PivotCharts EXCEPT:

A)Once a PivotChart is created, all formatting elements from a regular chart are no longer available.
B)When the PivotTable data are rearranged, they are automatically updated in the PivotChart.
C)When making changes to the PivotChart the corresponding changes are seen in the PivotTable.
D)PivotCharts provide a visual representation of the data in a PivotTable.

Question 26

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

A)Aggregate
B)Category
C)Grouping
D)Summary

Question 27

The ________ feature located on the PivotTable Analyze tab offers a list of options for summarizing its data values.

A)Group Values By
B)Summarize Values By
C)Aggregate Values By
D)Update Values By

Question 28

Which of the following options is NOT listed in the Create PivotTable dialog box?

A)Select a table or range
B)New Workbook
C)Use an external data source
D)New Worksheet

Question 29

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

A)grand total
B)count
C)average
D)subtotal

Question 30

________ 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.

A)PivotChartData connection
B)Data linking
C)Drilling down
D)Content relating

Question 31

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

A)aggregate
B)category
C)grouping
D)summary

Question 32

Gender and dates are two examples of PivotTable ________ variables.

A)aggregate
B)category
C)grouping
D)summary

Question 33

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

A)Layout
B)Options
C)Design
D)Format

Question 34

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

A)Value Field Settings
B)Format Data
C)Data Settings
D)Format Fields

Question 35

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

A)Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate.
B)Once you have selected your data, ensure the source data are arranged in an area with column headings representing each field and the rows representing each record.
C)Distinguish fields as either grouping variables or slicer variables.
D)Know who your audience is prior to developing your PivotTable or PivotChart. It could make a difference in how much detail you display.

Question 36

________ 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.

A)PivotTable
B)PivotChart
C)Slicer
D)PowerPivot

Question 37

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

A)Grouping variables are placed along the top or the left side of the PivotTable.
B)The summary variables are positioned in the VALUES area below the PivotTable Fields list.
C)The grouping variables are positioned in the COLUMNS or ROWS areas at the top of the PivotTable Fields pane.
D)Dates are great for grouping into months, quarters, and years to explore trends over time.

Question 38

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

A)Home
B)Insert
C)Design
D)Layout

Question 39

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

A)Layout and Design
B)Design and Analyze
C)Options and Layout
D)Layout and Format

Question 40

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

A)Redo
B)Refresh
C)Update
D)Renew

Question 41

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

Question 42

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.

Question 43

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

Question 44

Because of the way that Excel is configured,table names can include spaces.

Question 45

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

Question 46

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.

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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.

Question 52

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

Question 53

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

Question 54

Standard functions can be applied to filtered data.

Question 55

Raw data without context is of minimal value to users.

Question 56

In Excel 2013,slicers can be used to filter data in PivotTables,Excel tables,query tables,and other data tables.

Question 57

A filter is a standard part of an Excel table.

Question 58

Quick backups performed on a regular basis are sufficient to protect your original data.

Question 59

Functions like SUM or AVERAGE aggregate an entire set of data.

Question 60

When adding columns and records to an Excel table,Excel automatically adjusts the named ranges that are associated with the table to include the new records.

Question 61

Convert to ________ located on the Design tab is used to convert a table to data.

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

Users can change the look of an existing table through the Style gallery located on the ________ tab.

Question 69

________ is a process of hiding records that do not meet specified criteria in a data set.

Question 70

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

Question 71

A(n)________ of original data should be made so it is possible to return to the original data should errors occur.

Question 72

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

Question 73

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

Question 74

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

Question 75

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.

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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