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

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

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

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

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

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.