Quiz Answer Key and Fun Facts
1. Cell a1 has this text message "this is a test sentence for this questions"
What will show in cell b1 containing the formula "=left(a1,3)" ?
2. Cell C1 contains the text "This is the text for question two."
What will this formula yield?
=Right(c1,4)
3. Cell E1 contains the following text, "Question three will use this text."
What will the following formula result in?
=right(left(e1,14),5)
4. Cell F1 has this message, "this information is for question four only"
What result will the below formula give?
=Left(mid(f1,10,12),4)
5. Cell G1 has the following message "texts can be of varying length and I want to get the middle five letters"
Which of the following formulas would return the desired result: the middle five letters of G1 (for any value of G1)?
6. Cell H1 says:
"The title of this quiz is a little left of center, so which formula would get the five characters that are before the centre of this sentence."
Which formula could be applied to cell H1 to give the result described?
7. The text in cell a3 is "This is the text for question seven"
What will the formula =upper(right(left(A3,10),4)) give?
8. Cell a10 contains the text message "firstname, lastname"
What result will the formula =proper(right(a10,find(", ",a10))) give?
9. Cell a10 still contains the text message "firstname, lastname"
What will the formula =proper(right(a10,len(a10)-1-find(",",a10))&","&left(a10)) give?
10. Cell a15 says "The title of this quiz is a little left of center, but I spell center as centre."
What will the following formula display?
=proper(substitute(A15,"center","centre",1))
Source: Author
ASA
This quiz was reviewed by FunTrivia editor
WesleyCrusher before going online.
Any errors found in FunTrivia content are routinely corrected through our feedback system.