Exam 7: Organizing Data for Effective Analysis

Identify the letter of the choice that best matches the date and time function. -Returns the serial number of the last day of the month before or after a specified number of months

Creating an Excel table lets you add some simple database functionality to a worksheet, but an Excel table has two limitations that are important to understand. What are they?

The LEFT function extracts characters from the ____ of a text string.

If you want to sort by more than one column, you can use the Sort dialog box to sort by up to ____ columns.

When you add a schema to a workbook, Excel generates an ____ to create mapped ranges of data, and define the relationships between these ranges and the elements in the XML schema.

A(n) ____________________ is a set of related data that is stored in tables.

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

Write the correct syntax for the FIND function, and briefly describe each of its three arguments.

To add a new row to an XML table, you use the handle in the lower-right cell of the XML table to ____. You can then type or copy values into the cells.

Creating an Excel worksheet often bridges the gap between tables and simple databases.

Case 7-2 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 is looking for all the customers who both are in the state of IL and have a 312 area code. He would create a(n) ____.

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

Case 7-2 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.

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 easiest way to create a PivotChart report is to use an existing PivotTable report as the source data.

In the FIND function, if you omit start_num, Excel assumes a start number of ____.

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

Case 7-2 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. -If Robert wanted to find all records with the value IL in the State field, he would click State in the Column to filter list box, click the State list arrow, and then click ____. Click the list arrow for the second list box, and then select IL.

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

Case 7-2 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.