Using Logical Functions to Apply Conditional Formatting
Über den Vortrag
Der Vortrag „Using Logical Functions to Apply Conditional Formatting“ von Sonic Performance ist Bestandteil des Kurses „Data Analysis in Excel 2016 (EN)“.
Quiz zum Vortrag
What differentiates tables from data ranges?
- Tables are independent objects.
- Tables can contain any type of cell data.
- You can define a name for a table.
- You can sort and filter tables.
Which of the following statements are true regarding conditional formatting?
- Excel cannot display the background fills for two different sets of conditional formatting in the same cell simultaneously.
- Excel can display icon sets in front of background fills.
- Rule precedence determines which rule will prevail when there are conflicts.
- Excel doesn't apply any conditional formatting when there are conflicts among rules.
- Excel does not support custom conditional formatting.
Conditional formatting cannot be applied to cells that reference other cells.
- False
- True
What differentiates tables from data ranges?
- Tables are independent objects.
- Tables can contain any type of cell data.
- You can define a name for a table.
- You can sort and filter tables.
Which of the following statements are true regarding conditional formatting?
- Excel cannot display the background fills for two different sets of conditional formatting in the same cell simultaneously.
- Excel can display icon sets in front of background fills.
- Rule precedence determines which rule will prevail when there are conflicts.
- Excel doesn't apply any conditional formatting when there are conflicts among rules.
- Excel does not support custom conditional formatting.
Conditional formatting cannot be applied to cells that reference other cells.
- False
- True
Diese Kurse könnten Sie interessieren
Dozent des Vortrages Using Logical Functions to Apply Conditional Formatting
Sonic Performance
Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.
All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.
Kundenrezensionen
5,0 von 5 Sternen
| 5 Sterne |
|
5 |
| 4 Sterne |
|
0 |
| 3 Sterne |
|
0 |
| 2 Sterne |
|
0 |
| 1 Stern |
|
0 |
