DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
To use a formatting that is applied to a cell when a specified condition is met.
|
|
|
To copy the contents of a cell to adjacent cells
|
|
|
To display the active cell’s contents.
|
|
|
None of the answers
|
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 (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. For example, you can have a cell appear bold only when the value of the cell is greater than 100.
Detailed explanation-3: -Conditional Formatting option is used to highlight data according to criteria. The auto filter option is available under the editing group.
Detailed explanation-4: -Conditional formatting allows users to automatically apply formattings such as colours, icons, and data bars to one or more cells based on the cell value. To do Conditional formatting, users need to create a conditional formatting rule.