MCQ

Top 100 MS-Excel Function MCQ

Q11. Which function is used to converts a number to baht text?

a) CHAR
b) BAHTTEXT
c) TEXT
d) TEXTJOIN

Answer – [B]


Q12. Which function is used to returns a character from a number?

a) CHAR
b) BAHTTEXT
c) TEXT
d) TEXTJOIN

Answer – [A]


Q13. Which function is used to converts a value to text in a specific number format?

a) CHAR
b) BAHTTEXT
c) TEXT
d) TEXTJOIN

Answer – [C]


Q14. Which function is used to join text values with a delimiter?

a) BAHTTEXT
b) CHAR
c) TEXT
d) TEXTJOIN

Answer – [D]


Q15. Which function is used to join text value without delimiter?

a) BAHTTEXT
b) TEXT
c) CONCAT
d) CHAR

Answer – [C]


Q16. Which function is used to join text together?

a) BAHTTEXT
b) TEXT
c) CONCATENATE
d) CHAR

Answer – [C]


Q17. Which function is used to remove all non-printable characters from text?

a) CHAR
b) CLEAN
c) TEXT
d) PRINT

Answer – [B]


Q18. Which function is used to return the unicode character by number?

a) UNICODE
b) UNICHAR
c) CHAR
d) CODE

Answer – [B]


Q19. Which function is used to returns the number from unicode character?

a) UNICODE
b) UNICHAR
c) CHAR
d) CODE

Answer – [A]


Q20. Which function is used to repeats a text a given number of times?

a) TEXT
b) REPLACE
c) TRIM
d) REPT

Answer – [D]