Filters
Question type
Study Flashcards

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

Correct Answer

verifed

verified

Data range...

View Answer

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

A) True
B) False

Correct Answer

verifed

verified

Match the following terms with the corresponding description:

Premises
Importing
Text file
Delimiters
Embed
Tab-delimited
Responses
The process of inserting external data created or data stored in another format into the current application
Indicated by the .txt file extension
Special characters that separate data
Uses tabs to separate data into columns
Importing external data into Excel but not maintaining a link to the original data source

Correct Answer

Importing
Text file
Delimiters
Embed
Tab-delimited

Match the following terms with the corresponding description:

Premises
Text file
Delimiter
CSV
Tab-delimited
Newline character
Responses
Uses tabs to separate data into columns
Comma separated values
A special character that designates the end of a line and separates data for the next line or row
Indicated by the .txt file extension
Special characters that separate data

Correct Answer

Text file
Delimiter
CSV
Tab-delimited
Newline character

Access database tables cannot be imported into Excel.

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Match the following terms with the corresponding description:

Premises
Flash Fill
CSV
Delimiters
XML
Convert Text to Columns Wizard
Responses
Comma separated values
A feature in Excel that can often complete the same actions as of the PROPER function
Used to convert text in to data across separate columns
eXtensible Markup Language
Special characters that separate data

Correct Answer

Flash Fill
CSV
Delimiters
XML
Convert Text to Columns Wizard

Which function will convert a text string to all capitals?


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

E) All of the above
F) None of the above

Correct Answer

verifed

verified

What does XML stand for?


A) Extra Markup Language
B) eXtensible Markup Language
C) External Markup Language
D) Extention Markup Language

E) C) and D)
F) None of the above

Correct Answer

verifed

verified

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


A) CONCATENATE
B) Flash Fill
C) Fill handle
D) INDEX

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

CSV,comma ...

View Answer

is an XML comment.

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


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

E) All of the above
F) C) and D)

Correct Answer

verifed

verified

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


A) XML options box
B) Developer tab
C) View tab
D) XML Source task pane

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Convert Te...

View Answer

is an XML declaration.

A) True
B) False

Correct Answer

verifed

verified

Showing 21 - 40 of 103

Related Exams

Exam 1

Office Fundamentals and File Management

100 Questions

Exam 3

Word: Document Presentation: Editing and Formatting

100 Questions

Exam 4

Word: Document Productivity: Working With Tables and Mail Merge

100 Questions

Exam 5

Word: Collaboration and Research: Communicating and Producing Professional Papers

100 Questions

Exam 6

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

100 Questions

Exam 7

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

100 Questions

Exam 8

Word: Document Automation: Forms,macros,and Security

100 Questions

Exam 9

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

104 Questions

Exam 10

Power: Introduction to Powerpoint: Creating a Basic Presentation

108 Questions

Exam 11

Power: Presentation Development: Planning and Preparing a Presentation

111 Questions

Exam 12

Power: Presentation Design: Illustrations and Infographics

102 Questions

Exam 13

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

100 Questions

Exam 14

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

100 Questions

Exam 15

Power: Interactivity and Advanced Animation: Engaging the Audience

100 Questions

Exam 16

Power: Customization: Customizing Powerpoint and the Slide Show

100 Questions

Exam 17

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

100 Questions

Exam 18

Excel: Introduction to Excel: What Is a Spreadsheet

100 Questions

Exam 19

Excel: Formulas and Functions: Performing Quantitative Analysis

100 Questions

Exam 20

Excel : Charts: Depicting Data Visually

100 Questions

Exam 21

Excel: Datasets and Tables: Managing Large Volumes of Data

100 Questions

Exam 22

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

103 Questions

Exam 23

Excel : What-If Analysis

103 Questions

Exam 24

Excel: Specialized Functions

103 Questions

Exam 25

Excel: Statistical Functions

103 Questions

Exam 26

Excel : Multiple-Sheet Workbook Management

103 Questions

Exam 28

Excel : Collaboration and Workbook Distribution

108 Questions

Exam 29

Excel: Templates, styles, and Macros

103 Questions

Exam 30

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

100 Questions

Exam 31

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

100 Questions

Exam 32

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

100 Questions

Exam 33

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

100 Questions

Exam 34

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

100 Questions

Exam 35

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

100 Questions

Exam 36

Access: Advanced Forms and Reports: Moving Beyond the Basics

100 Questions

Exam 37

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

100 Questions

Exam 38

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

100 Questions

Show Answer