Question 1

________ is a standalone desktop application that has Power View functionality outside of Excel

Accepted Answer

Power BI Desktop

Question 2

________ properties are settings that control how imported data in cells connect to their source data.

Accepted Answer

Data range

Question 3

Match between columns
                        Premises: Power Pivot
Relationship
Power Query
Table
Power BI

Accepted Answer

The Answer of Online application suite designed to help users is...

Question 4

is an XML declaration.

Accepted Answer

A) True 
 B)False

Question 5

An XML comment starts with .

Accepted Answer

A) True 
 B)False

Question 6

What is a relationship in Power Pivot?

Accepted Answer

A) A continuous stream of XML data to Power Pivot 
B) The reference in a DAX function 
C) A tool to build key performance indicators 
D) An association between two related tables where each table contains an identical field 
A) A continuous stream of XML data to Power Pivot 
B) The reference in a DAX function 
C) A tool to build key performance indicators 
D) An association between two related tables where each table contains an identical field

Question 7

Which feature is best suited to split imported text into multiple columns?

Accepted Answer

A) Text Import Wizard 
B) Column Split Wizard 
C) Convert Column Tool 
D) Convert Text to Columns Wizard 
A) Text Import Wizard 
B) Column Split Wizard 
C) Convert Column Tool 
D) Convert Text to Columns Wizard

Question 8

Power Query is ________.

Accepted Answer

A) installed by default 
B) enabled in Options 
C) downloadable Excel add-in 
D) on the Data tab 
A) installed by default 
B) enabled in Options 
C) downloadable Excel add-in 
D) on the Data tab

Question 9

There are 27 Text string manipulation functions.

Accepted Answer

A) True 
 B)False

Question 10

The return of the RIGHT function is always a number.

Accepted Answer

A) True 
 B)False

Question 11

Which of these file types cannot be imported into Excel?

Accepted Answer

A) .txt 
B) .CSV 
C) .PDF 
D) CAD 
A) .txt 
B) .CSV 
C) .PDF 
D) CAD

Question 12

What would be the return of the following function in C2?  
=CONCATENATE(A2," ",B2)

Accepted Answer

A) jamesturner 
B) JAMES 
C) james Turner 
D) jamesTurner 
A) jamesturner 
B) JAMES 
C) james Turner 
D) jamesTurner

Question 13

Which of the following are settings that control how imported data in cells connect to their source data?

Accepted Answer

A) Import settings 
B) Data range properties 
C) Link settings 
D) Data Control settings 
A) Import settings 
B) Data range properties 
C) Link settings 
D) Data Control settings

Question 14

What would you do to start to manage an existing connection in a linked workbook?

Accepted Answer

A) Click Manage in the Connections group of the Data tab. 
B) Click Connections in the Connections group of the Data tab. 
C) Click Existing Connection in the Get External Data group of the Data tab. 
D) Click Refresh All in the Connections group of the Data tab. 
A) Click Manage in the Connections group of the Data tab. 
B) Click Connections in the Connections group of the Data tab. 
C) Click Existing Connection in the Get External Data group of the Data tab. 
D) Click Refresh All in the Connections group of the Data tab.

Question 15

There are a total of ________ text manipulation functions in Excel.

Accepted Answer

A) 4 
B) 10 
C) 27 
D) 7 
A) 4 
B) 10 
C) 27 
D) 7

Question 16

________ is an Excel add-in that enables you to create a visual dashboard.

Accepted Answer

A) Power View 
B) Power Pivot 
C) Power Query 
D) Power Dash 
A) Power View 
B) Power Pivot 
C) Power Query 
D) Power Dash

Question 17

Text string functions cannot be nested.

Accepted Answer

A) True 
 B)False

Question 18

What would be the return of the following function in C3?  
=LOWER(B3)

Accepted Answer

A) STEWART 
B) Stewart 
C) stewart 
D) Aaron Stewart 
A) STEWART 
B) Stewart 
C) stewart 
D) Aaron Stewart

Question 19

What governing body developed XML?

Accepted Answer

A) NSA 
B) ICANN 
C) Word Wide Web Consortium (W3
C)  
D) IEEE 
A) NSA 
B) ICANN 
C) Word Wide Web Consortium (W3
C)  
D) IEEE

Question 20

Each data field or table added to a Power View canvas is called a(n)________.

Accepted Answer

A) element. 
B) visualization. 
C) key indicator. 
D) calculation. 
A) element. 
B) visualization. 
C) key indicator. 
D) calculation.

________ is a standalone desktop application that has Power View functionality outside of Excel

________ properties are settings that control how imported data in cells connect to their source data.

is an XML declaration.

An XML comment starts with .

What is a relationship in Power Pivot?

Which feature is best suited to split imported text into multiple columns?

Power Query is ________.

There are 27 Text string manipulation functions.

The return of the RIGHT function is always a number.

Which of these file types cannot be imported into Excel?

What would be the return of the following function in C2? =CONCATENATE(A2," ",B2)

Which of the following are settings that control how imported data in cells connect to their source data?

What would you do to start to manage an existing connection in a linked workbook?

There are a total of ________ text manipulation functions in Excel.

________ is an Excel add-in that enables you to create a visual dashboard.

Text string functions cannot be nested.

What would be the return of the following function in C3? =LOWER(B3)

What governing body developed XML?

Each data field or table added to a Power View canvas is called a(n)________.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 10: Imports, Xml, and Power Add-Ins

________ is a standalone desktop application that has Power View functionality outside of Excel

________ properties are settings that control how imported data in cells connect to their source data.

is an XML declaration.

An XML comment starts with .

What is a relationship in Power Pivot?

Which feature is best suited to split imported text into multiple columns?

Power Query is ________.

There are 27 Text string manipulation functions.

The return of the RIGHT function is always a number.

Which of these file types cannot be imported into Excel?

What would be the return of the following function in C2? =CONCATENATE(A2," ",B2)

Which of the following are settings that control how imported data in cells connect to their source data?

What would you do to start to manage an existing connection in a linked workbook?

There are a total of ________ text manipulation functions in Excel.

________ is an Excel add-in that enables you to create a visual dashboard.

Text string functions cannot be nested.

What would be the return of the following function in C3? =LOWER(B3)

What governing body developed XML?

Each data field or table added to a Power View canvas is called a(n)________.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters