Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
23 Cards in this Set
- Front
- Back
To extract characters from the beginning side of a text string, use the _____ function.
|
LEFT
|
|
A set of fields that describes one product or person is a _____.
Question 2 answers |
record
|
|
The function of _____ returns the serial number of the last day of the month before or after a specified number of months.
|
EOMONTH
|
|
_____ is a function that will return the number of years between two dates.
|
YEARFRAC
|
|
T/F...The SEARCH function is case sensitive.
|
False
|
|
What function removes spaces from a text string, except for spaces between words?
|
TRIM
|
|
The _____ function determines the number of characters in a text string.
|
LEN
|
|
A _____ is a single characteristic of the entity. Examples include items such as a name, product ID number, or an address.
|
field
|
|
To join two or more text strings into a single string, you can use the _____ function.
|
CONCATENATE
|
|
To compare two text strings to determine if they are identical and case sensitive, use the _____ function.
|
EXACT
|
|
Use the _____ function to locate the position of an uppercase letter C in a text string, while ignoring any instance of a lowercase "c".
|
FIND
|
|
The _____ function returns the serial number of the date that is the indicated number of months before or after the start_date.
|
EDATE
|
|
To convert a value to text in the specified number format, use the _____ function.
|
TEXT
|
|
What's the best FUNCTION to use to change all instances of United States of America" to U.S.A.?
|
SUBSTITUTE
|
|
To remove all nonprintable characters from a text string, use the _____ function.
|
CLEAN
|
|
A _____ identifies the end of each record in a comma-delimited file.
|
paragraph mark
|
|
T/F...You cannot use the Subtotal tool (in the Data menu/ribbon) while your data is an Excel list (Excel 2003) or an Excel table (Excel 2007).
|
True
|
|
A _____ is a set of validation rules for an XML document.
|
schema
|
|
T/F...To convert lowercase letters in a text string to uppercase, use the UPPER function.
|
True
|
|
The _____ function returns the serial number of the current date and time.
|
NOW
|
|
What is the difference between the NOW and TODAY function?
|
NOW shows the time as well
|
|
T/F...The Subtotal tool allows you to perform multiple functions on your data (SUM and AVERAGE)
|
FALSE, only one at a time
|
|
A database is a collection of fields that describe a specific entity.
|
FALSE
|