Quiz 7

Question 1

The FIND function is case sensitive.

Answer 1

TRUE

Question 2

A___ is a set of validation rules for an XML document.

Answer 2

schema

Question 3

To extract characters from the beginning side of a text string, use the _____ function.

Answer 3

Left

Question 4

The _____ function returns the serial number of the current date and time.

Answer 4

NOW

Question 5

The _____ function determines the number of characters in a text string.

Answer 5

Len

Question 6

What is a database?

Answer 6

Set of related data that is stored in tables

Question 7

_____ is a function that will return the number of years between two dates.

Answer 7

YEARFRAC

Question 8

A common way of storing data so that it is usable in other programs is to save it in a comma-separated values (CSV) file.

Answer 8

True

Question 9

A _____ is a single characteristic of the entity. Examples include items such as a name, product ID number, or an address.

Answer 9

Field

Question 10

You cannot use the SUBTOTAL function, =SUBTOTAL(…), on data that has been converted to an Excel “Table.”

Answer 10

False

Question 11

The & symbol can be used to join two different text phrases or join a text phrase and the result of a formula.

Answer 11

True

Question 12

To convert lowercase letters in a text string to uppercase, use the ____ function.

Answer 12

Upper

Question 13

To compare two text strings to determine if they are identical (case sensitive), use the _____ function.

Answer 13

Exact

Question 14

A set of fields that describes one product or person is a _____.

Answer 14

record

Question 15

The function of _____ returns the serial number of the last day of the month before or after a specified number of months.

Answer 15

EOMONTH

Question 16

To remove all nonprintable characters from a text string, use the _____ function.

Answer 16

Clean

Question 17

Sorting by ascending order is from…?

Answer 17

A to Z

Question 18

To convert a value to text in the specified number format, use the _____ function.

Answer 18

Text

Question 19

XML stands for extensible ___________.

Answer 19

markup language

Question 20

To join two or more text strings into a single string, you can use the _____ function.

Answer 20

CONCATENATE

Question 21

What’s the best FUNCTION to use to change all instances of United States of America” to U.S.A. ?

Answer 21

SUBSTITUTE

Question 22

The SEARCH function is case sensitive.

Answer 22

False

Question 23

_____ can be used as a method to share data and a description of that data in an open nonproprietary format for use by different programs.

Answer 23

XML

Question 24

To remove spaces from a text string, except for spaces between words, use the _____ function.

Answer 24

TRIM

Question 25

The _____ function returns the serial number of the date that is the indicated number of months before or after the start_date.

Answer 25

EDATE

Question 26

A _____ identifies the end of each record in a comma-delimited file.

Answer 26

paragraph mark

Question 27

The TRIM function removes all spaces from a text string, including spaces between words.

Answer 27

False

Question 28

Use the _____ function to locate the position of an uppercase letter C in a text string, while ignoring any instance of a lowercase “c”.

Answer 28

FIND

Question 29

A _____ identifies the end of each record in a comma-delimited file.

Answer 29

paragraph mark