Question 1

The FIND function is case sensitive, so searching for ____ returns a different result than searching for D.

Accepted Answer

A)  d 
B)  D 
C)  either a or b 
D)  neither a nor b 
A)  d 
B)  D 
C)  either a or b 
D)  neither a nor b

Question 2

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

Accepted Answer

A)  alphabetically in front of 
B)  alphabetically after 
C)  in the row next to 
D)  within 
A)  alphabetically in front of 
B)  alphabetically after 
C)  in the row next to 
D)  within

Question 3

An XML table is similar in appearance and functionality to an Excel table, but the data in an XML table is mapped to ____ elements.

Accepted Answer

A)  SGML 
B)  XML 
C)  HTML 
D)  Excel 
A)  SGML 
B)  XML 
C)  HTML 
D)  Excel

Question 4

The first goal when working with unstructured data is to determine the ____ you need so you can find the best way to change the unstructured data into structured data.

Accepted Answer

A)  format 
B)  size of the file 
C)  color coding 
D)  reports 
A)  format 
B)  size of the file 
C)  color coding 
D)  reports

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  Select the last cell in the last row and press the Tab key. 
B)  Select the first cell in the last row and press Enter. 
C)  Select any cell and press Enter. 
D)  none of the above 
A)  Select the last cell in the last row and press the Tab key. 
B)  Select the first cell in the last row and press Enter. 
C)  Select any cell and press Enter. 
D)  none of the above

Question 7

The Query Wizard lets you choose your data source and select the database table and fields you want to import into a workbook.

Accepted Answer

A) True 
 B)False

Question 8

The default field setting in the ____ area is to calculate a sum of the items in this drop area by the categories in the Row Labels area or Column Labels area.

Accepted Answer

A)  TABLE 
B)  CELLS 
C)  CHART 
D)  VALUES 
A)  TABLE 
B)  CELLS 
C)  CHART 
D)  VALUES

Question 9

In comma-delimited files, a comma is the delimiter. Another common delimiter is the ____.

Accepted Answer

A)  slash 
B)  tab character 
C)  paragraph mark 
D)  quotation mark 
A)  slash 
B)  tab character 
C)  paragraph mark 
D)  quotation mark

Question 10

The ____________________ command creates summary reports that quickly organize data into categories with subtotal calculations, and lets you collapse and expand the level of detail in the report.

Accepted Answer

The answer of The ____________________ command creates summary reports that...

Question 11

A schema is a set of ____ for an XML document.

Accepted Answer

A)  arguments 
B)  hyperlinks 
C)  maps 
D)  validation rules 
A)  arguments 
B)  hyperlinks 
C)  maps 
D)  validation rules

Question 12

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.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____________________ is an interactive report that lets you summarize and analyze a data set.

Accepted Answer

The answer of A(n) ____________________ is an interactive report that...

Question 14

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

Accepted Answer

A) (#1) 
B) (#2) 
C) (#3) 
D) (#4) 
E) (#5)
F)(#6)
G)(#7) 
A) (#1) 
B) (#2) 
C) (#3) 
D) (#4) 
E) (#5)
F)(#6)
G)(#7)

Question 15

The term "well-formed" is commonly used in the XML community to describe an XML document that is properly structured and meets established rules and guidelines. _________________________

Accepted Answer

A) True 
 B)False

Question 16

The REPLACE function replaces part of a text string with a new text string based on the number of characters specified in ____.

Accepted Answer

A)  num_chars 
B)  range 
C)  text 
D)  start_num 
A)  num_chars 
B)  range 
C)  text 
D)  start_num

Question 17

In Excel, you can use a text function to link together or transpose the information from multiple cells into one cell. _________________________

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

The answer of Many DBMSs are called ____________________ database management...

Question 19

The SEARCH function is case sensitive.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  LEFT 
B)  CHARACTER 
C)  RIGHT 
D)  NUMBER 
A)  LEFT 
B)  CHARACTER 
C)  RIGHT 
D)  NUMBER

The FIND function is case sensitive, so searching for ____ returns a different result than searching for D.

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

An XML table is similar in appearance and functionality to an Excel table, but the data in an XML table is mapped to ____ elements.

The first goal when working with unstructured data is to determine the ____ you need so you can find the best way to change the unstructured data into structured data.

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

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

The Query Wizard lets you choose your data source and select the database table and fields you want to import into a workbook.

The default field setting in the ____ area is to calculate a sum of the items in this drop area by the categories in the Row Labels area or Column Labels area.

In comma-delimited files, a comma is the delimiter. Another common delimiter is the ____.

The ____________________ command creates summary reports that quickly organize data into categories with subtotal calculations, and lets you collapse and expand the level of detail in the report.

A schema is a set of ____ for an XML document.

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(n) ____________________ is an interactive report that lets you summarize and analyze a data set.

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

The term "well-formed" is commonly used in the XML community to describe an XML document that is properly structured and meets established rules and guidelines. _________________________

The REPLACE function replaces part of a text string with a new text string based on the number of characters specified in ____.

In Excel, you can use a text function to link together or transpose the information from multiple cells into one cell. _________________________

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

The SEARCH function is case sensitive.

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

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

Exam 7: Organizing Data for Effective Analysis

The FIND function is case sensitive, so searching for ____ returns a different result than searching for D.

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

An XML table is similar in appearance and functionality to an Excel table, but the data in an XML table is mapped to ____ elements.

The first goal when working with unstructured data is to determine the ____ you need so you can find the best way to change the unstructured data into structured data.

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

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

The Query Wizard lets you choose your data source and select the database table and fields you want to import into a workbook.

The default field setting in the ____ area is to calculate a sum of the items in this drop area by the categories in the Row Labels area or Column Labels area.

In comma-delimited files, a comma is the delimiter. Another common delimiter is the ____.

The ____________________ command creates summary reports that quickly organize data into categories with subtotal calculations, and lets you collapse and expand the level of detail in the report.

A schema is a set of ____ for an XML document.

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(n) ____________________ is an interactive report that lets you summarize and analyze a data set.

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

The term "well-formed" is commonly used in the XML community to describe an XML document that is properly structured and meets established rules and guidelines. _________________________

The REPLACE function replaces part of a text string with a new text string based on the number of characters specified in ____.

In Excel, you can use a text function to link together or transpose the information from multiple cells into one cell. _________________________

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

The SEARCH function is case sensitive.

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

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters