Question 1

The Applied Steps area displays each manipulation that you performed on the data.​

Accepted Answer

A) True 
 B)False

Question 2

Commands can be added directly to a tab.​

Accepted Answer

A) True 
 B)False

Question 3

A data model is any collection of data that can be accessed or reassembled without having to reorganize the tables.​

Accepted Answer

A) True 
 B)False

Question 4

3D Maps can only be accessed from a specific worksheet or window.​

Accepted Answer

A) True 
 B)False

Question 5

A ____ is created by performing a set of steps and recording the steps as they are performed.

Accepted Answer

A)  table 
B)  macro 
C)  report 
D)  calculation 
A)  table 
B)  macro 
C)  report 
D)  calculation

Question 6

Cube functions are also called 3D cubes.​

Accepted Answer

A) True 
 B)False

Question 7

The first row of the imported worksheet is the part of the data.​

Accepted Answer

A) True 
 B)False

Question 8

You can set up multiple relationships using Power Pivot.

Accepted Answer

A) True 
 B)False

Question 9

The 3D Maps command opens a window that uses a few of your computer's resources.​

Accepted Answer

A) True 
 B)False

Question 10

Data catalogs _____.​

Accepted Answer

A)  ​can only be stored on the computer where it was created 
B)  ​act as data dictionaries 
C)  ​can be shared with everyone within a business 
D)  ​do not exist 
A)  ​can only be stored on the computer where it was created 
B)  ​act as data dictionaries 
C)  ​can be shared with everyone within a business 
D)  ​do not exist

Question 11

Once you start recording a macro,any task you perform in Excel will be part of the macro.

Accepted Answer

A) True 
 B)False

Question 12

Before recording a macro,you should select your ending cell.

Accepted Answer

A) True 
 B)False

Question 13

A macro name can be up to ____ characters long.

Accepted Answer

A)  8 
B)  32 
C)  127 
D)  255 
A)  8 
B)  32 
C)  127 
D)  255

Question 14

Due to the advanced nature of the power tools,all of the command display automatically.​

Accepted Answer

A) True 
 B)False

Question 15

Power BI is a business intelligence tool to visualize and share data.​

Accepted Answer

A) True 
 B)False

Question 16

Excel will italicize a hyperlink.​

Accepted Answer

A) True 
 B)False

Question 17

You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

Accepted Answer

A) True 
 B)False

Question 18

Excel has a command or button for every possible worksheet task.

Accepted Answer

A) True 
 B)False

Question 19

The Query Editor window has its own ribbon,tabs,and groups and is navigated independently from Excel.​

Accepted Answer

A) True 
 B)False

Question 20

When users hover over a hyperlink,the pointer will appear as an arrow.​

Accepted Answer

A) True 
 B)False

The Applied Steps area displays each manipulation that you performed on the data.

Commands can be added directly to a tab.

A data model is any collection of data that can be accessed or reassembled without having to reorganize the tables.

3D Maps can only be accessed from a specific worksheet or window.

A ____ is created by performing a set of steps and recording the steps as they are performed.

Cube functions are also called 3D cubes.

The first row of the imported worksheet is the part of the data.

You can set up multiple relationships using Power Pivot.

The 3D Maps command opens a window that uses a few of your computer's resources.

Data catalogs _____.

Once you start recording a macro,any task you perform in Excel will be part of the macro.

Before recording a macro,you should select your ending cell.

A macro name can be up to ____ characters long.

Due to the advanced nature of the power tools,all of the command display automatically.

Power BI is a business intelligence tool to visualize and share data.

Excel will italicize a hyperlink.

You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

Excel has a command or button for every possible worksheet task.

The Query Editor window has its own ribbon,tabs,and groups and is navigated independently from Excel.

When users hover over a hyperlink,the pointer will appear as an arrow.

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

The Applied Steps area displays each manipulation that you performed on the data.​

Commands can be added directly to a tab.​

A data model is any collection of data that can be accessed or reassembled without having to reorganize the tables.​

3D Maps can only be accessed from a specific worksheet or window.​

A ____ is created by performing a set of steps and recording the steps as they are performed.

Cube functions are also called 3D cubes.​

The first row of the imported worksheet is the part of the data.​

You can set up multiple relationships using Power Pivot.

The 3D Maps command opens a window that uses a few of your computer's resources.​

Data catalogs _____.​

Once you start recording a macro,any task you perform in Excel will be part of the macro.

Before recording a macro,you should select your ending cell.

A macro name can be up to ____ characters long.

Due to the advanced nature of the power tools,all of the command display automatically.​

Power BI is a business intelligence tool to visualize and share data.​

Excel will italicize a hyperlink.​

You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

Excel has a command or button for every possible worksheet task.

The Query Editor window has its own ribbon,tabs,and groups and is navigated independently from Excel.​

When users hover over a hyperlink,the pointer will appear as an arrow.​

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

The Applied Steps area displays each manipulation that you performed on the data.

Commands can be added directly to a tab.

A data model is any collection of data that can be accessed or reassembled without having to reorganize the tables.

3D Maps can only be accessed from a specific worksheet or window.

Cube functions are also called 3D cubes.

The first row of the imported worksheet is the part of the data.

The 3D Maps command opens a window that uses a few of your computer's resources.

Data catalogs _____.

Due to the advanced nature of the power tools,all of the command display automatically.

Power BI is a business intelligence tool to visualize and share data.

Excel will italicize a hyperlink.

The Query Editor window has its own ribbon,tabs,and groups and is navigated independently from Excel.

When users hover over a hyperlink,the pointer will appear as an arrow.