DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
conditional formatting
|
|
|
format as table
|
|
|
cell styles
|
|
|
creating themes
|
Detailed explanation-1: -Conditional formatting helps you visually explore and analyze data, detect critical issues, and identify patterns and trends. It makes it easier to highlight interesting cells or a range of cells, emphasize unusual values, and visualize data by using color scales.
Detailed explanation-2: -Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting, point to Highlight Cells Rules, and then click Text that Contains. In the box next to containing, type the text that you want to highlight, and then click OK.
Detailed explanation-3: -If your formula refers to a wrong cell, a mismatch between the active cell and the formula will occur, which will result in conditional formatting highlighting wrong cells.
Detailed explanation-4: -Conditional formatting allows you to automatically apply formatting-such as colors, icons, and data bars-to one or more cells based on the cell value. To do this, you’ll need to create a conditional formatting rule.