Exam 7: Organizing Data for Effective Analysis

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

Excel uses an XML map to relate the data to the elements when importing and exporting XML data.

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

Click the ____ option on the DATA tab on the ribbon to import Access data into Excel.

A PivotChart report represents source data as a(n) graphic. _________________________

Dividing text into columns is also referred to as parsing text into columns.

XML is a free, nonproprietary format.

The syntax for the TRIM function is as follows: =TRIM(____).

The maximum number of rows and columns in a worksheet limits the number of records and fields you can have in your list to ____ rows and 16,384 columns.

Excel table data is organized in rows and columns, where each column defines a record. _________________________

You can use a text function to ____, or concatenate, the information from multiple cells into one cell.

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. -To create the table as shown in the figure, Julie can click any cell in the worksheet and then the Table button in the Tables group on the ____ tab.

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

In the FIND function ____ is the character position in which to start the search.

You need to be careful when you export an XML file because only the elements in the XML list are exported, and not the elements from the ____.

The ____________________ function returns the current date's serial number (based on the computer's internal clock).

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 ____.

The XML data in an XML table functions like the data in an Excel table in that you can _____ the data in the same way.

The ____________________ function removes all spaces in a text string except for the single spaces between words.

An XML document can have ____ root element(s), and all other elements are nested within that/those root element(s).