Text Functions (Grade 12 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What does the LEFT function extract from a text string?
What does the LEFT function extract from a text string?
Characters from the beginning of the text
If =RIGHT("Amanda",2) is used, what is the result?
If =RIGHT("Amanda",2) is used, what is the result?
da
What makes the MID function different from LEFT and RIGHT functions?
What makes the MID function different from LEFT and RIGHT functions?
MID always requires start position
Why is the ampersand (&) operator preferred over CONCATENATE?
Why is the ampersand (&) operator preferred over CONCATENATE?
It's faster to type and easier to read
How many characters does =LEN("Amanda Carter") return?
How many characters does =LEN("Amanda Carter") return?
13
What does =VALUE("20%") convert to?
What does =VALUE("20%") convert to?
0.2
What is a key characteristic of the FIND function?
What is a key characteristic of the FIND function?
It is case-sensitive
What does =LEFT(B2,FIND(",",B2)-1) accomplish?
What does =LEFT(B2,FIND(",",B2)-1) accomplish?
Extracts text before the comma
How many parameters does the MID function always require?
How many parameters does the MID function always require?
Three parameters
What happens when VALUE tries to convert text like "Hello"?
What happens when VALUE tries to convert text like "Hello"?
It returns an error