Question 1

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 2

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 3

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

Accepted Answer

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

Question 4

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)  #5F) #6G) #7

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

Question 6

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

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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)  #5F) #6G) #7

Question 16

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

Question 17

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Exam 7: Organizing Data for Effective Analysis

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct Answerverified1)First, the maximum number of rows and ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
1)First, the maximum number of rows and ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified