Question 1

When multiple pieces of data are stored in one cell,you can separate each piece of data into a different column by using the ______ to Columns command.​

Accepted Answer

A)  Row​ 
B)  ​Cell 
C)  ​Text 
D)  ​None of the above 
A)  Row​ 
B)  ​Cell 
C)  ​Text 
D)  ​None of the above C

Question 2

​To help users edit and correct the text values in their workbooks,Excel provides _____ functions.​

Accepted Answer

A)  ​Text 
B)  ​Proof 
C)  ​Design 
D)  ​Symbol 
A)  ​Text 
B)  ​Proof 
C)  ​Design 
D)  ​Symbol A

Question 3

The Trim function removes all characters from a string except for single spaces between words.​

Accepted Answer

A) True 
 B)False  False

Question 4

​​​The Zip column in the Members worksheet includes zip codes in both five-digit and ___-digit formats.​

Accepted Answer

A)  ​6 
B)  ​8 
C)  ​10 
D)  ​12 
A)  ​6 
B)  ​8 
C)  ​10 
D)  ​12

Question 5

To format a value,Excel uses the placeholders represent individual digits.​

Accepted Answer

A) True 
 B)False

Question 6

​Text is also referred to as __________.​

Accepted Answer

A)  ​Text string 
B)  ​String 
C)  ​String text 
D)  ​a & b 
A)  ​Text string 
B)  ​String 
C)  ​String text 
D)  ​a & b

Question 7

Which of the following is not one of the four commonly used formats?​

Accepted Answer

A)  ​Zip code 
B)  ​Phone number 
C)  ​Social Security 
D)  ​Birth date 
A)  ​Zip code 
B)  ​Phone number 
C)  ​Social Security 
D)  ​Birth date

Question 8

​You can separate data with a:​

Accepted Answer

A)  ​Tab 
B)  ​Semicolon or comma 
C)  ​Space 
D)  ​All of the above 
A)  ​Tab 
B)  ​Semicolon or comma 
C)  ​Space 
D)  ​All of the above

Question 9

​A workbook will convert to Compatibility Mode if it was created in Excel 2003 or earlier.

Accepted Answer

A) True 
 B)False

Question 10

This is a digital placeholder that replaces insignificant zeros with spaces on either side of the decimal point so that decimal points align when formatted with a fixed-width font,such as Courier.​

Accepted Answer

A)  ​# 
B)  ​0 
C)  ​? 
D)  ​None of the above 
A)  ​# 
B)  ​0 
C)  ​? 
D)  ​None of the above

Question 11

The PROPER function  replaces existing text with new text.​

Accepted Answer

A) True 
 B)False

Question 12

​The LEN function returns the number of characters in a string.

Accepted Answer

A) True 
 B)False

Question 13

This symbol displays days as Sun through Sat:​

Accepted Answer

A)  ​d 
B)  ​dd 
C)  ​ddd 
D)  ​dddd 
A)  ​d 
B)  ​dd 
C)  ​ddd 
D)  ​dddd

Question 14

​Compatibility Mode keeps the workbook in the older file format with the .xsl file extension.

Accepted Answer

A) True 
 B)False

Question 15

​Which of the following is not considered a text function from this text?​

Accepted Answer

A)  ​LEFT 
B)  ​MID 
C)  PROPER 
D)  ​CROP 
A)  ​LEFT 
B)  ​MID 
C)  PROPER 
D)  ​CROP

Question 16

​Another word for separating data is:​

Accepted Answer

A)  ​Delimit 
B)  ​CONCATENATE 
C)  ​LEN 
D)  ​Scrub 
A)  ​Delimit 
B)  ​CONCATENATE 
C)  ​LEN 
D)  ​Scrub

Question 17

This is a digital placeholder that displays only significant digits; insignificant zeros are omitted.​

Accepted Answer

A)  ​# 
B)  ​0 
C)  ​? 
D)  ​None of the above 
A)  ​# 
B)  ​0 
C)  ​? 
D)  ​None of the above

Question 18

​Text can contain:

Accepted Answer

A)  ​Uppercase only 
B)  ​Lowercase only 
C)  ​Upper and lowercase 
D)  ​Numbers only 
A)  ​Uppercase only 
B)  ​Lowercase only 
C)  ​Upper and lowercase 
D)  ​Numbers only

Question 19

Custom formats describe how Excel should display a:​

Accepted Answer

A)  ​Date or number 
B)  ​Time 
C)  ​Text string 
D)  ​All of the above 
A)  ​Date or number 
B)  ​Time 
C)  ​Text string 
D)  ​All of the above

Question 20

The RIGHT function returns a specified number of characters are the right of the string.​

Accepted Answer

A) True 
 B)False

When multiple pieces of data are stored in one cell,you can separate each piece of data into a different column by using the ______ to Columns command.

To help users edit and correct the text values in their workbooks,Excel provides _____ functions.

The Trim function removes all characters from a string except for single spaces between words.

The Zip column in the Members worksheet includes zip codes in both five-digit and ___-digit formats.

To format a value,Excel uses the placeholders represent individual digits.

Text is also referred to as __________.

Which of the following is not one of the four commonly used formats?

You can separate data with a:

A workbook will convert to Compatibility Mode if it was created in Excel 2003 or earlier.

This is a digital placeholder that replaces insignificant zeros with spaces on either side of the decimal point so that decimal points align when formatted with a fixed-width font,such as Courier.

The PROPER function replaces existing text with new text.

The LEN function returns the number of characters in a string.

This symbol displays days as Sun through Sat:

Compatibility Mode keeps the workbook in the older file format with the .xsl file extension.

Which of the following is not considered a text function from this text?

Another word for separating data is:

This is a digital placeholder that displays only significant digits; insignificant zeros are omitted.

Text can contain:

Custom formats describe how Excel should display a:

The RIGHT function returns a specified number of characters are the right of the string.

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

When multiple pieces of data are stored in one cell,you can separate each piece of data into a different column by using the ______ to Columns command.​

​To help users edit and correct the text values in their workbooks,Excel provides _____ functions.​

The Trim function removes all characters from a string except for single spaces between words.​

​​​The Zip column in the Members worksheet includes zip codes in both five-digit and ___-digit formats.​

To format a value,Excel uses the placeholders represent individual digits.​

​Text is also referred to as __________.​

Which of the following is not one of the four commonly used formats?​

​You can separate data with a:​

​A workbook will convert to Compatibility Mode if it was created in Excel 2003 or earlier.

This is a digital placeholder that replaces insignificant zeros with spaces on either side of the decimal point so that decimal points align when formatted with a fixed-width font,such as Courier.​

The PROPER function replaces existing text with new text.​

​The LEN function returns the number of characters in a string.

This symbol displays days as Sun through Sat:​

​Compatibility Mode keeps the workbook in the older file format with the .xsl file extension.

​Which of the following is not considered a text function from this text?​

​Another word for separating data is:​

This is a digital placeholder that displays only significant digits; insignificant zeros are omitted.​

​Text can contain:

Custom formats describe how Excel should display a:​

The RIGHT function returns a specified number of characters are the right of the string.​

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

When multiple pieces of data are stored in one cell,you can separate each piece of data into a different column by using the ______ to Columns command.

To help users edit and correct the text values in their workbooks,Excel provides _____ functions.

The Trim function removes all characters from a string except for single spaces between words.

The Zip column in the Members worksheet includes zip codes in both five-digit and ___-digit formats.

To format a value,Excel uses the placeholders represent individual digits.

Text is also referred to as __________.

Which of the following is not one of the four commonly used formats?

You can separate data with a:

A workbook will convert to Compatibility Mode if it was created in Excel 2003 or earlier.

This is a digital placeholder that replaces insignificant zeros with spaces on either side of the decimal point so that decimal points align when formatted with a fixed-width font,such as Courier.

The PROPER function replaces existing text with new text.

The LEN function returns the number of characters in a string.

This symbol displays days as Sun through Sat:

Compatibility Mode keeps the workbook in the older file format with the .xsl file extension.

Which of the following is not considered a text function from this text?

Another word for separating data is:

This is a digital placeholder that displays only significant digits; insignificant zeros are omitted.

Text can contain:

Custom formats describe how Excel should display a:

The RIGHT function returns a specified number of characters are the right of the string.