DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Conditional formatting automatically applies different formats depending on conditions you specify. The formatting is updated if you change any data in the worksheet.
Detailed explanation-2: -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-3: -When you modify the formatting of a style, what happens to cells to which the style was already applied? They automatically reflect the new formatting.
Detailed explanation-4: -Formatting a number does not affect the actual value (in the cell) but just changes how the value is displayed. Any formulas will always use the actual value and not the value that is displayed. The actual value stored in a cell is the value used in your formulas and is not the value that is displayed.