USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Conditional Formatting
|
|
|
Styles
|
|
|
Table Formatting
|
|
|
Themes
|
Detailed explanation-1: -You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can format a whole cell range and vary the exact format as the value of each cell varies.
Detailed explanation-2: -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-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.