USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
APPLES ARE RED
|
|
|
Apples Are Red
|
|
|
aPPLES aRE rED
|
|
|
apples are red
|
Detailed explanation-1: -To check if a cell contains text, select the output cell, and use the following formula: =IF(ISTEXT(cell), value to return, “"). For our example, the cell we want to check is A2, and the return value will be Yes. In this scenario, you’d change the formula to =IF(ISTEXT(A2), “Yes", “").
Detailed explanation-2: -Description. Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
Detailed explanation-3: -This indicates that the cell selected. will be equal to the result of a specified calculation. For example, clicking in a cell and typing =A1+A2 means that the value of the cell you selected will equal the value of cell A1 plus the value of cell A2.