Exam 9: Organize, import, export, and Cleanse Data Sets

Commas are the only delimiter allowed for text files.

All of the following statements are TRUE about using an Excel web query EXCEPT:

All of the following statements are TRUE about cleansing data EXCEPT:

All of the following statements are TRUE about importing XML data EXCEPT:

Anything that is NOT stored in an Excel format or NOT stored locally is considered to be an external data set.

Data ________ is a process that converts data into a useful format by fixing obvious errors.

________ is the standard for transmitting data between applications and systems.

All of the following statements are TRUE about the importance of external data sets EXCEPT:

You can import tables and queries from Access by dragging the object from the Navigation Pane and dropping it into the desired starting cell.

If cell A2 contains the string "Excel 2013",then =________(A2)will return the number "10".

If the ________ function does not find the string supplied for the old_text argument,it will not return an error.

Excel cannot create permanent connections between an Access databases and an Excel spreadsheet.

Excel users can import data from a variety of sources including ________,which is anything that is neither stored in an Excel format nor stored locally.

Access database tables are the only element that can be imported into Excel.

Because Flash Fill involves less typing than traditional text functions,it can be easier to use on ________ devices.

There is NOT a prespecified standard for XML tags.

You can import tables and queries from Access by dragging the object from the ________ and dropping it into the desired starting cell.

The ________ function returns the total number of characters in a string.

The following is an example of the ________ data type. ProductNum,ProductName,DateShipped,Quantity Shipped 59313,XL Golf Shirts,3/15/13,35 72316,Men's Shoe,2/5/13,10 47423,Head covers,3/6/13,20