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

Question 1

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.

Answer 1

B

Question 2

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

Answer 2

C

Question 3

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

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

Answer 3

C

Question 4

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 5

Which of the following functions does not manipulate text?

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

Question 6

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 7

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 8

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

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

Question 9

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

Question 10

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 11

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 12

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

Question 13

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

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

Question 14

Where is the Text to Columns Wizard located in Excel?

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

Question 15

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

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

Question 16

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 17

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 18

This file type uses commas to separate data into columns.

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

Question 19

Where are Web query tools and options located?

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

Question 20

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

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

Question 21

What is the following syntax

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

Question 22

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 23

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 24

Which of the following features will automatically complete lists?

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

Question 25

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

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

Question 26

Which function will convert a text string to all capitals?

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

Question 27

Where can XML files be opened in Excel?

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

Question 28

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

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

Question 29

Which of the following is a required element of XML?

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

Question 30

Which of the following is not part of XML?

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

Question 31

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

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

Question 32

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 33

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 34

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 35

Which function will convert a text string to lowercase?

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

Question 36

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 37

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 38

What does XML stand for?

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

Question 39

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 40

What governing body created XML?

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

Question 41

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

Question 42

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

Question 43

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

Question 44

Flash Fill can auto fill numerical lists.

Question 45

Flash Fill is located on the Ribbon.

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

CSV files can be imported into an Excel workbook.

Question 52

Web queries refresh data automatically.

Question 53

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

Question 54

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

Question 55

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

Question 56

XML stands for eXtensible Markup Language.

Question 57

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

Question 58

Text files can be imported into Excel workbooks.

Question 59

Access database tables cannot be imported into Excel.

Question 60

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

Question 61

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

Question 62

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

Question 63

XML documents can be imported into Excel.

Question 64

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

Question 65

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

Question 66

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

Question 67

Indentation indicates the hierarchy structure in XML.

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

XML elements cannot be nested.

Question 75

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

Question 76

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

Question 77

is an XML comment.

Question 78

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

Question 79

is an XML declaration.

Question 80

The ________ function can join up to 255 text strings.