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

The Answer of Contains the name of an element appearing is...

Match between columns Premises: TRIM CONCATENATE & RIGHT SUBSTITUTE

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

Match between columns Premises: macro data macro stand-alone macro embedded macro

The Answer of executes a series of actions when a is...

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

The Answer of eXtensible Markup Language and A feature in is...

Exam 10: Time Saving Tools: Hands On Exercise Videos

When two documents are combined,you have the option to combine them into a new document.

Free

(True/False)

4.8/5

(36)

Question 1

Correct Answer:

Verified

True

The image shown above illustrates the ________ gallery.

Free

(Multiple Choice)

4.9/5

(30)

Question 2

Correct Answer:

Verified

B

Match the following terms with the corresponding description:

XML

Contains the name of an element appearing at the beginning of a tag

Start tag

eXtensible Markup Language

End tag

Contains the name of an element and a slash indicating the end of the tag

Correct Answer:

Verified

XML

Contains the name of an element appearing at the beginning of a tag

Start tag

eXtensible Markup Language

End tag

Contains the name of an element and a slash indicating the end of the tag

Element

A statement at the beginning of an XML document indicating the programming language used

XML declaration

An object defined in XML

Free

(Matching)

4.8/5

(31)

Question 3

Correct Answer:

Verified

You can ________ a location so that you can quickly find the location in a document.

(Multiple Choice)

4.9/5

(37)

Question 4

Word templates are saved with the .dotx extension.

(True/False)

4.9/5

(41)

Question 5

Word has ________,which are partially completed documents such as letters,memos,reports,and resumes that contain preformatted text and/or graphics.

(Multiple Choice)

4.9/5

(35)

Question 6

To combine two Word documents,you click Merge.

(True/False)

4.7/5

(35)

Question 7

Theme fonts can be revised.

(True/False)

4.7/5

(35)

Question 8

Theme colors CANNOT be revised.

(True/False)

4.7/5

(33)

Question 9

Match the following terms with the corresponding description:

TRIM

Combines up to 255 text strings

CONCATENATE

An alternative to the concatenate function

&

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

Correct Answer:

Verified

TRIM

CONCATENATE

&

RIGHT

SUBSTITUTE

(Matching)

4.7/5

(38)

Question 10

A template may include ________,which are fields or blocks of text used to control the location of objects in a document.

(Multiple Choice)

4.8/5

(34)

Question 11

Match the following terms with the corresponding description:

Web query

When completing a Web query, this option maintains full formatting

Web Query Options dialog box

When completing a Web query, this option imports text only

Rich text formatting

This is not supported by Web queries

Correct Answer:

Verified

Web query

Web Query Options dialog box

Rich text formatting

HTML formatting

Login required

(Matching)

5.0/5

(36)

Question 12

Match the following terms with their meanings:

macro

executes a series of actions when a table event occurs

data macro

executes when an event attached to a control or object occurs

stand-alone macro

a series of actions that can be programmed to automate tasks

Correct Answer:

Verified

macro

data macro

stand-alone macro

embedded macro

(Matching)

4.9/5

(40)

Question 13

The ________ pane allows you to move through a document by viewing headings,pages,and search results.

(Multiple Choice)

4.9/5

(34)

Question 14

The icon identifies ________.

(Multiple Choice)

4.8/5

(51)

Question 15

Word templates can be downloaded from microsoft.com.

(True/False)

4.7/5

(30)

Question 16

A company logo,cover page,and bibliography are examples of ________,which can be frequently and easily inserted into documents.

(Multiple Choice)

5.0/5

(38)

Question 17

Match the following terms with the corresponding description:

Workbook Connections dialog box

A link between Excel and an external data source

Running background query

Updates all information on connected data

Data range properties

Displays in the status bar when data is being refreshed

Correct Answer:

Verified

Workbook Connections dialog box

Running background query

Data range properties

Refresh all

Connection

(Matching)

4.9/5

(39)

Question 18

Match the following terms with their meanings:

argument

block of text that is used to retrieve data from the tables in a database

event

user interface that enables you to create and edit macros

Macro Designer

occurs when a user enters, edits, or deleted data

Correct Answer:

Verified

argument

event

Macro Designer

SQL SELECT statement

Structured Query Language

(Matching)

4.7/5

(27)

Question 19

Match the following terms with the corresponding description:

Flash Fill

eXtensible Markup Language

Convert Text to Columns Wizard

A feature in Excel that can often complete the same actions as of the PROPER function

Delimiters

Comma separated values

Correct Answer:

Verified

Flash Fill

Convert Text to Columns Wizard

Delimiters

CSV

XML

(Matching)

4.8/5

(27)

Question 20

Exam 10: Time Saving Tools: Hands On Exercise Videos

When two documents are combined,you have the option to combine them into a new document.

The image shown above illustrates the ________ gallery.

You can ________ a location so that you can quickly find the location in a document.

Word templates are saved with the .dotx extension.

Word has ________,which are partially completed documents such as letters,memos,reports,and resumes that contain preformatted text and/or graphics.

To combine two Word documents,you click Merge.

Theme fonts can be revised.

Theme colors CANNOT be revised.

A template may include ________,which are fields or blocks of text used to control the location of objects in a document.

The ________ pane allows you to move through a document by viewing headings,pages,and search results.

The icon identifies ________.

Word templates can be downloaded from microsoft.com.

A company logo,cover page,and bibliography are examples of ________,which can be frequently and easily inserted into documents.

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