Question 1

A common way of storing data so that it is usable in other programs is to save it in a ____ file.

Accepted Answer

A)  comma-delimited 
B)  comma-limited 
C)  comma-delineated 
D)  comma-lineated 
A)  comma-delimited 
B)  comma-limited 
C)  comma-delineated 
D)  comma-lineated A

Question 2

In the RIGHT function, the argument called ____ is the text string or cell reference that contains the characters you want to extract.

Accepted Answer

A)  text 
B)  table 
C)  word 
D)  chars 
A)  text 
B)  table 
C)  word 
D)  chars A

Question 3

____ adds meaning to content by providing a description of the data through user-defined elements, and a hierarchical structure that shows the relationship of one data element to another.

Accepted Answer

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

Question 4

Hypertext Markup Language is the markup language that creates Web pages.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  moving fields 
B)  changing the chart type 
C)  both a and b 
D)  neither a nor b 
A)  moving fields 
B)  changing the chart type 
C)  both a and b 
D)  neither a nor b

Question 6

The DOLLAR function converts a number to ____ in currency format with a dollar sign and the specified number of decimal places.

Accepted Answer

A)  a formula 
B)  text 
C)  a graphic 
D)  none of the above 
A)  a formula 
B)  text 
C)  a graphic 
D)  none of the above

Question 7

____ is the acronym for Extensible Markup Language.

Accepted Answer

A)  XML 
B)  EML 
C)  EXML 
D)  EMARK 
A)  XML 
B)  EML 
C)  EXML 
D)  EMARK

Question 8

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

Accepted Answer

A)  cell 
B)  row 
C)  column 
D)  worksheet 
A)  cell 
B)  row 
C)  column 
D)  worksheet

Question 9

A(n) ____________________ is a question that you ask a database.

Accepted Answer

The answer of A(n) ____________________ is a question that you...

Question 10

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 11

XML documents are organized in a running tabular form with each element occupying ____.

Accepted Answer

A)  one line 
B)  one map 
C)  one column 
D)  one table 
A)  one line 
B)  one map 
C)  one column 
D)  one table

Question 12

A PivotChart report represents source data as a ____.

Accepted Answer

A)  graphic 
B)  presentation 
C)  worksheet 
D)  table 
A)  graphic 
B)  presentation 
C)  worksheet 
D)  table

Question 13

You can open the Export XML dialog box using the Export button in the XML group on the ____ tab.

Accepted Answer

A)  DEVELOPER 
B)  WEB 
C)  PROGRAMMING 
D)  WEB QUERY 
A)  DEVELOPER 
B)  WEB 
C)  PROGRAMMING 
D)  WEB QUERY

Question 14

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. _________________________

Accepted Answer

A) True 
 B)False

Question 15

Excel must load the entire workbook into memory when you open it, which can lead to performance problems ____.

Accepted Answer

A)  with very small lists 
B)  when adding column headings 
C)  with very large tables 
D)  when using functions 
A)  with very small lists 
B)  when adding column headings 
C)  with very large tables 
D)  when using functions

Question 16

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

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 17

The ____ Wizard separates the values in a text string into columns or fields.

Accepted Answer

A)  Convert Text to Columns 
B)  Convert Text 
C)  Separate Values 
D)  Convert Values 
A)  Convert Text to Columns 
B)  Convert Text 
C)  Separate Values 
D)  Convert Values

Question 18

Placing a field in the Row Labels area of a PivotTable displays data from that field in columns and rows.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ function calculates the number of years between the two dates.

Accepted Answer

The answer of The ____________________ function calculates the number of...

A common way of storing data so that it is usable in other programs is to save it in a ____ file.

In the RIGHT function, the argument called ____ is the text string or cell reference that contains the characters you want to extract.

____ adds meaning to content by providing a description of the data through user-defined elements, and a hierarchical structure that shows the relationship of one data element to another.

Hypertext Markup Language is the markup language that creates Web pages.

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

The DOLLAR function converts a number to ____ in currency format with a dollar sign and the specified number of decimal places.

____ is the acronym for Extensible Markup Language.

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

A(n) ____________________ is a question that you ask a database.

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

XML documents are organized in a running tabular form with each element occupying ____.

A PivotChart report represents source data as a ____.

You can open the Export XML dialog box using the Export button in the XML group on the ____ tab.

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. _________________________

Excel must load the entire workbook into memory when you open it, which can lead to performance problems ____.

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

The ____ Wizard separates the values in a text string into columns or fields.

Placing a field in the Row Labels area of a PivotTable displays data from that field in columns and rows.

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

The ____________________ function calculates the number of years between the two dates.

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

A common way of storing data so that it is usable in other programs is to save it in a ____ file.

In the RIGHT function, the argument called ____ is the text string or cell reference that contains the characters you want to extract.

____ adds meaning to content by providing a description of the data through user-defined elements, and a hierarchical structure that shows the relationship of one data element to another.

Hypertext Markup Language is the markup language that creates Web pages.

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

The DOLLAR function converts a number to ____ in currency format with a dollar sign and the specified number of decimal places.

____ is the acronym for Extensible Markup Language.

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

A(n) ____________________ is a question that you ask a database.

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

XML documents are organized in a running tabular form with each element occupying ____.

A PivotChart report represents source data as a ____.

You can open the Export XML dialog box using the Export button in the XML group on the ____ tab.

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. _________________________

Excel must load the entire workbook into memory when you open it, which can lead to performance problems ____.

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

The ____ Wizard separates the values in a text string into columns or fields.

Placing a field in the Row Labels area of a PivotTable displays data from that field in columns and rows.

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

The ____________________ function calculates the number of years between the two dates.

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