Match between columns Premises: CONCATENATE PROPER UPPER LOWER SUBSTITUTE

The Answer of Capitalizes the first letter of each word is...

Match between columns Premises: Importing Embed Text file Delimiters Tab-delimited

The Answer of Importing external data into Excel but not is...

Match between columns Premises: Text file CSV Tab-delimited Newline character Delimiter

The Answer of Comma separated values and Indicated by thE.txt is...

Match between columns Premises: FROM ORDER BY SELECT SQL WHERE

The Answer of instructs Access to return the specific fields is...

Match between columns Premises: TRIM LEFT RIGHT MID SUBSTITUTE

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

Exam 10: Time Saving Tools: Hands On Exercise Videos

A document ________ is a combination of coordinating fonts,colors,and special effects that provide a stylish appearance.

(Multiple Choice)

4.9/5

(80)

Question 21

The text shown above depicts several placeholders.

(True/False)

5.0/5

(82)

Question 22

Word's ________ feature allows you to view two documents at the same time and is useful for comparing an original document to a revised version.

(Multiple Choice)

4.8/5

(75)

Question 23

Match the following terms with the corresponding description:

CONCATENATE

Capitalizes the first letter of each word in a text string

PROPER

Joins up to 255 text strings

UPPER

Displays all text in a text string as lowercase

Correct Answer:

Verified

CONCATENATE

PROPER

UPPER

LOWER

SUBSTITUTE

(Matching)

4.9/5

(70)

Question 24

Match the following terms with the corresponding description:

XML

Start tag

End tag

Correct Answer:

Verified

XML

Start tag

End tag

Comment

XML declaration

(Matching)

4.8/5

(87)

Question 25

The image shown above illustrates the ________ gallery.

(Multiple Choice)

4.8/5

(74)

Question 26

Match the following terms with the corresponding description:

Importing

Importing external data into Excel but not maintaining a link to the original data source

Embed

Indicated by thE.txt file extension

Text file

Special characters that separate data

Correct Answer:

Verified

Importing

Embed

Text file

Delimiters

Tab-delimited

(Matching)

4.8/5

(59)

Question 27

Match the following terms with the corresponding description:

Text file

Comma separated values

CSV

Indicated by thE.txt file extension

Tab-delimited

Special characters that separate data

Correct Answer:

Verified

Text file

CSV

Tab-delimited

Newline character

Delimiter

(Matching)

4.9/5

(80)

Question 28

Match the following SQL keywords with their meanings:

FROM

instructs Access to return the specific fields from one or more tables

ORDER BY

specifies the table or tables that will be searched

SELECT

specifies the criteria that records must match to be included in the results

Correct Answer:

Verified

FROM

ORDER BY

SELECT

SQL

WHERE

(Matching)

4.9/5

(91)

Question 29

Themes are saved with the ________ extension.

(Multiple Choice)

4.7/5

(79)

Question 30

When working with a lengthy document,you may want to create a master document with ________.

(Multiple Choice)

4.7/5

(73)

Question 31

Match the following terms with the corresponding description:

TRIM

Returns the specified number of characters from the start of a text string

LEFT

Returns the specified number of characters from the middle of a text string, based on a starting position and length

RIGHT

Removes leading and trailing spaces in a text string but maintains spaces between words in a text string

Correct Answer:

Verified

TRIM

LEFT

RIGHT

MID

SUBSTITUTE

(Matching)

4.9/5

(89)

Question 32

Exam 10: Time Saving Tools: Hands On Exercise Videos

A document ________ is a combination of coordinating fonts,colors,and special effects that provide a stylish appearance.

The text shown above depicts several placeholders.

Word's ________ feature allows you to view two documents at the same time and is useful for comparing an original document to a revised version.

The image shown above illustrates the ________ gallery.

Themes are saved with the ________ extension.

When working with a lengthy document,you may want to create a master document with ________.

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: 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

Imports, web Queries, and XML

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