Exam 7: Organizing Data for Effective Analysis

Any data you enter in the row below an XML table will be added to the table.

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

A(n) ____________________ is similar in appearance and functionality to an Excel table, but the data is mapped to XML elements.

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

In a computer application, the term "string" refers to a meaningful sequence of characters.

You can change the calculation used in the VALUES area by right-clicking a value in the VALUES area to open the shortcut menu, and then clicking Field Settings to open the ____ dialog box.

HTML documents are user-defined documents in which the user develops a DTD that defines the elements contained in a document.

The CONCATENATE function combines the values in a range of cells into ____ in a new cell.

MATCHING Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above. -VALUES area

The syntax for the YEARFRAC function is as follows: =YEARFRAC(start_date,end_date,[basis]).

A document type definition ____.

Case 7-1 Julie is a sales manager, and she created the table above to organize her customer list. Please refer to the above figure when answering the questions below. -When Julie first created the Excel table, the filter arrows did not appear in the header row for each column. To enable them, she clicked the Filter button in the ____ group on the DATA tab.

An Excel table is a range of ____ that you formalize as a single unit of data.

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

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

In the RIGHT function, the argument called ____ specifies the number of characters that you want the RIGHT function to extract.

You can add a row at the top of a worksheet (called a ____ row) and type labels that identify the data contained in each column.

The ____ function calculates the number of years between two dates.

MATCHING Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above. -ROWS area

The PivotTable ____ task pane contains a list of fields in the data source you selected for the PivotTable report.