Question 1

Which of the following are types of hyperlinks?​

Accepted Answer

A)  ​links to places in the workbook 
B)  ​links to files or webpages 
C)  ​a link to create a new file 
D)  ​links to email addresses 
A)  ​links to places in the workbook 
B)  ​links to files or webpages 
C)  ​a link to create a new file 
D)  ​links to email addresses A,B,C,D

Question 2

Once a hyperlink is created,it cannot be edited.​

Accepted Answer

A) True 
 B)False  False

Question 3

The Get & Transform command does not allow you to edit imported data.​

Accepted Answer

A) True 
 B)False  False

Question 4

Data analysis commands are required ​

Accepted Answer

A)  ​to be turned on all the time. 
B)  ​in order to use the power tools. 
C)  ​before you can use the function key. 
D)  ​to be included in all Excel workbooks. 
A)  ​to be turned on all the time. 
B)  ​in order to use the power tools. 
C)  ​before you can use the function key. 
D)  ​to be included in all Excel workbooks.

Question 5

In Power BI,a(n)_____ is the file management system where you can upload many different types of files.​

Accepted Answer

A)  ​ftp server 
B)  ​database 
C)  ​dashboard 
D)  ​website 
A)  ​ftp server 
B)  ​database 
C)  ​dashboard 
D)  ​website

Question 6

Which of the following steps must be taken in preparation for working with macros in Excel?

Accepted Answer

A)  A security setting must be modified to enable macros. 
B)  Developer tab must be displayed. 
A)  A security setting must be modified to enable macros. 
B)  Developer tab must be displayed.

Question 7

The COUNTIFS function is an easy way to count data using multiple criteria sets.​

Accepted Answer

A) True 
 B)False

Question 8

A relationship is a field or column that three data sources have in common.​

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is the path to the Background button?

Accepted Answer

Question 10

If you want to create more than just a single static map,you must add relationships.​

Accepted Answer

A) True 
 B)False

Question 11

You can press _____ to display the Hyperlink dialog box.​

Accepted Answer

A)  ​CTRL+B 
B)  ​CTRL+H 
C)  ​CTRL+I 
D)  ​CTRL+K 
A)  ​CTRL+B 
B)  ​CTRL+H 
C)  ​CTRL+I 
D)  ​CTRL+K

Question 12

Data models are unique to Power Pivot.​

Accepted Answer

A) True 
 B)False

Question 13

You can enable or disable macros with options in the ____ dialog box.

Accepted Answer

A)  Macro Options 
B)  Trust Center 
C)  Excel Options 
D)  Security Center 
A)  Macro Options 
B)  Trust Center 
C)  Excel Options 
D)  Security Center

Question 14

Every Excel command and ribbon button has a corresponding Answer Report that the computer executes.

Accepted Answer

A) True 
 B)False

Question 15

A hyperlink is a computer link or reference to another location.​

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is the path to the Record Macro button?

Accepted Answer

Question 17

You know there is a hyperlink,if Excel underlines the text.​

Accepted Answer

A) True 
 B)False

Question 18

When customizing the ribbon,​

Accepted Answer

A)  ​consider adding the command to the Quick Access Toolbar. 
B)  ​consider creating a new tab. 
C)  ​choose a tab with plenty of room. 
D)  ​remember who the audience is. 
A)  ​consider adding the command to the Quick Access Toolbar. 
B)  ​consider creating a new tab. 
C)  ​choose a tab with plenty of room. 
D)  ​remember who the audience is.

Question 19

You can click the Stop / Start Macro button on the status bar to start or stop recording a macro.

Accepted Answer

A) True 
 B)False

Question 20

PivotTables can be made without Power Pivot.​

Accepted Answer

A) True 
 B)False

Which of the following are types of hyperlinks?

Once a hyperlink is created,it cannot be edited.

The Get & Transform command does not allow you to edit imported data.

Data analysis commands are required

In Power BI,a(n)_____ is the file management system where you can upload many different types of files.

Which of the following steps must be taken in preparation for working with macros in Excel?

The COUNTIFS function is an easy way to count data using multiple criteria sets.

A relationship is a field or column that three data sources have in common.

Which of the following is the path to the Background button?

If you want to create more than just a single static map,you must add relationships.

You can press _____ to display the Hyperlink dialog box.

Data models are unique to Power Pivot.

You can enable or disable macros with options in the ____ dialog box.

Every Excel command and ribbon button has a corresponding Answer Report that the computer executes.

A hyperlink is a computer link or reference to another location.

Which of the following is the path to the Record Macro button?

You know there is a hyperlink,if Excel underlines the text.

When customizing the ribbon,

You can click the Stop / Start Macro button on the status bar to start or stop recording a macro.

PivotTables can be made without Power Pivot.

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

Which of the following are types of hyperlinks?​

Once a hyperlink is created,it cannot be edited.​

The Get & Transform command does not allow you to edit imported data.​

Data analysis commands are required ​

In Power BI,a(n)_____ is the file management system where you can upload many different types of files.​

Which of the following steps must be taken in preparation for working with macros in Excel?

The COUNTIFS function is an easy way to count data using multiple criteria sets.​

A relationship is a field or column that three data sources have in common.​

Which of the following is the path to the Background button?

If you want to create more than just a single static map,you must add relationships.​

You can press _____ to display the Hyperlink dialog box.​

Data models are unique to Power Pivot.​

You can enable or disable macros with options in the ____ dialog box.

Every Excel command and ribbon button has a corresponding Answer Report that the computer executes.

A hyperlink is a computer link or reference to another location.​

Which of the following is the path to the Record Macro button?

You know there is a hyperlink,if Excel underlines the text.​

When customizing the ribbon,​

You can click the Stop / Start Macro button on the status bar to start or stop recording a macro.

PivotTables can be made without Power Pivot.​

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

Which of the following are types of hyperlinks?

Once a hyperlink is created,it cannot be edited.

The Get & Transform command does not allow you to edit imported data.

Data analysis commands are required

In Power BI,a(n)_____ is the file management system where you can upload many different types of files.

The COUNTIFS function is an easy way to count data using multiple criteria sets.

A relationship is a field or column that three data sources have in common.

If you want to create more than just a single static map,you must add relationships.

You can press _____ to display the Hyperlink dialog box.

Data models are unique to Power Pivot.

A hyperlink is a computer link or reference to another location.

You know there is a hyperlink,if Excel underlines the text.

When customizing the ribbon,

PivotTables can be made without Power Pivot.