Question 1

The syntax for the TRIM function is as follows: =TRIM(____).

Accepted Answer

A)  num 
B)  text 
C)  cell 
D)  range 
A)  num 
B)  text 
C)  cell 
D)  range

Question 2

To add a new row to an XML table, you use the handle in the lower-right cell of the XML table to ____. You can then type or copy values into the cells.

Accepted Answer

A)  increase the size of the table 
B)  open a menu 
C)  rotate the bottom row 
D)  none of the above 
A)  increase the size of the table 
B)  open a menu 
C)  rotate the bottom row 
D)  none of the above

Question 3

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 4

When you create an Excel table, drop-down list arrows appear in the header row for each column when the ArrowFilter feature is enabled. _________________________

Accepted Answer

A) True 
 B)False

Question 5

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 6

A(n) ____________________ is a set of validation rules for an XML document.

Accepted Answer

The answer of A(n) ____________________ is a set of validation...

Question 7

In the FIND function, ____ is the text that you want to find.

Accepted Answer

A)  find_text 
B)  find_words 
C)  text_find 
D)  words_find 
A)  find_text 
B)  find_words 
C)  text_find 
D)  words_find

Question 8

The Subtotal command creates summary reports that let you ____ the level of detail in a report.

Accepted Answer

A)  collapse 
B)  expand 
C)  both a and b 
D)  neither a nor b 
A)  collapse 
B)  expand 
C)  both a and b 
D)  neither a nor b

Question 9

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 10

Excel table data is organized in rows and columns, where each column defines a record. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Creating an Excel table lets you add some simple database functionality to a worksheet, but an Excel table has two limitations that are important to understand. What are they?

Accepted Answer

1)First, the maximum number of rows and

Question 12

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 13

Dividing text into columns is also referred to as parsing text into columns.

Accepted Answer

A) True 
 B)False

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.
-VALUES 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 FIXED function rounds a number to a specified number of decimals and returns the number as text with ____.

Accepted Answer

A)  commas 
B)  a period 
C)  both a and b 
D)  neither a nor b 
A)  commas 
B)  a period 
C)  both a and b 
D)  neither a nor b

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

In the RIGHT function, the argument called ____ specifies the number of characters that you want the RIGHT function to extract.

Accepted Answer

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

Question 18

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

Accepted Answer

The answer of The ____________________ function removes all spaces in...

Question 19

In the FIND function ____ is the character position in which to start the search.

Accepted Answer

A)  start_num 
B)  num_start 
C)  char_pos 
D)  pos_char 
A)  start_num 
B)  num_start 
C)  char_pos 
D)  pos_char

Question 20

Excel includes several external data sources saved as database files that you can use to import data into Excel.

Accepted Answer

A) True 
 B)False

The syntax for the TRIM function is as follows: =TRIM(____).

To add a new row to an XML table, you use the handle in the lower-right cell of the XML table to ____. You can then type or copy values into the cells.

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

When you create an Excel table, drop-down list arrows appear in the header row for each column when the ArrowFilter feature is enabled. _________________________

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

A(n) ____________________ is a set of validation rules for an XML document.

In the FIND function, ____ is the text that you want to find.

The Subtotal command creates summary reports that let you ____ the level of detail in a report.

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

Excel table data is organized in rows and columns, where each column defines a record. _________________________

Creating an Excel table lets you add some simple database functionality to a worksheet, but an Excel table has two limitations that are important to understand. What are they?

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

Dividing text into columns is also referred to as parsing text into columns.

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

The FIXED function rounds a number to a specified number of decimals and returns the number as text with ____.

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

In the RIGHT function, the argument called ____ specifies the number of characters that you want the RIGHT function to extract.

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

In the FIND function ____ is the character position in which to start the search.

Excel includes several external data sources saved as database files that you can use to import data into Excel.

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 syntax for the TRIM function is as follows: =TRIM(____).

To add a new row to an XML table, you use the handle in the lower-right cell of the XML table to ____. You can then type or copy values into the cells.

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

When you create an Excel table, drop-down list arrows appear in the header row for each column when the ArrowFilter feature is enabled. _________________________

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

A(n) ____________________ is a set of validation rules for an XML document.

In the FIND function, ____ is the text that you want to find.

The Subtotal command creates summary reports that let you ____ the level of detail in a report.

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

Excel table data is organized in rows and columns, where each column defines a record. _________________________

Creating an Excel table lets you add some simple database functionality to a worksheet, but an Excel table has two limitations that are important to understand. What are they?

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

Dividing text into columns is also referred to as parsing text into columns.

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

The FIXED function rounds a number to a specified number of decimals and returns the number as text with ____.

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

In the RIGHT function, the argument called ____ specifies the number of characters that you want the RIGHT function to extract.

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

In the FIND function ____ is the character position in which to start the search.

Excel includes several external data sources saved as database files that you can use to import data into Excel.

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