Deck 38: Imports, web Queries, and XML

Question 1

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

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

Answer 1

C

Question 2

Which of the following functions does not manipulate text?

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

Answer 2

D

Question 3

Which of the following tools is best suited for setting up a connection to a table on a Web page?

A)Hyperlink
B)Web query
C)3-D formula
D)Web inquiry

Answer 3

B

Question 4

Which of the following sources cannot be imported into Excel?

A)SQL Server
B)Analysis Services
C)Direct image files from a web page
D)Windows Azure Marketplace

Question 5

Which of the following are settings that control how imported data in cells connect to their source data?

A)Import settings
B)Connection properties
C)Link settings
D)Data range properties

Question 6

What is the maximum number of strings that can be manipulated with the CONCATENATE function?

A)25
B)125
C)200
D)255

Question 7

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

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 8

What message is displayed in the status bar when a connection is being updated?

A)Connections updating
B)Running background query
C)Updating connections
D)Status - updated

Question 9

What is the purpose of the CONCATENATE function?

A)Counts the characters of a text string
B)Splits text strings
C)Joins text strings
D)Transposes text from columns to rows

Question 10

Which of the following describes importing data into Excel but do not maintaining a link to the original data source?

A)Embed
B)Hyperlink
C)External reference
D)3-D formula

Question 11

Which of the following is not a limitation when working with Web queries?

A)Web sites that require logins
B)URLs that change
C)Data that is not formatted as a table
D)Tables that contain foreign characters

Question 12

Which of the following file types uses tabs to separate data into columns?

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

Question 13

When creating a Web query which option preserves all original formatting?

A)Rich text
B)HTML formatting
C)XML
D)Style Sheet

Question 14

This file type uses commas to separate data into columns.

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

Question 15

Where are Web query tools and options located?

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

Question 16

When importing an Access database table,Excel:

A)imports the data as text.
B)formats the data in default table style.
C)imports the data in delimited format.
D)imports the data in CSV format.

Question 17

Which feature is best suited to split imported text into multiple columns?

A)Import Text Wizard
B)Convert Text to Columns Wizard
C)Import Wizard
D)Text tool

Question 18

Which of the following is a not an Excel file type?

A))xls
B))xlsx
C)text file
D))xltm

Question 19

Where is the Text to Columns Wizard located in Excel?

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

Question 20

Which of the following is a file type that cannot be imported into Excel?

A)PDF
B)Text file
C)CAD
D)TIFF

Question 21

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

Question 22

Which of the following is a required element of XML?

A)Tag
B)Title
C)Link
D)Anchor

Question 23

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

Question 24

Which function is best suited to return the specified number of characters from the middle of a text string?

A)LEFT
B)SUBSTITUTE
C)MID
D)RIGHT

Question 25

Which function is best suited to remove extras spaces from the beginning of a text string?

A)UPPER
B)LEFT
C)TRIM
D)SUBSTITUTE

Question 26

What is the following syntax <?
Xml version="1.0" encoding="UTF-8"?
>

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

Question 27

What governing body created XML?

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

Question 28

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

A)&
B)+
C)SUM
D):

Question 29

Which function will convert a text string to lowercase?

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

Question 30

Which of the following features will automatically complete lists?

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

Question 31

What does XML stand for?

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

Question 32

Which of the following is the best option for transferring data between incompatible systems?

A)XHTML
B)CSS
C)XML
D)HTML

Question 33

Which of the following applications can be used to create XML documents?

A)Notepad
B)Photoshop
C)iPhoto
D)Illustrator

Question 34

Where can XML files be opened in Excel?

A)Open dialog box
B)Data tab
C)Insert tab
D)Formula tab

Question 35

Which function is best suited to return the specified number of characters from the end of a text string?

A)RIGHT
B)LEFT
C)TRIM
D)MID

Question 36

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?

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

Question 37

Which function will convert a text string to all capitals?

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

Question 38

Which of the following is not part of XML?

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

Question 39

Which function is best suited to return the specified number of characters from the start of a text string?

A)RIGHT
B)LEFT
C)TRIM
D)MID

Question 40

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

Question 41

Text functions such as CONCATENATE and UPPER can be nested for more precise results.

Question 42

The CONCATENATE function could combine the words Microsoft and Excel into one text string.

Question 43

The LOWER function will capitalize the first letter of a text string.

Question 44

Flash Fill is located on the Ribbon.

Question 45

When connections are being refreshed,Excel displays the message "Running background query" in the status bar.

Question 46

XML stands for eXtensible Markup Language.

Question 47

Flash Fill can often perform the same tasks as the PROPER function.

Question 48

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

Question 49

Web queries refresh data automatically.

Question 50

Web queries cannot accurately import data from Web sites that are password protected.

Question 51

CSV files can be imported into an Excel workbook.

Question 52

The SUBSTITUTE function will replace the word doctor with Dr.in a text string.

Question 53

Text files can be imported into Excel workbooks.

Question 54

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

Question 55

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

Question 56

You embed the data within a worksheet when you import data and maintain the link to its original source.

Question 57

Flash Fill can auto fill numerical lists.

Question 58

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

Question 59

Access database tables cannot be imported into Excel.

Question 60

The maximum number of text strings supported by the CONCATENATE function is 255.

Question 61

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

Question 62

The ________ function can join up to 255 text strings.

Question 63

The ________ function could be used to capitalize the first letter of each word in a text string.

Question 64

You ________ data when you import data from an external source without maintaining a link to the original data.

Question 65

When connections are being refreshed in a workbook the status bar displays the message running a ________ query.

Question 66

The ________ function will capitalize all characters in a text string.

Question 67

Web queries cannot import data from Web pages that are ________.

Question 68

XML elements cannot be nested.

Question 69

Indentation indicates the hierarchy structure in XML.

Question 70

XML documents can be imported into Excel.

Question 71

The ________ function removes extra spaces from the beginning and end of a text string.

Question 72

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

Question 73

The ________ function will convert all characters in a text string to lowercase.

Question 74

The ________ function will replace an older text string with new text.

Question 75

<?
xml version="1.0" encoding="UTF-8"?
> is an XML declaration.

Question 76

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

Question 77

<!-- Created June 29 1979 --> is an XML comment.

Question 78

A ________ can import data from data tables on a Web page.

Question 79

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

Question 80

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