Question 1

The ________ function will change JILL JONES to jill jones.

Accepted Answer

The answer of The ________ function will change JILL JONES...

Question 2

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 3

The ________ function will replace one string with another.

Accepted Answer

The answer of The ________ function will replace one string...

Question 4

XML is ________.

Accepted Answer

A) Excel's version of HTML 
B) a method to structure data that's usable industry wide 
C) a method to format documents for web browser display 
D) a series of user defined markers 
A) Excel's version of HTML 
B) a method to structure data that's usable industry wide 
C) a method to format documents for web browser display 
D) a series of user defined markers

Question 5

Power Query can do all of the following except ________.

Accepted Answer

A) delete empty records 
B) chart data 
C) select records matching specific criteria 
D) add additional data from multiple sources 
A) delete empty records 
B) chart data 
C) select records matching specific criteria 
D) add additional data from multiple sources

Question 6

Importing XML data into Excel enables you to maintain a link and ________ data.

Accepted Answer

The answer of Importing XML data into Excel enables you...

Question 7

Where can you open XML files in Excel?

Accepted Answer

A) Open dialog box 
B) Developer tab 
C) Insert tab 
D) Formula tab. 
A) Open dialog box 
B) Developer tab 
C) Insert tab 
D) Formula tab.

Question 8

________ is an Excel add-in that enables you to build a visual dashboard with the functionality of a PivotTable.

Accepted Answer

The answer of ________ is an Excel add-in that enables...

Question 9

Match between columns
                        Premises: TRIM
SUBSTITUTE
MID
RIGHT
LEFT

Accepted Answer

The Answer of Returns the specified number of characters from is...

Question 10

Match between columns
                        Premises: Element
'XML Declaration
Start Tag
Extensible
End Tag

Accepted Answer

The Answer of Nearly infinite expendability for data descriptions and is...

Question 11

________ is an Excel add-in Business Intelligence tool which enables you to visualize and analyze data.

Accepted Answer

Power BI,

Question 12

Which is not true about building PivotTables in Power Pivot?

Accepted Answer

A) They can contain calculations. 
B) They can be built on multiple tables. 
C) They can have numerical data, only. 
D) They are for Business intelligence analysis. 
A) They can contain calculations. 
B) They can be built on multiple tables. 
C) They can have numerical data, only. 
D) They are for Business intelligence analysis.

Question 13

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 14

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?

Accepted Answer

A) TRIM 
B) LEFT 
C) CONCATENATE 
D) SUBSTITUTE 
A) TRIM 
B) LEFT 
C) CONCATENATE 
D) SUBSTITUTE

Question 15

You cannot separate data in a single column into multiple columns.

Accepted Answer

A) True 
 B)False

The ________ function will change JILL JONES to jill jones.

Embedded data in an excel workbook is ________.

The ________ function will replace one string with another.

XML is ________.

Power Query can do all of the following except ________.

Importing XML data into Excel enables you to maintain a link and ________ data.

Where can you open XML files in Excel?

________ is an Excel add-in that enables you to build a visual dashboard with the functionality of a PivotTable.

________ is an Excel add-in Business Intelligence tool which enables you to visualize and analyze data.

Which is not true about building PivotTables in Power Pivot?

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

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?

You cannot separate data in a single column into multiple columns.

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

The ________ function will change JILL JONES to jill jones.

Embedded data in an excel workbook is ________.

The ________ function will replace one string with another.

XML is ________.

Power Query can do all of the following except ________.

Importing XML data into Excel enables you to maintain a link and ________ data.

Where can you open XML files in Excel?

________ is an Excel add-in that enables you to build a visual dashboard with the functionality of a PivotTable.

________ is an Excel add-in Business Intelligence tool which enables you to visualize and analyze data.

Which is not true about building PivotTables in Power Pivot?

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

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?

You cannot separate data in a single column into multiple columns.

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