USING MICROSOFT EXCEL
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 can be used to highlight interesting cells, emphasize unusual values, and visualize data using data bars, color scales, and icon sets based on specific criteria. Excel has several built in conditions you should explore.
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.
Detailed explanation-5: -On the Home tab of the ribbon, click Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. Select ‘Use a formula to determine which cells to format’. Activate the Font tab. Select red.