Deck 13: Working With Text Functions

Question 1

​Text can contain: 

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

Answer 1

  C

Question 2

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

Answer 2

  False
removes all spaces

Question 3

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

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

Answer 3

  D

Question 4

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

Question 5

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

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

Question 6

​Text is also referred to as __________.​ 

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

Question 7

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

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

Question 8

​You can use Text functions to: 

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 9

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

Question 10

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

Question 11

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.​ 

Question 12

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

Question 13

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

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

Question 14

 Text contains one or more characters and can include:​ 

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

Question 15

The PROPER function  replaces existing text with new text.​

Question 16

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

Question 17

Another work for edit is clean or:​​ 

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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.​ 

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

Question 22

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

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

Question 23

This symbol displays Months as 1 through 12:​ 

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

Question 24

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.​ 

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

Question 25

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.​ 

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

Question 26

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

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

Question 27

​Another word for separating data is:​ 

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

Question 28

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

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

Question 29

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

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

Question 30

This symbol displays days as Sun through Sat:​ 

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

Question 31

​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.​ 

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

Question 32

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.

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

Question 33

​You can separate data with a:​ 

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

Question 34

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

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

Question 35

Custom formats describe how Excel should display a:​ 

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