Chapter 10 Multiple Choice

A text file separates data by a special character called a: Position holder Delimiter Column spacer Start tag

You created a Web query to determine how many bushels of corn were harvested in your state last year. You referenced a USDA Web page. You need to view that page again and cannot remember the URL. You should: Open the Excel workbook and use the Data Import Wizard to find the URL. Use the Find command to locate the URL. Create a hyperlink to the URL Open the Excel workbook and open the Connection Properties dialog box where the URL is listed.

Last week, you created a Web query in Excel to import price and volume data about the stocks that interest you from a Web site. You open the file today and refresh the data. What will your spreadsheet show? The values you saved in the file last week and any calculations based on that data. The new values of the stock, but the calculations will need to be updated to reflect the current values. The new values with the calculations reflecting the current values of the stocks. The values you saved in the file last week, but you cannot create calculations based on a Web query.

Your coworker created a workbook with a list of names and addresses. The state abbreviation and ZIP code are stored in one cell per customer, such as NC 27215. You need to be able to sort these data by postal code to use bulk-rate mailing. The appropriate Excel action is to: Type 27215 in the cell to the right of NC 27215 and use Flash Fill. Copy the data to another column and edit each cell to delete the the state abbreviations. Use the BREAK APART function to separate the state abbreviation and zip code. Insert a new column and retype the postal codes.

A workbook contains addresses in column C. The addresses use commas after the street, city, and state, such as 129 Elm Street, Burlington, NC, 27215. Column D contains the phone number. You instruct Excel to divide the data into multiple columns using coma delimiters. You successfully divide the column into four columns. What happens to the phone numbers in column D? Excel inserts new columns for each comma so the phone number will move to column G. The phone numbers are overwritten by the cities. Nothing will happen to the phone numbers. The phone numbers will convert to commas.

The text in column D is in uppercase letters. You want to convert the text to an initial capital letter followed by lowercase letters. You should use the ___function. Concatenate Upper Lower Proper

You received an inventory report showing what items and the quantities of each your store has in stock. All merchandise has a unique inventory number stored in column B. All items' eight-digit inventory numbers begin with 9890. You want to remove the 9890 prefix to better sort and manage the list. In a new column, insert the ____function to show just the final four digits of the data in column B. LEFT(B2,9890) RIGHT(B2,9890) RIGHT(B2,4) LEFT(B2,4)

One advantage of using XML data is that: Data are not dependent on a specific operating system. XML contains instructions on how the data should be formatted. People must use identical tag names. Once coded, XML data cannot be expanded.

When using the XML Source task pane option, you may not: Select only some of the desired elements. Change the elements' order. Map the XML elements to a specific worksheet. Import all elements by default.

Examine the following XML code and select the TRUE statement. Help Desk Trainee 10.50 hour mornings The tag names should use all capital letters. The nested tags (position, pay, payperiod, and hours) have no connection to the internship. Only applicants available in the mornings will be considered. Adding before and after will create boldfaced type.