DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Borders
|
|
|
Cell style
|
|
|
Conditional Formatting
|
|
|
Format as table
|
Detailed explanation-1: -Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.
Detailed explanation-2: -Highlight your cell or range of cells. From the Format menu, select Conditional Formatting… In the Conditional formatting dialog, select Cell Value Is in the first drop-down box. Select a cell evaluator from the second drop down box.
Detailed explanation-3: -Excel’s predefined conditional formatting, such as Data Bars, Color Scales and Icon Sets, are mainly purposed to format cells based on their own values. If you want to apply conditional formatting based on another cell or format an entire row based on a single cell’s value, then you will need to use formulas.