Question 1

​The ___________ function  joins,or concatenates,two or more text values.​

Accepted Answer

A)  ​CONCATENATE 
B)  ​PROPER 
C)  ​Paste Values 
D)  ​Columns 
A)  ​CONCATENATE 
B)  ​PROPER 
C)  ​Paste Values 
D)  ​Columns

Question 2

​The _________ function  converts the first letter of each word to uppercase,capitalizes any letter that does not follow another letter,and changes all other letters to lowercase.​

Accepted Answer

A)  ​CONCATENATE 
B)  ​PROPER 
C)  ​Paste Values 
D)  ​Columns 
A)  ​CONCATENATE 
B)  ​PROPER 
C)  ​Paste Values 
D)  ​Columns

Question 3

Text contains one or more characters and can include:​

Accepted Answer

A)  Spacers​ 
B)  ​Symbols 
C)  ​Numbers 
D)  ​All of the above 
A)  Spacers​ 
B)  ​Symbols 
C)  ​Numbers 
D)  ​All of the above

Question 4

The Search text function returns the number of characters at which the locate_character is first found reading from left to right.​

Accepted Answer

A) True 
 B)False

Question 5

Custom formats use _______ codes ,which are a series of symbols.​

Accepted Answer

A)  ​Custom 
B)  ​Format 
C)  ​Text 
D)  ​None of the above 
A)  ​Custom 
B)  ​Format 
C)  ​Text 
D)  ​None of the above

Question 6

Excel makes special note of ___________ zeros,which are zeros whose omission from the number does not change the number's value​

Accepted Answer

A)  Insignificant​ 
B)  ​Special 
C)  ​Custom 
D)  ​Proper 
A)  Insignificant​ 
B)  ​Special 
C)  ​Custom 
D)  ​Proper

Question 7

​You can use the LEN and LEFT functions nested in a(n)____ function to convert all of the zip codes to the shorter form.

Accepted Answer

A)  ​IF 
B)  ​MID 
C)  ​Text 
D)  ​PROPER 
A)  ​IF 
B)  ​MID 
C)  ​Text 
D)  ​PROPER

Question 8

This symbol displays Months as 1 through 12:​

Accepted Answer

A)  ​m 
B)  ​mm 
C)  ​mmm 
D)  ​mmmm 
A)  ​m 
B)  ​mm 
C)  ​mmm 
D)  ​mmmm

Question 9

The UPPER function converts all letters of each word in a text string to uppercase.​

Accepted Answer

A) True 
 B)False

Question 10

​The four most commonly used formats are called special formats.​

Accepted Answer

A) True 
 B)False

Question 11

When you have dates,times,or both in a workbook,you can use a ________ date and time format to display this information in a readable format.​

Accepted Answer

A)  Custom​ 
B)  ​Special 
C)  ​Predefined 
D)  ​Insignificant 
A)  Custom​ 
B)  ​Special 
C)  ​Predefined 
D)  ​Insignificant

Question 12

When you save an Excel 2007,2010,2013,or 2016 workbook in an earlier format the Compatibility ______ alerts you to any features that are not supported by earlier versions of Excel.

Accepted Answer

A)  ​Processor 
B)  ​Checker 
C)  ​Finder 
D)  ​None of the above 
A)  ​Processor 
B)  ​Checker 
C)  ​Finder 
D)  ​None of the above

Question 13

To have access to all the latest features and tools in Excel 2016,you must convert the workbook to the current file format,which has the .xlsx file extension.​

Accepted Answer

A) True 
 B)False

Question 14

​You can use Text functions to:

Accepted Answer

A)  return the number of characters in a string 
B)  remove extra spaces​ 
C)  ​change the case of text strings 
D)  ​all of the above 
A)  return the number of characters in a string 
B)  remove extra spaces​ 
C)  ​change the case of text strings 
D)  ​all of the above

Question 15

Another work for edit is clean or:​​

Accepted Answer

A)  Wipe​ 
B)  Wash​ 
C)  ​Scrub 
D)  ​Polish 
A)  Wipe​ 
B)  Wash​ 
C)  ​Scrub 
D)  ​Polish

The ___________ function joins,or concatenates,two or more text values.

The _________ function converts the first letter of each word to uppercase,capitalizes any letter that does not follow another letter,and changes all other letters to lowercase.

Text contains one or more characters and can include:

The Search text function returns the number of characters at which the locate_character is first found reading from left to right.

Custom formats use _______ codes ,which are a series of symbols.

Excel makes special note of ___________ zeros,which are zeros whose omission from the number does not change the number's value

You can use the LEN and LEFT functions nested in a(n)____ function to convert all of the zip codes to the shorter form.

This symbol displays Months as 1 through 12:

The UPPER function converts all letters of each word in a text string to uppercase.

The four most commonly used formats are called special formats.

When you have dates,times,or both in a workbook,you can use a ________ date and time format to display this information in a readable format.

When you save an Excel 2007,2010,2013,or 2016 workbook in an earlier format the Compatibility ______ alerts you to any features that are not supported by earlier versions of Excel.

To have access to all the latest features and tools in Excel 2016,you must convert the workbook to the current file format,which has the .xlsx file extension.

You can use Text functions to:

Another work for edit is clean or:

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Filters

Exam 13: Working With Text Functions

​The ___________ function joins,or concatenates,two or more text values.​

​The _________ function converts the first letter of each word to uppercase,capitalizes any letter that does not follow another letter,and changes all other letters to lowercase.​

Text contains one or more characters and can include:​

The Search text function returns the number of characters at which the locate_character is first found reading from left to right.​

Custom formats use _______ codes ,which are a series of symbols.​

Excel makes special note of ___________ zeros,which are zeros whose omission from the number does not change the number's value​

​You can use the LEN and LEFT functions nested in a(n)____ function to convert all of the zip codes to the shorter form.

This symbol displays Months as 1 through 12:​

The UPPER function converts all letters of each word in a text string to uppercase.​

​The four most commonly used formats are called special formats.​

When you have dates,times,or both in a workbook,you can use a ________ date and time format to display this information in a readable format.​

When you save an Excel 2007,2010,2013,or 2016 workbook in an earlier format the Compatibility ______ alerts you to any features that are not supported by earlier versions of Excel.

To have access to all the latest features and tools in Excel 2016,you must convert the workbook to the current file format,which has the .xlsx file extension.​

​You can use Text functions to:

Another work for edit is clean or:​​

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Filters

The ___________ function joins,or concatenates,two or more text values.

The _________ function converts the first letter of each word to uppercase,capitalizes any letter that does not follow another letter,and changes all other letters to lowercase.

Text contains one or more characters and can include:

The Search text function returns the number of characters at which the locate_character is first found reading from left to right.

Custom formats use _______ codes ,which are a series of symbols.

Excel makes special note of ___________ zeros,which are zeros whose omission from the number does not change the number's value

You can use the LEN and LEFT functions nested in a(n)____ function to convert all of the zip codes to the shorter form.

This symbol displays Months as 1 through 12:

The UPPER function converts all letters of each word in a text string to uppercase.

The four most commonly used formats are called special formats.

When you have dates,times,or both in a workbook,you can use a ________ date and time format to display this information in a readable format.

To have access to all the latest features and tools in Excel 2016,you must convert the workbook to the current file format,which has the .xlsx file extension.

You can use Text functions to:

Another work for edit is clean or: