Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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 
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 10

Match between columns
                        Premises: Options tab [PivotTables Tools]
Data
Formulas tab
Design tab [Table Tools]
Insert tab

Accepted Answer

The Answer of Summarize with PivotTable and Table and Name is...

Question 11

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

Accepted Answer

The answer of Pressing ________ allows you to select multiple...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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.

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The answer of ________ is created by users when they...

Question 18

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

Accepted Answer

The answer of Convert to ________ located on the Design...

Question 19

When Advanced Filter is run,the filter ________ disappear from the field headings

Accepted Answer

The answer of When Advanced Filter is run,the filter ________...

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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

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

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

It is recommended to use the standard formatting techniques found on the HOME tab 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 ________.

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

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

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

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

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.

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

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.

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

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

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

When Advanced Filter is run,the filter ________ disappear from the field headings

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

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 6: Analyze Data Using Tables

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

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

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

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

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

It is recommended to use the standard formatting techniques found on the HOME tab 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 ________.

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

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

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

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

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.

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

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.

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

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

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

When Advanced Filter is run,the filter ________ disappear from the field headings

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

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters