Shared Flashcard Set

Details

Text spreadsheet functions
Text spreadsheet functions for the NSS ICT curriculum.
16
Computer Science
10th Grade
12/08/2012

Additional Computer Science Flashcards

 


 

Cards

Term
CODE(text)
Definition
Find the ASCII code of the first character in a string.
Term
CHAR(number)
Definition
Find the character that corresponds to an ASCII code (written in denary).
Term
LEN(text)
Definition
Find the number of characters in a string (including space characters).
Term
LEFT(text, number of characters)
Definition
Find the leftmost characters in a string.
Term
MID(text, position of first character, number of characters)
Definition
Find a number of characters starting from a certain character.
Term
RIGHT(text, number of characters)
[Does not reverse the order of characters.]
Definition
Find the rightmost characters in a string.
Term
TEXT(number, string format)
[The format "0.00" will return a decimal with two places. "#,##0" will return an integer with commas separating every three digits. "0%" will return a percentage. The formats must be strings enclosed by double quotes!]
Definition
Convert a number into a string in the specified format.
Term
VALUE(text)
Definition
Return the numeric value of a text string which contains numerical characters.
Term
CONCATENATE(text 1, text 2 ... text n)
Definition
Concatenate the strings together.
Term
EXACT(text 1, text 2)
[This functions is case-sensitive.]
Definition
Determine whether two strings are exactly the same.
Term
LOWER(text)
Definition
Convert all uppercase characters in the string to lowercase.
Term
PROPER(text)
Definition
Convert the first character of each word in a text to uppercase, and the rest to lowercase.
Term
TRIM(text)
Definition
Remove all the spaces in a string.
Term
UPPER(text)
Definition
Convert all the lowercase characters in the string to uppercase.
Term
FIND(substring, string, first character)
[The returned value is not relative to the third argument.]
Definition
Find the position of a substring in a string starting from a certain character. This function is case-sensitive.
Term
SEARCH(substring, string, first character)
[The returned value is not relative to the third argument.]
Definition
Find the position of a substring in a string starting from a certain character. This function is not case-sensitive.
Supporting users have an ad free experience!