DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -length method= len() => It’s return number of element from value of variable. count method = count() =>It’s return how many times appeared from value of variable which you are specified value.
Detailed explanation-2: -LEN function in excel is taken from the length and is used to count the number of characters is there in a cell. It considers special characters, spaces and alphabets and counts all these values if there is a selected cell. LEN function only counts the character length for only one cell.
Detailed explanation-3: -The statement is true. The function is a specific operation performed on any object. The function LEN as its name implies returns the output as the length of that particular object.
Detailed explanation-4: -For removing the last n characters from a text string, we can use a formula based on the LEFT and LEN functions. We can use a formula to strip the last 5 characters of a value, starting on the left. The formula to use will be =VALUE(LEFT(D5, LEN(D5)-6)).