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

The Answer of The process of inserting external data created is...

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

The Answer of Comma separated values and A feature in is...

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

The Answer of Uses tabs to separate data into columns is...

Exam 27: Excel: Imports, web Queries, and Xml

The PROPER function will convert every character in a text string to lowercase.

(True/False)

4.8/5

(41)

Question 21

The UPPER function will capitalize every character of a text string.

(True/False)

4.8/5

(28)

Question 22

Which function will convert a text string to all capitals?

(Multiple Choice)

4.7/5

(39)

Question 23

Tab-delimited files use tabs to separate data into columns.

(True/False)

4.7/5

(30)

Question 24

XML files can be opened in Excel by using the ________.

(Short Answer)

4.9/5

(36)

Question 25

Match the following terms with the corresponding description:

Importing

The process of inserting external data created or data stored in another format into the current application

Text file

Indicated by the .txt file extension

Delimiters

Special characters that separate data

Correct Answer:

Verified

Importing

Text file

Delimiters

Embed

Tab-delimited

(Matching)

4.7/5

(31)

Question 26

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

(Short Answer)

4.8/5

(36)

Question 27

Which of the following is a feature in Excel that can often perform the same task as the PROPER function?

(Multiple Choice)

4.9/5

(33)

Question 28

Access database tables cannot be imported into Excel.

(True/False)

4.8/5

(30)

Question 29

is an XML comment.

(True/False)

4.8/5

(37)

Question 30

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

(Short Answer)

4.8/5

(31)

Question 31

Match the following terms with the corresponding description:

Flash Fill

Comma separated values

CSV

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

Delimiters

Used to convert text in to data across separate columns

Correct Answer:

Verified

Flash Fill

CSV

Delimiters

XML

Convert Text to Columns Wizard

(Matching)

4.8/5

(33)

Question 32

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

(True/False)

4.9/5

(39)

Question 33

Which function is best suited to capitalize the first letter of each word in a text string?

(Multiple Choice)

4.8/5

(33)

Question 34

Once XML data is imported,where can the data source be manipulated?

(Multiple Choice)

4.8/5

(37)

Question 35

Microsoft Access data tables and ________ can be imported into Excel.

(Short Answer)

4.8/5

(29)

Question 36

What does XML stand for?

(Multiple Choice)

5.0/5

(40)

Question 37

________ are settings that control how imported data in cells connect to their source data.

(Short Answer)

4.8/5

(40)

Question 38

is an XML declaration.

(True/False)

4.8/5

(33)

Question 39

Match the following terms with the corresponding description:

Text file

Uses tabs to separate data into columns

Delimiter

Comma separated values

CSV

A special character that designates the end of a line and separates data for the next line or row

Correct Answer:

Verified

Text file

Delimiter

CSV

Tab-delimited

Newline character

(Matching)

4.7/5

(32)

Question 40

Exam 27: Excel: Imports, web Queries, and Xml

The PROPER function will convert every character in a text string to lowercase.

The UPPER function will capitalize every character of a text string.

Which function will convert a text string to all capitals?

Tab-delimited files use tabs to separate data into columns.

XML files can be opened in Excel by using the ________.

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

Which of the following is a feature in Excel that can often perform the same task as the PROPER function?

Access database tables cannot be imported into Excel.

is an XML comment.

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

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

Which function is best suited to capitalize the first letter of each word in a text string?

Once XML data is imported,where can the data source be manipulated?

Microsoft Access data tables and ________ can be imported into Excel.

What does XML stand for?

________ are settings that control how imported data in cells connect to their source data.

is an XML declaration.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters