Question 1

Which of the following actions refreshes data connections in a linked Excel workbook?

Accepted Answer

A) Click Existing Connection in the Get External Data group of the Data tab. 
B) Click Refresh on the File tab. 
C) Right-click on the data table and select Refresh all. 
D) Click Refresh All in the Connections group of the Data tab. 
A) Click Existing Connection in the Get External Data group of the Data tab. 
B) Click Refresh on the File tab. 
C) Right-click on the data table and select Refresh all. 
D) Click Refresh All in the Connections group of the Data tab.

Question 2

A CSV file has no newline characters.

Accepted Answer

A) True 
 B)False

Question 3

What would be the return of the following function in C4?
 
=PROPER(A4)

Accepted Answer

A) TASHA 
B) tasha 
C) Tasha 
D) Tasha McCall 
A) TASHA 
B) tasha 
C) Tasha 
D) Tasha McCall

Question 4

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 5

On which tab is the Text to Columns Wizard?

Accepted Answer

A) Insert 
B) Data 
C) Formula 
D) Developer 
A) Insert 
B) Data 
C) Formula 
D) Developer

Question 6

Describing XML as ________ means that it can be expanded as necessary to fit the needs of the data.

Accepted Answer

The answer of Describing XML as ________ means that it...

Question 7

Embedded data in an excel workbook is ________.

Accepted Answer

A) uneditable data linked to a web source 
B) data that imported using Power Query 
C) any imported data 
D) editable data with no link back to its original source 
A) uneditable data linked to a web source 
B) data that imported using Power Query 
C) any imported data 
D) editable data with no link back to its original source

Question 8

The ________ function will change sam smith into SAM SMITH.

Accepted Answer

The answer of The ________ function will change sam smith...

Question 9

The ________ is the area that contains the dashboard data visualizations in Power View.

Accepted Answer

A) slate 
B) canvas 
C) palette 
D) surface 
A) slate 
B) canvas 
C) palette 
D) surface

Question 10

An XML comment starts with .

Accepted Answer

A) True 
 B)False

Question 11

What does XML stand for?

Accepted Answer

A) Extensible Markup Language 
B) Excel Markup Language 
C) Extension Markup Language 
D) External Markup Language 
A) Extensible Markup Language 
B) Excel Markup Language 
C) Extension Markup Language 
D) External Markup Language

Question 12

Match each of the following concepts to its best description: I.Element II.Start Tag III.End Tag IV.'XML Declaration V.Extensible A) B)Nearly infinite expendability for data descriptions C) D) E)2

Accepted Answer

The answer of Match each of the following concepts to...

Question 13

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 14

The return of the RIGHT function is always a number.

Accepted Answer

A) True 
 B)False

Question 15

Power BI is a ________.

Accepted Answer

A) Business Integration tool suite 
B) Business Intelligence tool suite 
C) Business Investment tool suite 
D) Business Interconnectivity tool suite 
A) Business Integration tool suite 
B) Business Intelligence tool suite 
C) Business Investment tool suite 
D) Business Interconnectivity tool suite

Which of the following actions refreshes data connections in a linked Excel workbook?

A CSV file has no newline characters.

What would be the return of the following function in C4? =PROPER(A4)

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

On which tab is the Text to Columns Wizard?

Describing XML as ________ means that it can be expanded as necessary to fit the needs of the data.

Embedded data in an excel workbook is ________.

The ________ function will change sam smith into SAM SMITH.

The ________ is the area that contains the dashboard data visualizations in Power View.

An XML comment starts with .

What does XML stand for?

Match each of the following concepts to its best description: I.Element II.Start Tag III.End Tag IV.'XML Declaration V.Extensible A)<Bedrooms> B)Nearly infinite expendability for data descriptions C)<? Xml version="1.0" encoding="UTF-8" standalone="no" ? > D)</Bedrooms> E)<Bedrooms>2</Bedrooms>

Which of these file types cannot be imported into Excel?

The return of the RIGHT function is always a number.

Power BI is a ________.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

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

Which of the following actions refreshes data connections in a linked Excel workbook?

A CSV file has no newline characters.

What would be the return of the following function in C4? =PROPER(A4)

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

On which tab is the Text to Columns Wizard?

Describing XML as ________ means that it can be expanded as necessary to fit the needs of the data.

Embedded data in an excel workbook is ________.

The ________ function will change sam smith into SAM SMITH.

The ________ is the area that contains the dashboard data visualizations in Power View.

An XML comment starts with .

What does XML stand for?

Match each of the following concepts to its best description: I.Element II.Start Tag III.End Tag IV.'XML Declaration V.Extensible A)<Bedrooms> B)Nearly infinite expendability for data descriptions C)<? Xml version="1.0" encoding="UTF-8" standalone="no" ? > D)</Bedrooms> E)<Bedrooms>2</Bedrooms>

Which of these file types cannot be imported into Excel?

The return of the RIGHT function is always a number.

Power BI is a ________.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters