Question 1

Which of the following is a required element of XML?

Accepted Answer

A) Tag 
B) Title 
C) Link 
D) Anchor 
A) Tag 
B) Title 
C) Link 
D) Anchor

Question 2

When importing an Access database table,Excel:

Accepted Answer

A) imports the data as text. 
B) formats the data in default table style. 
C) imports the data in delimited format. 
D) imports the data in CSV format. 
A) imports the data as text. 
B) formats the data in default table style. 
C) imports the data in delimited format. 
D) imports the data in CSV format.

Question 3

What is the purpose of the CONCATENATE function?

Accepted Answer

A) Counts the characters of a text string 
B) Splits text strings 
C) Joins text strings 
D) Transposes text from columns to rows 
A) Counts the characters of a text string 
B) Splits text strings 
C) Joins text strings 
D) Transposes text from columns to rows

Question 4

Which of the following is an alternative to using the CONCATENATE function?

Accepted Answer

A) & 
B) + 
C) SUM 
D) : 
A) & 
B) + 
C) SUM 
D) :

Question 5

Match between columns
                        Premises: Flash Fill
Delimiters
Convert Text to Columns Wizard
CSV
XML

Accepted Answer

The Answer of Comma separated values and eXtensible Markup Language is...

Question 6

Importing is the process of inserting external data,data created or stored in another format,into the current application.

Accepted Answer

A) True 
 B)False

Question 7

The ________ function will convert all characters in a text string to lowercase.

Accepted Answer

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

Question 8

What is the difference between linking imported files and embedding imported files?

Accepted Answer

When data is linked to an exte

Question 9

Data tables from database programs such as Access and ________ Server can be imported into Excel.

Accepted Answer

The answer of Data tables from database programs such as...

Question 10

A(n)________ file uses tabs to separate data into columns that can be imported into Excel.

Accepted Answer

The answer of A(n)________ file uses tabs to separate data...

Question 11

Match between columns
                        Premises: Refresh all
Workbook Connections dialog box
Running background query
Connection
Data range properties

Accepted Answer

The Answer of Contains tools for setting connection properties and is...

Question 12

Which of the following applications can be used to create XML documents?

Accepted Answer

A) Notepad 
B) Photoshop 
C) iPhoto 
D) Illustrator 
A) Notepad 
B) Photoshop 
C) iPhoto 
D) Illustrator

Question 13

Which of the following functions does not manipulate text?

Accepted Answer

A) CONCATENATE 
B) PROPER 
C) UPPER 
D) INDEX 
A) CONCATENATE 
B) PROPER 
C) UPPER 
D) INDEX

Question 14

Which of the following sources cannot be imported into Excel?

Accepted Answer

A) SQL Server 
B) Analysis Services 
C) Direct image files from a web page 
D) Windows Azure Marketplace 
A) SQL Server 
B) Analysis Services 
C) Direct image files from a web page 
D) Windows Azure Marketplace

Question 15

________ is a feature in Excel that can often perform the same tasks as the PROPER and CONCATENATE functions.

Accepted Answer

The answer of ________ is a feature in Excel that...

Question 16

XML documents can be imported into Excel.

Accepted Answer

A) True 
 B)False

Question 17

What is the maximum number of strings that can be manipulated with the CONCATENATE function?

Accepted Answer

A) 25 
B) 125 
C) 200 
D) 255 
A) 25 
B) 125 
C) 200 
D) 255

Question 18

A(n)________ file uses commas to separate data into columns that can be imported into Excel.

Accepted Answer

CSV,comma

Question 19

Flash Fill can often perform the same tasks as the PROPER function.

Accepted Answer

A) True 
 B)False

Question 20

CSV files can be imported into an Excel workbook.

Accepted Answer

A) True 
 B)False

Exam 38: Imports, web Queries, and XML

Which of the following is a required element of XML?

When importing an Access database table,Excel:

What is the purpose of the CONCATENATE function?

Which of the following is an alternative to using the CONCATENATE function?

Importing is the process of inserting external data,data created or stored in another format,into the current application.

The ________ function will convert all characters in a text string to lowercase.

What is the difference between linking imported files and embedding imported files?

Data tables from database programs such as Access and ________ Server can be imported into Excel.

A(n)________ file uses tabs to separate data into columns that can be imported into Excel.

Which of the following applications can be used to create XML documents?

Which of the following functions does not manipulate text?

Which of the following sources cannot be imported into Excel?

________ is a feature in Excel that can often perform the same tasks as the PROPER and CONCATENATE functions.

XML documents can be imported into Excel.

What is the maximum number of strings that can be manipulated with the CONCATENATE function?

A(n)________ file uses commas to separate data into columns that can be imported into Excel.

Flash Fill can often perform the same tasks as the PROPER function.

CSV files can be imported into an Excel workbook.

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