Question 1

To change a social security number in cell A1 from the 506-32-4462 format to 506324462 in cell B1,you would type ________.&#10;A)=SWAP(A1,&#34;-&#34;,&#34;&#34;)&#10;B)=EXCHANGE(A1,&#34;-&#34;,&#34;&#34;)&#10;C)=SUBSTITUTE(A1,&#34;-&#34;,&#34;&#34;)&#10;D)=REPLACE(A1,&#34;-&#34;,&#34;&#34;)

Accepted Answer

The SUBSTITUTE function can replace one text string with another. In this case, we want to replace the hyphens ("-") with nothing ("") to create the new format for the social security number. This can be done by using the formula =SUBSTITUTE(A1,"-","") in cell B1.

Question 2

The From Text,From Access,and From Web buttons are located on the ________ tab.&#10;A)INSERT&#10;B)DATA&#10;C)REVIEW&#10;D)IMPORT

Accepted Answer

The "From Text", "From Access", and "From Web" buttons are all related to importing data, which is a function typically found on the "DATA" tab in Microsoft Office.

Question 3

When importing a text file into Excel,you must specify a delimiter.

Accepted Answer

False

Question 4

When an XML document is edited,changes to the imported data are automatically updated in Excel.

Accepted Answer

Changes made to an XML document do not automatically update the data in Excel. The Excel file would need to be manually refreshed or updated to reflect any changes made in the XML document.

Question 5

A Web query does not import the data,instead it creates a link to the Web page,which can be refreshed.

Accepted Answer

A web query does not bring the data into the spreadsheet, but creates a link to the webpage, allowing for the webpage data to be refreshed.

Question 6

When creating a Web query,tables in the Web page are indicated by:&#10;A)a solid yellow border.&#10;B)the table text displayed in yellow.&#10;C)the table highlighted in yellow.&#10;D)a yellow selection icon with a right-pointing arrow.

Accepted Answer

When creating a Web query, tables in the Web page are typically indicated by a yellow selection icon with a right-pointing arrow. This visual cue helps users identify which parts of the page can be selected for the query.

Question 7

The ________ function is used to change NEW YORK to New York.&#10;A)CONCATENATE&#10;B)UPPER&#10;C)LOWER&#10;D)PROPER

Accepted Answer

The PROPER function is used to capitalize the first letter of each word, thereby changing NEW YORK to New York. The CONCATENATE function is used to join two or more strings together, the UPPER function changes all letters to uppercase, and the LOWER function changes all letters to lowercase.

Question 8

Using the Convert Text to Columns Wizard is similar to using the Text Import Wizard.

Accepted Answer

Both the Convert Text to Columns Wizard and Text Import Wizard are used for separating data in a single column into multiple columns. However, the Convert Text to Columns Wizard is used when the data is already in a single column within a worksheet, while the Text Import Wizard is used when data is being imported from an external source such as a CSV or TXT file. Despite the differences, both wizards use similar steps and interfaces to achieve their respective purposes.

Question 9

In the expression,270.65,the  and  are referred to as ________.&#10;A)tags&#10;B)markers&#10;C)delimiters&#10;D)identifiers

Accepted Answer

The words and in this expression are HTML tags, used to define and format the content within them on a webpage.

Question 10

Data imported from an Access table is formatted as a range of cells.

Accepted Answer

The answer of Data imported from an Access table is...

Question 11

You can use ________ in conjunction with data in existing columns to separate the data into distinct columns.&#10;A)Format Painter&#10;B)Flash Fill&#10;C)Copy with Paste Special&#10;D)the fill handle

Accepted Answer

The answer of You can use ________ in conjunction with...

Question 12

&#10;The text shown above represents information structured using ________ syntax.&#10;A)Visual Basic&#10;B)Excel macro&#10;C)HTML&#10;D)XML

Accepted Answer

The answer of  &#10;The text shown above represents information...

Question 13

An XML document can be edited in Notepad.

Accepted Answer

The answer of An XML document can be edited in...

Deck 37: Imports, web Queries, and XML: Hands-On-Exercise Videos