Exam 7: Organizing Data for Effective Analysis

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

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 term ____________________ is commonly used in the XML community to describe an XML document that is properly structured, and meets established rules and guidelines for how data is described and defined using XML.

XML is a free, nonproprietary format.

A(n) ____________________ language uses a set of tags to distinguish different elements in a document, and uses attributes to define those elements further.

Many DBMSs are called absolute database management systems because the data is stored in tables that are related to each other through a common field. _________________________

A(n) ____________________ is a single characteristic of the entity, such as a product ID number or an address.

The ____ function converts lowercase letters in a text string to uppercase.

Unlike a regular chart, you can change the layout and data displayed in a PivotChart report by ____.

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

Identify the letter of the choice that best matches the date and time function. -Returns a decimal number for a specific time that is represented by a text string

The FIXED function rounds a number to a specified number of decimals and returns the number as text with commas and a period. _________________________

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

To remove a filter from a column and display all of the data in the Excel table again, click the column's filter arrow, and then click Clear Filter From.

A database is created by and defined in a database management warehouse (DBW), which is a software program that creates and accesses the data in a database.

The ____________________ function returns the starting position of one text value within another text value.

XML stands for ____________________.

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.

In the FIND function, ____ is the text containing the text that you want to find.

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.