USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is another name for the condition used in conditional formatting?
|
|
Specifics
|
|
|
Criteria
|
|
|
Labels
|
|
|
Situation
|
Explanation:
Detailed explanation-1: -Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.
Detailed explanation-2: -Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.
Detailed explanation-3: -You can include up to three different conditions on any cell or range of cells.
There is 1 question to complete.