Question 1

You can set a keyboard shortcut key combination for executing a macro with an option in the Record Macro dialog box.

Accepted Answer

A) True 
 B)False

Question 2

Power View uses _____ to group data.​

Accepted Answer

A)  ​tiles 
B)  ​measures 
C)  ​formulas 
D)  ​models 
A)  ​tiles 
B)  ​measures 
C)  ​formulas 
D)  ​models

Question 3

Data modelling is the process of creating a _____.​

Accepted Answer

A)  ​workbook 
B)  ​simulation 
C)  ​model 
D)  ​representation 
A)  ​workbook 
B)  ​simulation 
C)  ​model 
D)  ​representation

Question 4

Which of the following are true about macros?

Accepted Answer

A)  They save time 
B)  They ensure consistency 
C)  They automate repetitive tasks 
D)  They reduce formatting conformity 
A)  They save time 
B)  They ensure consistency 
C)  They automate repetitive tasks 
D)  They reduce formatting conformity

Question 5

The MACRO tab on the ribbon includes commands used to work with macros.

Accepted Answer

A) True 
 B)False

Question 6

What does OLAP stand for?​

Accepted Answer

A)  ​Online Linear Application Program 
B)  ​Order Lines Around Pivot 
C)  ​Online Application Power 
D)  ​Online Analytical Processing 
A)  ​Online Linear Application Program 
B)  ​Order Lines Around Pivot 
C)  ​Online Application Power 
D)  ​Online Analytical Processing

Question 7

A macro name can contain numbers and letters but not underscores.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following are interlinked power tools ​used to analyze business data in Excel?

Accepted Answer

A)  ​Power Pivot 
B)  ​3D Maps 
C)  ​Power View 
D)  ​Power BI 
A)  ​Power Pivot 
B)  ​3D Maps 
C)  ​Power View 
D)  ​Power BI

Question 9

If you make a mistake while recording a macro,press the ESC key and repeat the step in error.

Accepted Answer

A) True 
 B)False

Question 10

A macro's steps and their order should be determined and rehearsed after creating the macro.

Accepted Answer

A) True 
 B)False

Question 11

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

Accepted Answer

A) True 
 B)False

Question 12

What is a measure?​

Accepted Answer

A)  ​A calculated named field in Power Pivot. 
B)  ​A special set of functions and commands. 
C)  ​Fields in pivot field lists. 
D)  ​Created aggregate formulas that use one or multiple rows from multiple sources. 
A)  ​A calculated named field in Power Pivot. 
B)  ​A special set of functions and commands. 
C)  ​Fields in pivot field lists. 
D)  ​Created aggregate formulas that use one or multiple rows from multiple sources.

Question 13

You should select the ending cell before turning on the macro recorder.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is the path to the 'Add a Hyperlink' button?

Accepted Answer

Question 15

Why is it called a foreign column?​

Accepted Answer

A)  ​It is written in a different language. 
B)  ​It refers to a field in one table that uniquely identifies a row in a different table. 
C)  ​It does not belong in this table. 
D)  ​It requires a different formula for analyzing the data. 
A)  ​It is written in a different language. 
B)  ​It refers to a field in one table that uniquely identifies a row in a different table. 
C)  ​It does not belong in this table. 
D)  ​It requires a different formula for analyzing the data.

Question 16

You can reset the ribbon to its installation default by clicking the Reset button in the Customize the Ribbon options in the ____ dialog box.

Accepted Answer

A)  Installation Defaults 
B)  Restore Settings 
C)  Factory preset 
D)  Excel Options 
A)  Installation Defaults 
B)  Restore Settings 
C)  Factory preset 
D)  Excel Options

Question 17

You can change the file type of a workbook that contains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.
_________________________

Accepted Answer

A) True 
 B)False

Question 18

Power Pivot is ​not helpful when analyzing large,complex sets of related tables.​

Accepted Answer

A) True 
 B)False

Question 19

Excel has a narrow range of interlinked power tools to analyze business data.​

Accepted Answer

A) True 
 B)False

Question 20

Why do the query tables use an underscore in their names?

Accepted Answer

A)  ​It identifies it as a query table. 
B)  ​Excel has definite rules about how to name different tables. 
C)  ​Database structures rarely allow spaces in the names of files or fields 
D)  ​It prevents the table from being read by other databases. 
A)  ​It identifies it as a query table. 
B)  ​Excel has definite rules about how to name different tables. 
C)  ​Database structures rarely allow spaces in the names of files or fields 
D)  ​It prevents the table from being read by other databases.

You can set a keyboard shortcut key combination for executing a macro with an option in the Record Macro dialog box.

Power View uses _____ to group data.

Data modelling is the process of creating a _____.

Which of the following are true about macros?

The MACRO tab on the ribbon includes commands used to work with macros.

What does OLAP stand for?

A macro name can contain numbers and letters but not underscores.

Which of the following are interlinked power tools used to analyze business data in Excel?

If you make a mistake while recording a macro,press the ESC key and repeat the step in error.

A macro's steps and their order should be determined and rehearsed after creating the macro.

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

What is a measure?

You should select the ending cell before turning on the macro recorder.

Which of the following is the path to the 'Add a Hyperlink' button?

Why is it called a foreign column?

You can reset the ribbon to its installation default by clicking the Reset button in the Customize the Ribbon options in the ____ dialog box.

You can change the file type of a workbook that contains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box. _________________________

Power Pivot is not helpful when analyzing large,complex sets of related tables.

Excel has a narrow range of interlinked power tools to analyze business data.

Why do the query tables use an underscore in their names?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 10: Using Macros and Visual Basic for Applications Vba With Excel

You can set a keyboard shortcut key combination for executing a macro with an option in the Record Macro dialog box.

Power View uses _____ to group data.​

Data modelling is the process of creating a _____.​

Which of the following are true about macros?

The MACRO tab on the ribbon includes commands used to work with macros.

What does OLAP stand for?​

A macro name can contain numbers and letters but not underscores.

Which of the following are interlinked power tools ​used to analyze business data in Excel?

If you make a mistake while recording a macro,press the ESC key and repeat the step in error.

A macro's steps and their order should be determined and rehearsed after creating the macro.

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

What is a measure?​

You should select the ending cell before turning on the macro recorder.

Which of the following is the path to the 'Add a Hyperlink' button?

Why is it called a foreign column?​

You can reset the ribbon to its installation default by clicking the Reset button in the Customize the Ribbon options in the ____ dialog box.

You can change the file type of a workbook that contains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box. _________________________

Power Pivot is ​not helpful when analyzing large,complex sets of related tables.​

Excel has a narrow range of interlinked power tools to analyze business data.​

Why do the query tables use an underscore in their names?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Power View uses _____ to group data.

Data modelling is the process of creating a _____.

What does OLAP stand for?

Which of the following are interlinked power tools used to analyze business data in Excel?

What is a measure?

Why is it called a foreign column?

Power Pivot is not helpful when analyzing large,complex sets of related tables.

Excel has a narrow range of interlinked power tools to analyze business data.