DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Can you format text with Excel
|
|
Yes
|
|
|
No
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -And we put quotes around Yes. The quotes ensure that Excel evaluates the word Yes as text. Next, we click Format, select the fill color we want, click OK, and click OK again.
Detailed explanation-2: -Our Conditional Formatting rule, then only has to look for the text string “YES” and apply the formatting when true. Highlight the cell range, Click on Conditional Formatting > Highlight Cell Rules > Text that Contains to create the Rule, then type YES in the Text that Contains dialog box.
Detailed explanation-3: -Select the cell you want to format. In the formula bar, select the text you want to format. Select the text formatting you want to use. Press Enter.
There is 1 question to complete.