Exam 7: Organizing Data for Effective Analysis

The DOLLAR function converts a number to ____ in currency format with a dollar sign and the specified number of decimal places.

The AutoFilter option called Text Filters removes any existing filters, displays all data in the column, and restores the default (Select All) option. _________________________

A schema is a set of ____ for an XML document.

The Query Wizard lets you choose your data source and select the database table and fields you want to import into a workbook.

In Excel, you can use a text function to link together or transpose the information from multiple cells into one cell. _________________________

The ____________________ function returns the last character or characters in a text string, based on the number of characters specified.

An XML table is similar in appearance and functionality to an Excel table, but the data in an XML table is mapped to ____ elements.

In the ____ function, text is the text string or cell reference that contains the space(s) that you want to remove.

The ____ Wizard separates the values in a text string into columns or fields.

____ is the acronym for Extensible Markup Language.

Robert has imported some data from Access and is using the Query Wizard to filter the data. Please refer to the above figure when answering the questions below. -Robert has lost track of the columns with filters applied. He then remembers that when you specify a filter for a column, the column name changes to ____ in the Column to filter list box.

You can enter data into a worksheet by ____.

A(n) ____________________ is an interactive report that lets you summarize and analyze a data set.

A ____ is an interactive report that lets you summarize and analyze a data set.

You can open the Export XML dialog box using the Export button in the XML group on the ____ tab.

The CONCATENATE function combines the values in a range of cells into one numeric item in a new cell.

The SEARCH function is not case sensitive, so searching for ____ returns the same result as searching for D.

To import data using an XML map, open the ____ task pane, and then click the XML Maps button.

Robert has imported some data from Access and is using the Query Wizard to filter the data. Please refer to the above figure when answering the questions below. -Robert also wants to add an additional filter by phone number for those people who have a 312 area code. To include a second filter in his query, he would click the list arrow in the ____ and define the next filter.

To remove a filter from a column and display all of the data in the Excel table again, click the column's drop-down list arrow, and then click ____.