USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Export
|
|
|
Cell Reference
|
|
|
Conditional Formatting
|
|
|
Worksheet
|
Detailed explanation-1: -Excel Conditional Formatting is used to apply certain formatting to data that meets one or more conditions. Just like usual cell formatting, it lets you highlight and differentiate your data in various ways by changing cells’ fill color, font color, border styles, etc.
Detailed explanation-2: -Format Entire Row with Conditional Formatting In Microsoft Excel, with a few easy steps, you can apply conditional formatting that checks the value in one cell, and applies formatting to other cells, based on that value. For example, if the values in column B greater than 75, make all data cells in the same row blue.
Detailed explanation-3: -One of the methods to achieve Conditional formatting based on a custom formula is using the IF statement. The IF function works on the IF/THEN/ELSE condition syntax.