Question 1

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

Accepted Answer

The question describes a feature of the '?' placeholder in some programming and formatting languages, which aligns decimal points by replacing insignificant zeros with spaces.

Question 2

This is a digital placeholder that displays only significant digits; insignificant zeros are omitted.​ 
A) ​# 
B) ​0 
C) ​? 
D) ​None of the above

Accepted Answer

The symbol # is commonly used as a placeholder to represent significant digits in a number. It indicates that there is a digit in that place value, but the value of that digit is not specified. This is commonly used in accounting, financial reports or in scientific calculations.

Question 3

This symbol displays Months as 1 through 12:​ 
A) ​m 
B) ​mm 
C) ​mmm 
D) ​mmmm

Accepted Answer

The answer of This symbol displays Months as 1 through...

Question 4

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

Accepted Answer

The Text to Columns command allows you to separate data within a cell by a delimiter (such as a comma or space) and place each piece of data into its own column.

Question 5

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

Accepted Answer

Predefined date and time formats are built-in formats in spreadsheet software like Excel that allow users to display dates and times in a standard, readable format without needing to create a custom format.

Question 6

Custom formats use _______ codes ,which are a series of symbols.​ 
A) ​Custom 
B) ​Format 
C) ​Text 
D) ​None of the above

Accepted Answer

Custom formats use format codes, which are a series of symbols. These symbols represent different formatting options such as currency, date, time, and text. By using custom formats, you can display data in a way that is easier to read and understand.

Question 7

​Another word for separating data is:​ 
A) ​Delimit 
B) ​CONCATENATE 
C) ​LEN 
D) ​Scrub

Accepted Answer

Delimit means to separate, divide or mark boundaries. In the context of data, delimiting is often used to separate values or fields in a dataset, making it easier to organize and analyze the data. Concatenate means to combine multiple strings or values into one, LEN is a function used in Excel to count the number of characters in a cell, and Scrub means to clean or remove unwanted data.

Question 8

​The ___________ function  joins,or concatenates,two or more text values.​ 
A) ​CONCATENATE 
B) ​PROPER 
C) ​Paste Values 
D) ​Columns

Accepted Answer

The CONCATENATE function is used to join, or concatenate, two or more text values into one cell. The other options are not relevant to text concatenation.

Question 9

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

Accepted Answer

Birth date is not one of the four commonly used formats for identification. Zip code, phone number, and Social Security are all commonly used formats for identification.

Question 10

This symbol displays days as Sun through Sat:​ 
A) ​d 
B) ​dd 
C) ​ddd 
D) ​dddd

Accepted Answer

This choice will display the three-letter day abbreviations for each day of the week from Sunday (Sun) through Saturday (Sat), such as Sun, Mon, Tue, Wed, Thu, Fri, Sat. Choice A (d) will only display the day of the month (1-31), choice B (dd) will add a leading zero to single-digit days (01-31), and choice D (dddd) will display the full day of the week name (Sunday, Monday, Tuesday, etc.).

Question 11

​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

Accepted Answer

The PROPER function is specifically designed to convert the first letter of each word to uppercase and all other letters to lowercase, while also capitalizing any letter that does not follow another letter. CONCATENATE is a function used to join together text from multiple cells into one cell, Paste Values is a function used to replace a formula with the actual value, and Columns is not a function but rather a reference to a group of cells in a column.

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.
A) ​Processor 
B) ​Checker 
C) ​Finder 
D) ​None of the above

Accepted Answer

The Compatibility Checker is a tool that alerts you to any features in your Excel 2007, 2010, 2013 or 2016 workbook that are not supported by earlier versions of Excel. It is designed to help you identify any issues that may occur when you save your workbook in an earlier file format, so you can make any necessary changes to ensure compatibility.

Question 13

​You can separate data with a:​ 
A) ​Tab 
B) ​Semicolon or comma 
C) ​Space 
D) ​All of the above

Accepted Answer

Data can be separated using a tab, semicolon, comma, or space, depending on the format and requirements of the data structure or system being used.

Question 14

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

Accepted Answer

Excel refers to these zeros as insignificant because they do not contribute to the number's value and are only used to maintain the number's formatting or alignment.

Question 15

Custom formats describe how Excel should display a:​ 
A) ​Date or number 
B) ​Time 
C) ​Text string 
D) ​All of the above

Accepted Answer

Custom formats can be used to display different formats for dates, numbers, times, and text strings. Therefore, the correct answer is D, which is "All of the above".

Quiz 13: Working With Text Functions

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

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

This symbol displays Months as 1 through 12:​

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

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

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

​Another word for separating data is:​

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

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

This symbol displays days as Sun through Sat:​

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

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.

​You can separate data with a:​

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

Custom formats describe how Excel should display a:​

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.

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

This symbol displays Months as 1 through 12:

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.

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.

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

Another word for separating data is:

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

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

This symbol displays days as Sun through Sat:

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.

You can separate data with a:

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

Custom formats describe how Excel should display a: