Question 1

The PivotTable ____________________ task pane contains a list of fields in the data source you selected for the PivotTable report.

Accepted Answer

The answer of The PivotTable ____________________ task pane contains a...

Question 2

The ____ function converts a text string that represents a number (a number, date, or time) to a number.

Accepted Answer

A)  VALUE 
B)  NUMBER 
C)  CONVERT 
D)  NEW 
A)  VALUE 
B)  NUMBER 
C)  CONVERT 
D)  NEW

Question 3

The data format that separates the values in each record with commas is often called ____.

Accepted Answer

A)  comma-separated values (CSV) 
B)  comma-separated data (CS
D)  
C)  comma data (C
D)  
D)  comma-separated records (CSR) 
A)  comma-separated values (CSV) 
B)  comma-separated data (CS
D)  
C)  comma data (C
D)  
D)  comma-separated records (CSR)

Question 4

To convert data to an XML document that can be used in any application that supports XML data, take the following steps: Click the Export button in the XML group, enter a filename in the ____ dialog box, and then click the Export button.

Accepted Answer

A)  Export XML 
B)  Import XML 
C)  Save XML 
D)  Convert XML 
A)  Export XML 
B)  Import XML 
C)  Save XML 
D)  Convert XML

Question 5

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 6

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

Accepted Answer

A) TIMEVALUE 
B) EDATE 
C) EOMONTH 
D) DATEVALUE 
E) WEEKDAY 
A) TIMEVALUE 
B) EDATE 
C) EOMONTH 
D) DATEVALUE 
E) WEEKDAY

Question 7

An Excel ____________________ is a range of cells that you formalize as a single unit of data.

Accepted Answer

The answer of An Excel ____________________ is a range of...

Question 8

When the data elements are being imported using an XML map, only the element names appear in the worksheet. To import the data from these elements into the worksheet, click the ____ button in the External Table Data group on the TABLE TOOLS DESIGN tab.

Accepted Answer

A)  Refresh 
B)  Calculate 
C)  XML 
D)  Design 
A)  Refresh 
B)  Calculate 
C)  XML 
D)  Design

Question 9

Identify the letter of the choice that best matches the date and time function.
-Converts a serial number to a day of the week

Accepted Answer

A) TIMEVALUE 
B) EDATE 
C) EOMONTH 
D) DATEVALUE 
E) WEEKDAY 
A) TIMEVALUE 
B) EDATE 
C) EOMONTH 
D) DATEVALUE 
E) WEEKDAY

Question 10

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

Accepted Answer

The correct syntax:=

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The PivotTable ____ task pane contains a list of fields in the data source you selected for the PivotTable report.

Accepted Answer

A)  List of Fields 
B)  Field List 
C)  Field Source 
D)  Fields 
A)  List of Fields 
B)  Field List 
C)  Field Source 
D)  Fields

Question 17

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 18

MATCHING
   
Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above.
-ROWS 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 19

MATCHING
   
Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above.
-FILTERS 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 20

Any data you enter in the row below an XML table will be added to the table.

Accepted Answer

A) True 
 B)False

The PivotTable ____________________ task pane contains a list of fields in the data source you selected for the PivotTable report.

The ____ function converts a text string that represents a number (a number, date, or time) to a number.

The data format that separates the values in each record with commas is often called ____.

To convert data to an XML document that can be used in any application that supports XML data, take the following steps: Click the Export button in the XML group, enter a filename in the ____ dialog box, and then click the Export button.

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.

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

An Excel ____________________ is a range of cells that you formalize as a single unit of data.

When the data elements are being imported using an XML map, only the element names appear in the worksheet. To import the data from these elements into the worksheet, click the ____ button in the External Table Data group on the TABLE TOOLS DESIGN tab.

Identify the letter of the choice that best matches the date and time function. -Converts a serial number to a day of the week

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

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 TODAY function returns the current date's serial number (based on the computer's internal clock). _________________________

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.

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

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

The PivotTable ____ task pane contains a list of fields in the data source you selected for the PivotTable report.

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.

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

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

Any data you enter in the row below an XML table will be added to the table.

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 PivotTable ____________________ task pane contains a list of fields in the data source you selected for the PivotTable report.

The ____ function converts a text string that represents a number (a number, date, or time) to a number.

The data format that separates the values in each record with commas is often called ____.

To convert data to an XML document that can be used in any application that supports XML data, take the following steps: Click the Export button in the XML group, enter a filename in the ____ dialog box, and then click the Export button.

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.

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

An Excel ____________________ is a range of cells that you formalize as a single unit of data.

When the data elements are being imported using an XML map, only the element names appear in the worksheet. To import the data from these elements into the worksheet, click the ____ button in the External Table Data group on the TABLE TOOLS DESIGN tab.

Identify the letter of the choice that best matches the date and time function. -Converts a serial number to a day of the week

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

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 TODAY function returns the current date's serial number (based on the computer's internal clock). _________________________

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.

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

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

The PivotTable ____ task pane contains a list of fields in the data source you selected for the PivotTable report.

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.

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

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

Any data you enter in the row below an XML table will be added to the table.

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