Question 1

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

Accepted Answer

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

Question 2

Identify the letter of the choice that best matches the date and time function.
-Converts a date in the form of text to a serial number

Accepted Answer

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

Question 3

A ____ identifies the end of each field in a comma-delimited file.

Accepted Answer

A)  paragraph mark 
B)  pound sign 
C)  comma 
D)  question mark 
A)  paragraph mark 
B)  pound sign 
C)  comma 
D)  question mark

Question 4

The TRIM function removes all spaces in a text string except for the single spaces between words.

Accepted Answer

A) True 
 B)False

Question 5

The TRIM function removes all spaces in a text string except for the single spaces ____.

Accepted Answer

A)  between numbers 
B)  between words 
C)  between cells 
D)  between worksheets 
A)  between numbers 
B)  between words 
C)  between cells 
D)  between worksheets

Question 6

Click the ____ option on the DATA tab on the ribbon to import Access data into Excel.

Accepted Answer

A)  From Access 
B)  Query Wizard 
C)  From Other Sources 
D)  From SQL Server 
A)  From Access 
B)  Query Wizard 
C)  From Other Sources 
D)  From SQL Server

Question 7

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

Accepted Answer

A)  left side 
B)  specified area 
C)  end 
D)  none of the above 
A)  left side 
B)  specified area 
C)  end 
D)  none of the above

Question 8

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

Accepted Answer

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

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

When you click a filter arrow in the header row, you can ____.

Accepted Answer

A)  sort the records in ascending or descending order 
B)  display the top 10 records 
C)  display records containing a specific value that appears in the column 
D)  all of the above 
A)  sort the records in ascending or descending order 
B)  display the top 10 records 
C)  display records containing a specific value that appears in the column 
D)  all of the above

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

MATCHING
   
Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above.
-PivotTable inserted on a new worksheet

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 14

____ is data that describes other data.

Accepted Answer

A)  Metadata 
B)  Superdata 
C)  Description data 
D)  A metatag 
A)  Metadata 
B)  Superdata 
C)  Description data 
D)  A metatag

Question 15

HTML documents are user-defined documents in which the user develops a DTD that defines the elements contained in a document.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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 wants to find a company that starts with the letter Z, but she can't remember its complete name. The quickest way to find the company name is to choose the ____ option.

Accepted Answer

A)  Sort Z to A 
B)  Sort A to Z 
C)  Text Filters 
D)  Date Filters 
A)  Sort Z to A 
B)  Sort A to Z 
C)  Text Filters 
D)  Date Filters

Question 18

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

Accepted Answer

A)  0 
B)  1 
C)  whatever is in the first cell of the range 
D)  none of the above 
A)  0 
B)  1 
C)  whatever is in the first cell of the range 
D)  none of the above

Question 19

You can use a text function to ____, or concatenate, the information from multiple cells into one cell.

Accepted Answer

A)  look up 
B)  link together 
C)  transform 
D)  calculate 
A)  look up 
B)  link together 
C)  transform 
D)  calculate

Question 20

The Subtotal command creates summary reports that quickly organize data into categories with subtotal calculations.

Accepted Answer

A) True 
 B)False

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

Identify the letter of the choice that best matches the date and time function. -Converts a date in the form of text to a serial number

A ____ identifies the end of each field in a comma-delimited file.

The TRIM function removes all spaces in a text string except for the single spaces between words.

The TRIM function removes all spaces in a text string except for the single spaces ____.

Click the ____ option on the DATA tab on the ribbon to import Access data into Excel.

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

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

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 LAST function returns the last character or characters in a text string, based on the number of characters specified. _________________________

When you click a filter arrow in the header row, you can ____.

A(n) PivotSheet report 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. -PivotTable inserted on a new worksheet

____ is data that describes other data.

HTML documents are user-defined documents in which the user develops a DTD that defines the elements contained in a document.

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

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

You can use a text function to ____, or concatenate, the information from multiple cells into one cell.

The Subtotal command creates summary reports that quickly organize data into categories with subtotal calculations.

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(n) ____________________ is a question that you ask a database.

Identify the letter of the choice that best matches the date and time function. -Converts a date in the form of text to a serial number

A ____ identifies the end of each field in a comma-delimited file.

The TRIM function removes all spaces in a text string except for the single spaces between words.

The TRIM function removes all spaces in a text string except for the single spaces ____.

Click the ____ option on the DATA tab on the ribbon to import Access data into Excel.

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

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

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 LAST function returns the last character or characters in a text string, based on the number of characters specified. _________________________

When you click a filter arrow in the header row, you can ____.

A(n) PivotSheet report 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. -PivotTable inserted on a new worksheet

____ is data that describes other data.

HTML documents are user-defined documents in which the user develops a DTD that defines the elements contained in a document.

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

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

You can use a text function to ____, or concatenate, the information from multiple cells into one cell.

The Subtotal command creates summary reports that quickly organize data into categories with subtotal calculations.

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