Exam 7: Organizing Data for Effective Analysis

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. -Julie has just signed up a new customer. How does she add the customer's information to the table?

When data is in a comma-delimited form, there is a single ____ of data with commas separating the data.

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

The SEARCH function finds one text string ____ another text string (not case sensitive).

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.

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.

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 wants to send a special gift to anyone who has placed his or her first order in the past three months or who has total sales of over $1,000 per year. In this case, Robert would use a(n) ____.

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

The Subtotal command works with ____ calculation(s) at a time.

When working with an Excel table, you should insert ____ around the list to segregate it from any other data in the worksheet.

A PivotChart report represents source data as a ____.

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

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

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

A document type definition ____.

A database stored in one table is sometimes called a(n) flat-file database. _________________________

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

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

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

Clicking within an Excel table opens the ____ tab on the ribbon.