{"id":84118,"date":"2025-11-11T06:40:14","date_gmt":"2025-11-11T06:40:14","guid":{"rendered":"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/"},"modified":"2025-11-11T06:40:14","modified_gmt":"2025-11-11T06:40:14","slug":"20-excel-text-functions-quiz-questions-and-answers","status":"publish","type":"post","link":"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/","title":{"rendered":"20 Excel Text Functions Quiz Questions and Answers"},"content":{"rendered":"<p>Excel&#8217;s text functions are essential tools for manipulating and analyzing string data. Below is a concise overview of key text functions, categorized for clarity:<\/p>\n<p>Basic String Extraction Functions<br \/>\n&#8211; LEFT(text, [num_chars]): Extracts a specified number of characters from the beginning of a text string. Example: `=LEFT(A1, 3)` gets the first three characters from cell A1.<br \/>\n&#8211; RIGHT(text, [num_chars]): Extracts a specified number of characters from the end of a text string. Example: `=RIGHT(A1, 2)` gets the last two characters.<br \/>\n&#8211; MID(text, start_num, num_chars): Extracts a substring from the middle of a text string, starting at a specified position. Example: `=MID(A1, 2, 4)` starts from the second character and takes four characters.<\/p>\n<p>String Length and Case Functions<br \/>\n&#8211; LEN(text): Returns the number of characters in a text string. Example: `=LEN(A1)` counts the characters in cell A1.<br \/>\n&#8211; UPPER(text): Converts text to uppercase. Example: `=UPPER(A1)` makes all letters uppercase.<br \/>\n&#8211; LOWER(text): Converts text to lowercase. Example: `=LOWER(A1)` makes all letters lowercase.<br \/>\n&#8211; PROPER(text): Capitalizes the first letter of each word in a text string. Example: `=PROPER(A1)` formats text like a proper noun.<\/p>\n<p>Text Combination and Cleaning Functions<br \/>\n&#8211; CONCATENATE(text1, [text2], &#8230;) or CONCAT(text1, [text2], &#8230;): Joins two or more text strings into one. Example: `=CONCAT(A1, &#8221; &#8220;, B1)` combines values from A1 and B1 with a space.<br \/>\n&#8211; TRIM(text): Removes extra spaces from text except for single spaces between words. Example: `=TRIM(A1)` cleans up messy text.<br \/>\n&#8211; SUBSTITUTE(text, old_text, new_text, [instance_num]): Replaces existing text with new text in a string. Example: `=SUBSTITUTE(A1, &#8220;old&#8221;, &#8220;new&#8221;)` swaps &#8220;old&#8221; with &#8220;new&#8221;.<\/p>\n<p>Search and Replacement Functions<br \/>\n&#8211; FIND(find_text, within_text, [start_num]): Returns the starting position of specified text within a string (case-sensitive). Example: `=FIND(&#8220;a&#8221;, A1)` finds the position of &#8220;a&#8221;.<br \/>\n&#8211; SEARCH(find_text, within_text, [start_num]): Similar to FIND but not case-sensitive. Example: `=SEARCH(&#8220;A&#8221;, A1)` ignores case.<br \/>\n&#8211; REPLACE(old_text, start_num, num_chars, new_text): Replaces part of a text string with new text. Example: `=REPLACE(A1, 1, 2, &#8220;New&#8221;)` replaces the first two characters.<\/p>\n<p>Advanced Tips<br \/>\n&#8211; These functions can be nested for complex operations, e.g., combining MID with UPPER for extracted text in uppercase.<br \/>\n&#8211; Always use them in combination with other functions like IF or VLOOKUP for dynamic data handling.<br \/>\n&#8211; For newer Excel versions, TEXTJOIN is useful for joining arrays of text with a delimiter: `=TEXTJOIN(&#8220;, &#8220;, TRUE, A1:A10)`. <\/p>\n<p>This overview covers the most commonly used text functions to help with everyday tasks in Excel.<\/p>\n<h3>Table of Contents<\/h3>\n<ul class=\"article_list\">\n<li><a href=\"#1\">Part 1: OnlineExamMaker AI Quiz Generator &#8211; Save Time and Efforts<\/a><\/li>\n<li><a href=\"#2\">Part 2: 20 Excel Text Functions Quiz Questions &#038; Answers<\/a><\/li>\n<li><a href=\"#3\">Part 3: OnlineExamMaker AI Question Generator: Generate Questions for Any Topic <\/a><\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2026\/01\/2709-Excel-Text-Functions-quiz.webp\" alt=\"\"\/><\/p>\n<h3 id=\"1\">Part 1: OnlineExamMaker AI Quiz Generator &#8211; Save Time and Efforts<\/h3>\n<p>What&#8217;s the best way to create a Excel Text Functions quiz online? OnlineExamMaker is the best AI quiz making software for you. No coding, and no design skills required. If you don&#8217;t have the time to create your online quiz from scratch, you are able to use OnlineExamMaker AI Question Generator to create question automatically, then add them into your online assessment. What is more, the platform leverages AI proctoring and AI grading features to streamline the process while ensuring exam integrity.<\/p>\n<p><strong>Key features of OnlineExamMaker:<\/strong><br \/>\n\u25cf Combines AI webcam monitoring to capture cheating activities during online exam.<br \/>\n\u25cf Allow the quiz taker to answer by uploading video or a Word document, adding an image, and recording an audio file.<br \/>\n\u25cf Automatically scores multiple-choice, true\/false, and even open-ended\/audio responses using AI, reducing manual work.<br \/>\n\u25cf OnlineExamMaker API offers private access for developers to extract your exam data back into your system automatically.<\/p>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/zlqho9igH2Y\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">Automatically generate questions using AI<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html?refer=download_questions\" target=\"_blank\" rel=\"noopener\">Try AI Question Generator<\/a><\/div>\n<div class=\"p-style-b\">Generate questions for any topic<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> Create A Quiz<\/a><\/div>\n<div class=\"p-style-b\">100% free forever<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3 id=\"2\">Part 2: 20 Excel Text Functions Quiz Questions &#038; Answers<\/h3>\n<p><button id=\"copyquestionsBtn\" type=\"button\" onclick=\"myFunction()\">Copy Quiz Questions<\/button>\u00a0\u00a0or\u00a0\u00a0<button id=\"genquestionsBtn\" class=\"genbtnstyle\" type=\"button\" onclick=\"myFunction1()\">Generate Questions using AI<\/button><\/p>\n<div id=\"copy_questions\">\n<p>Question 1:<br \/>\nWhat does the LEN function in Excel do?<br \/>\nA) Converts text to lowercase<br \/>\nB) Returns the number of characters in a text string<br \/>\nC) Extracts text from the right side of a string<br \/>\nD) Joins two or more text strings  <\/p>\n<p>Answer: B<br \/>\nExplanation: The LEN function calculates the length of a text string, including spaces, which is useful for determining the number of characters.<\/p>\n<p>Question 2:<br \/>\nWhich function extracts a specified number of characters from the beginning of a text string?<br \/>\nA) RIGHT<br \/>\nB) MID<br \/>\nC) LEFT<br \/>\nD) TRIM  <\/p>\n<p>Answer: C<br \/>\nExplanation: The LEFT function takes a text string and a number of characters as arguments, returning the substring from the start.<\/p>\n<p>Question 3:<br \/>\nWhat is the purpose of the RIGHT function?<br \/>\nA) Converts text to proper case<br \/>\nB) Extracts characters from the end of a text string<br \/>\nC) Finds the position of a substring<br \/>\nD) Replaces text in a string  <\/p>\n<p>Answer: B<br \/>\nExplanation: The RIGHT function extracts a specified number of characters from the end of a text string.<\/p>\n<p>Question 4:<br \/>\nHow does the MID function work?<br \/>\nA) It returns the middle character of a string<br \/>\nB) It extracts a substring from any position in a text string<br \/>\nC) It converts text to uppercase<br \/>\nD) It removes extra spaces from text  <\/p>\n<p>Answer: B<br \/>\nExplanation: The MID function requires a text string, a starting position, and the number of characters to extract, allowing for flexible substring retrieval.<\/p>\n<p>Question 5:<br \/>\nWhat does the UPPER function do?<br \/>\nA) Converts all letters in a text string to uppercase<br \/>\nB) Trims spaces from a string<br \/>\nC) Searches for a substring<br \/>\nD) Concatenates strings  <\/p>\n<p>Answer: A<br \/>\nExplanation: The UPPER function changes all lowercase letters in a text string to uppercase, while leaving other characters unchanged.<\/p>\n<p>Question 6:<br \/>\nWhich function is used to convert text to lowercase?<br \/>\nA) PROPER<br \/>\nB) LOWER<br \/>\nC) LEN<br \/>\nD) SUBSTITUTE  <\/p>\n<p>Answer: B<br \/>\nExplanation: The LOWER function converts all uppercase letters in a text string to lowercase, making text uniform.<\/p>\n<p>Question 7:<br \/>\nWhat is the main function of the PROPER function?<br \/>\nA) Capitalizes the first letter of each word in a text string<br \/>\nB) Replaces occurrences of a substring<br \/>\nC) Finds the exact position of text<br \/>\nD) Joins text with a delimiter  <\/p>\n<p>Answer: A<br \/>\nExplanation: The PROPER function capitalizes the first letter of each word and converts the rest to lowercase, useful for titles.<\/p>\n<p>Question 8:<br \/>\nHow does the TRIM function help with text?<br \/>\nA) It removes all spaces from a text string<br \/>\nB) It eliminates extra spaces between words but keeps single spaces<br \/>\nC) It converts text to a numerical value<br \/>\nD) It extracts the first word  <\/p>\n<p>Answer: B<br \/>\nExplanation: The TRIM function cleans text by removing leading, trailing, and extra spaces between words, improving readability.<\/p>\n<p>Question 9:<br \/>\nWhat does the FIND function do?<br \/>\nA) Locates the position of a substring within a text string (case-sensitive)<br \/>\nB) Replaces text in a string<br \/>\nC) Converts numbers to text<br \/>\nD) Joins multiple strings  <\/p>\n<p>Answer: A<br \/>\nExplanation: The FIND function returns the starting position of one text string within another, and it is case-sensitive.<\/p>\n<p>Question 10:<br \/>\nWhich function is similar to FIND but is not case-sensitive?<br \/>\nA) SEARCH<br \/>\nB) REPLACE<br \/>\nC) LEN<br \/>\nD) MID  <\/p>\n<p>Answer: A<br \/>\nExplanation: The SEARCH function works like FIND but ignores case, making it more flexible for text searches.<\/p>\n<p>Question 11:<br \/>\nWhat is the purpose of the REPLACE function?<br \/>\nA) It substitutes one substring for another in a text string<br \/>\nB) It replaces a portion of a text string based on position<br \/>\nC) It concatenates strings without a delimiter<br \/>\nD) It trims excess characters  <\/p>\n<p>Answer: B<br \/>\nExplanation: The REPLACE function changes characters in a text string by specifying the start position, number of characters, and new text.<\/p>\n<p>Question 12:<br \/>\nHow does the SUBSTITUTE function differ from REPLACE?<br \/>\nA) SUBSTITUTE replaces all occurrences of a substring, while REPLACE targets a specific position<br \/>\nB) SUBSTITUTE only works on numbers<br \/>\nC) REPLACE is case-sensitive only<br \/>\nD) SUBSTITUTE adds text instead of replacing  <\/p>\n<p>Answer: A<br \/>\nExplanation: The SUBSTITUTE function replaces all instances of a specified substring with new text, unlike REPLACE which targets a fixed position.<\/p>\n<p>Question 13:<br \/>\nWhat does the CONCATENATE function do?<br \/>\nA) It joins two or more text strings into one<br \/>\nB) It splits a text string into parts<br \/>\nC) It converts text to a date<br \/>\nD) It finds the length of text  <\/p>\n<p>Answer: A<br \/>\nExplanation: The CONCATENATE function combines multiple strings or values into a single text string.<\/p>\n<p>Question 14:<br \/>\nIn Excel, which function can join text with a specified delimiter?<br \/>\nA) TEXTJOIN<br \/>\nB) MID<br \/>\nC) LEFT<br \/>\nD) UPPER  <\/p>\n<p>Answer: A<br \/>\nExplanation: The TEXTJOIN function concatenates a range or array of strings with a delimiter, such as a comma or space.<\/p>\n<p>Question 15:<br \/>\nWhat is the role of the TEXT function?<br \/>\nA) It formats a number or date as text with a specified format<br \/>\nB) It extracts text from a cell<br \/>\nC) It converts text to a number<br \/>\nD) It searches for patterns  <\/p>\n<p>Answer: A<br \/>\nExplanation: The TEXT function converts a value to text in a specific number format, like currency or date, for display purposes.<\/p>\n<p>Question 16:<br \/>\nIf you want to remove non-printable characters from text, which function might you use?<br \/>\nA) CLEAN<br \/>\nB) TRIM<br \/>\nC) PROPER<br \/>\nD) LEN  <\/p>\n<p>Answer: A<br \/>\nExplanation: The CLEAN function removes non-printable characters from text, which is helpful when importing data from other sources.<\/p>\n<p>Question 17:<br \/>\nHow can you use the EXACT function with text?<br \/>\nA) It compares two text strings and returns TRUE if they are exactly the same<br \/>\nB) It extracts exact substrings<br \/>\nC) It exactly replaces text<br \/>\nD) It exactly formats numbers  <\/p>\n<p>Answer: A<br \/>\nExplanation: The EXACT function performs a case-sensitive comparison of two text strings and returns TRUE or FALSE.<\/p>\n<p>Question 18:<br \/>\nWhat does the VALUE function do in relation to text?<br \/>\nA) It converts a text string that represents a number to a numeric value<br \/>\nB) It values the length of text<br \/>\nC) It adds values to text<br \/>\nD) It substitutes values in strings  <\/p>\n<p>Answer: A<br \/>\nExplanation: The VALUE function turns text that looks like a number into an actual numeric value for calculations.<\/p>\n<p>Question 19:<br \/>\nWhich function is best for repeating a text string a certain number of times?<br \/>\nA) REPT<br \/>\nB) CONCATENATE<br \/>\nC) MID<br \/>\nD) SEARCH  <\/p>\n<p>Answer: A<br \/>\nExplanation: The REPT function repeats a text string a specified number of times, useful for creating patterns or padding.<\/p>\n<p>Question 20:<br \/>\nIn a formula, how would you combine the LEFT and LEN functions?<br \/>\nA) To extract all characters except the last one from a string<br \/>\nB) To find the total length and then trim text<br \/>\nC) To convert the result to uppercase<br \/>\nD) To search within the extracted text  <\/p>\n<p>Answer: A<br \/>\nExplanation: Using LEFT with LEN can extract a substring by taking the full length minus a specified number, such as removing the last character.<\/p>\n<\/div>\n<p><button id=\"copyquestionsBtn\" type=\"button\" onclick=\"myFunction()\">Copy Quiz Questions<\/button>\u00a0\u00a0or\u00a0\u00a0<button id=\"genquestionsBtn\" class=\"genbtnstyle\" type=\"button\" onclick=\"myFunction1()\">Generate Questions using AI<\/button><\/p>\n<h3 id=\"3\">Part 3: OnlineExamMaker AI Question Generator: Generate Questions for Any Topic<\/h3>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/zlqho9igH2Y\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">Automatically generate questions using AI<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html?refer=download_questions\" target=\"_blank\" rel=\"noopener\">Try AI Question Generator<\/a><\/div>\n<div class=\"p-style-b\">Generate questions for any topic<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> Create A Quiz<\/a><\/div>\n<div class=\"p-style-b\">100% free forever<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><script src=\"https:\/\/unpkg.com\/@popperjs\/core@2\"><\/script><br \/>\n<script src=\"https:\/\/unpkg.com\/tippy.js@6\"><\/script><\/p>\n<p><script type=\"text\/javascript\">\nfunction myFunction() {\nvar copyText = document.getElementById(\"copy_questions\");console.log(copyText.innerText);navigator.clipboard.writeText(copyText.innerText);\n}\nfunction myFunction1() {\n\u00a0  \u00a0 \u00a0 window.open(\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html\");\n\u00a0 }\nvar copy1, copy2;\n        tippy('#copyquestionsBtn', {\n        'content': \"Copy questions to clipboard\",\n       trigger: 'mouseenter',\n       'onCreate':function(instance){\n              copy1 = instance;\n       },\n       'onTrigger' : function(instance, event) {\n              copy2.hide();\n       }\n       });\n       tippy('#copyquestionsBtn', {\n       'content': \"Copied successfully\",\n       trigger: 'click',\n       'onCreate':function(instance){\n              copy2 = instance;\n       },\n       'onTrigger' : function(instance, event) {\n              copy1.hide();\n       }\n       });\ntippy('#genquestionsBtn', {\n        'content': \"Generate questions using AI for free\",\n         trigger: 'mouseenter'\n       });\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;s text functions are essential tools for manipulating and analyzing string data. Below is a concise overview of key text functions, categorized for clarity: Basic String Extraction Functions &#8211; LEFT(text, [num_chars]): Extracts a specified number of characters from the beginning of a text string. Example: `=LEFT(A1, 3)` gets the first three characters from cell A1. [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":83994,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[353],"tags":[],"class_list":["post-84118","post","type-post","status-publish","format-standard","hentry","category-questions-answers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>20 Excel Text Functions Quiz Questions and Answers - OnlineExamMaker Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"20 Excel Text Functions Quiz Questions and Answers - OnlineExamMaker Blog\" \/>\n<meta property=\"og:description\" content=\"Excel&#8217;s text functions are essential tools for manipulating and analyzing string data. Below is a concise overview of key text functions, categorized for clarity: Basic String Extraction Functions &#8211; LEFT(text, [num_chars]): Extracts a specified number of characters from the beginning of a text string. Example: `=LEFT(A1, 3)` gets the first three characters from cell A1. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/\" \/>\n<meta property=\"og:site_name\" content=\"OnlineExamMaker Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-11T06:40:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2026\/01\/2709-Excel-Text-Functions-quiz.webp\" \/>\n<meta name=\"author\" content=\"Rebecca\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rebecca\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/\",\"name\":\"20 Excel Text Functions Quiz Questions and Answers - OnlineExamMaker Blog\",\"isPartOf\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\"},\"datePublished\":\"2025-11-11T06:40:14+00:00\",\"dateModified\":\"2025-11-11T06:40:14+00:00\",\"author\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineexammaker.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"20 Excel Text Functions Quiz Questions and Answers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/\",\"name\":\"OnlineExamMaker Blog\",\"description\":\"OnlineExamMaker\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2\",\"name\":\"Rebecca\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g\",\"caption\":\"Rebecca\"},\"url\":\"https:\/\/onlineexammaker.com\/kb\/author\/rebeccaoem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"20 Excel Text Functions Quiz Questions and Answers - OnlineExamMaker Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/","og_locale":"en_US","og_type":"article","og_title":"20 Excel Text Functions Quiz Questions and Answers - OnlineExamMaker Blog","og_description":"Excel&#8217;s text functions are essential tools for manipulating and analyzing string data. Below is a concise overview of key text functions, categorized for clarity: Basic String Extraction Functions &#8211; LEFT(text, [num_chars]): Extracts a specified number of characters from the beginning of a text string. Example: `=LEFT(A1, 3)` gets the first three characters from cell A1. [&hellip;]","og_url":"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/","og_site_name":"OnlineExamMaker Blog","article_published_time":"2025-11-11T06:40:14+00:00","og_image":[{"url":"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2026\/01\/2709-Excel-Text-Functions-quiz.webp"}],"author":"Rebecca","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rebecca","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/","url":"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/","name":"20 Excel Text Functions Quiz Questions and Answers - OnlineExamMaker Blog","isPartOf":{"@id":"https:\/\/onlineexammaker.com\/kb\/#website"},"datePublished":"2025-11-11T06:40:14+00:00","dateModified":"2025-11-11T06:40:14+00:00","author":{"@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2"},"breadcrumb":{"@id":"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineexammaker.com\/kb\/20-excel-text-functions-quiz-questions-and-answers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineexammaker.com\/kb\/"},{"@type":"ListItem","position":2,"name":"20 Excel Text Functions Quiz Questions and Answers"}]},{"@type":"WebSite","@id":"https:\/\/onlineexammaker.com\/kb\/#website","url":"https:\/\/onlineexammaker.com\/kb\/","name":"OnlineExamMaker Blog","description":"OnlineExamMaker","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2","name":"Rebecca","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g","caption":"Rebecca"},"url":"https:\/\/onlineexammaker.com\/kb\/author\/rebeccaoem\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/84118"}],"collection":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/comments?post=84118"}],"version-history":[{"count":0,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/84118\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media\/83994"}],"wp:attachment":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media?parent=84118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/categories?post=84118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/tags?post=84118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}