DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
to extract characters from the left/beginning/front of the text data as many as the number of characters taken
|
|
|
to retrieve characters from the right/back/end of the text data as many as the number of characters taken.
|
|
|
to place and manage text-type data on an Ms-Excel worksheet
|
|
|
to take from left to center based on the initial character as many as the number of characters taken
|
Detailed explanation-1: -What is the Excel TEXT Function? The Excel TEXT Function[1] is used to convert numbers to text within a spreadsheet. Essentially, the function will convert a numeric value into a text string. TEXT is available in all versions of Excel.
Detailed explanation-2: -String functions are part of the Excel program you can use to alter, locate or measure strings. In Excel, strings are blocks of text that appear within the spreadsheet. These can include names of people, products, email addresses, names of cities and numbers.
Detailed explanation-3: -We often hear that you want to make data easier to understand by including text in your formulas, such as “2, 347 units sold.” To include text in your functions and formulas, surround the text with double quotes ("").
Detailed explanation-4: -A text string, also known as a string or simply as text, is a group of characters that are used as data in a spreadsheet program. Text strings are most often comprised of words, but may also include letters, numbers, special characters, the dash symbol, or the number sign.
Detailed explanation-5: -Description. Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.