Question 1

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

Accepted Answer

A) Import Text Wizard 
B) Convert Text to Columns Wizard 
C) Import Wizard 
D) Text tool 
A) Import Text Wizard 
B) Convert Text to Columns Wizard 
C) Import Wizard 
D) Text tool

Question 2

<?
xml version="1.0" encoding="UTF-8"?
> is an XML declaration.

Accepted Answer

A) True 
 B)False

Question 3

A ________ can import data from data tables on a Web page.

Accepted Answer

The answer of A ________ can import data from data...

Question 4

The ________ function will capitalize all characters in a text string.

Accepted Answer

The answer of The ________ function will capitalize all characters...

Question 5

Flash Fill is located on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: XML declaration
XML
Element
End tag
Start tag

Accepted Answer

The Answer of eXtensible Markup Language and Contains the name is...

Question 7

Which function is best suited to return the specified number of characters from the start of a text string?

Accepted Answer

A) RIGHT 
B) LEFT 
C) TRIM 
D) MID 
A) RIGHT 
B) LEFT 
C) TRIM 
D) MID

Question 8

Text can be converted into separated columns using the ________ Wizard.

Accepted Answer

Convert Te

Question 9

Where is the Text to Columns Wizard located in Excel?

Accepted Answer

A) Data tab 
B) Insert tab 
C) Formulas tab 
D) Backstage 
A) Data tab 
B) Insert tab 
C) Formulas tab 
D) Backstage

Question 10

A(n)________ is a user-defined marker that identifies the beginning or ending of a piece of data in an XML document.

Accepted Answer

The answer of A(n)________ is a user-defined marker that identifies...

Question 11

Which of the following is the best option for transferring data between incompatible systems?

Accepted Answer

A) XHTML 
B) CSS 
C) XML 
D) HTML 
A) XHTML 
B) CSS 
C) XML 
D) HTML

Question 12

Match between columns
                        Premises: LEFT
SUBSTITUTE
RIGHT
MID
TRIM

Accepted Answer

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

Question 13

Indentation indicates the hierarchy structure in XML.

Accepted Answer

A) True 
 B)False

Question 14

XML stands for eXtensible Markup Language.

Accepted Answer

A) True 
 B)False

Question 15

Where are Web query tools and options located?

Accepted Answer

A) Formulas tab 
B) Insert tab 
C) Data tab 
D) Review tab 
A) Formulas tab 
B) Insert tab 
C) Data tab 
D) Review tab

Question 16

Match between columns
                        Premises: LOWER
UPPER
PROPER
SUBSTITUTE
CONCATENATE

Accepted Answer

The Answer of Joins up to 255 text strings and is...

Question 17

Text functions such as CONCATENATE and UPPER can be nested for more precise results.

Accepted Answer

A) True 
 B)False

Question 18

This file type uses commas to separate data into columns.

Accepted Answer

A) jpeg 
B) pdf 
C) csv 
D) tab-delimited 
A) jpeg 
B) pdf 
C) csv 
D) tab-delimited

Question 19

Match between columns
                        Premises: XML
Comment
End tag
XML declaration
Start tag

Accepted Answer

The Answer of  and eXtensible Markup is...

Question 20

Which of the following is not a limitation when working with Web queries?

Accepted Answer

A) Web sites that require logins 
B) URLs that change 
C) Data that is not formatted as a table 
D) Tables that contain foreign characters 
A) Web sites that require logins 
B) URLs that change 
C) Data that is not formatted as a table 
D) Tables that contain foreign characters

Exam 38: Imports, web Queries, and XML

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

<? xml version="1.0" encoding="UTF-8"? > is an XML declaration.

A ________ can import data from data tables on a Web page.

The ________ function will capitalize all characters in a text string.

Flash Fill is located on the Ribbon.

Which function is best suited to return the specified number of characters from the start of a text string?

Text can be converted into separated columns using the ________ Wizard.

Where is the Text to Columns Wizard located in Excel?

A(n)________ is a user-defined marker that identifies the beginning or ending of a piece of data in an XML document.

Which of the following is the best option for transferring data between incompatible systems?

Indentation indicates the hierarchy structure in XML.

XML stands for eXtensible Markup Language.

Where are Web query tools and options located?

Text functions such as CONCATENATE and UPPER can be nested for more precise results.

This file type uses commas to separate data into columns.

Which of the following is not a limitation when working with Web queries?

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters