Question 1

A(n)________ is a data file that contains characters,such as letters,numbers,and symbols,including punctuation and spaces.

Accepted Answer

The answer of A(n)________ is a data file that contains...

Question 2

What governing body created XML?

Accepted Answer

A) IEEE 
B) World Wide Web Consortium 
C) The Computer Science Society 
D) ICANN 
A) IEEE 
B) World Wide Web Consortium 
C) The Computer Science Society 
D) ICANN

Question 3

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

Accepted Answer

The Answer of Updates all information on connected data and is...

Question 4

Which of the following options will refresh connections within an Excel workbook?

Accepted Answer

A) Click Refresh All on the Connections group 
B) Click Refresh in the Backstage area 
C) Click anywhere in the connected data 
D) Click Refresh in the Insert tab 
A) Click Refresh All on the Connections group 
B) Click Refresh in the Backstage area 
C) Click anywhere in the connected data 
D) Click Refresh in the Insert tab

Question 5

Match between columns
                        Premises: LOWER
SUBSTITUTE
UPPER
CONCATENATE
PROPER

Accepted Answer

The Answer of Displays all text in a text string is...

Question 6

Which of the following features will automatically complete lists?

Accepted Answer

A) Flash Fill 
B) Fill handle 
C) PivotTables 
D) Web queries 
A) Flash Fill 
B) Fill handle 
C) PivotTables 
D) Web queries

Question 7

XML documents can be imported into Excel.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: SUBSTITUTE
RIGHT
TRIM
LEFT
MID

Accepted Answer

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

Question 9

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 10

What is the following syntax

Accepted Answer

A) XHTML 
B) HTML 
C) XML declaration 
D) Tag 
A) XHTML 
B) HTML 
C) XML declaration 
D) Tag

Question 11

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 12

Which function will convert a text string to lowercase?

Accepted Answer

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

Question 13

Where can all connections in a workbook be viewed or edited?

Accepted Answer

A) Insert tab 
B) Status bar 
C) Workbook Connections dialog box 
D) Formulas tab 
A) Insert tab 
B) Status bar 
C) Workbook Connections dialog box 
D) Formulas tab

Question 14

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 15

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 16

Where is the Text to Columns Wizard located in Excel?

Accepted Answer

A) Data tab 
B) Insert tab 
C) Formulas tab 
D) Backstage 
A) Data tab 
B) Insert tab 
C) Formulas tab 
D) Backstage

Question 17

This file type uses commas to separate data into columns.

Accepted Answer

A) jpeg 
B) pdf 
C) csv 
D) tab-delimited 
A) jpeg 
B) pdf 
C) csv 
D) tab-delimited

Question 18

Where are Web query tools and options located?

Accepted Answer

A) Formulas tab 
B) Insert tab 
C) Data tab 
D) Review tab 
A) Formulas tab 
B) Insert tab 
C) Data tab 
D) Review tab

Question 19

Which of the following is not part of XML?

Accepted Answer

A) Start tag 
B) Element 
C) Hyperlink 
D) XML declaration 
A) Start tag 
B) Element 
C) Hyperlink 
D) XML declaration

Question 20

XML stands for ________ Markup Language.

Accepted Answer

The answer of XML stands for ________ Markup Language....

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

A(n)________ is a data file that contains characters,such as letters,numbers,and symbols,including punctuation and spaces.

What governing body created XML?

Which of the following options will refresh connections within an Excel workbook?

Which of the following features will automatically complete lists?

XML documents can be imported into Excel.

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

What is the following syntax

Which of the following functions does not manipulate text?

Which function will convert a text string to lowercase?

Where can all connections in a workbook be viewed or edited?

What is the purpose of the CONCATENATE function?

Which of the following is a required element of XML?

Where is the Text to Columns Wizard located in Excel?

This file type uses commas to separate data into columns.

Where are Web query tools and options located?

Which of the following is not part of XML?

XML stands for ________ Markup Language.

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